At a Glance
- Tasks: Support clients with data reporting and analytics solutions, focusing on Excel and evolving into Power BI.
- Company: Specialist software consultancy with a focus on Sage 200 and data solutions.
- Benefits: Competitive salary, clear career progression, ongoing training, and a supportive team environment.
- Other info: Exciting opportunity for growth in a dynamic and collaborative setting.
- Why this job: Gain hands-on experience with real-world data and develop your skills in business intelligence.
- Qualifications: Strong Excel skills, analytical mindset, and a desire to learn SQL and Power BI.
The predicted salary is between 30000 - 40000 £ per year.
Location: Hull, UK (Office based)
Salary: £30,000 - £40,000 per annum, depending on experience
Job type: Full-time, Permanent
About us
We are a specialist software implementation and consultancy company delivering end to end business systems, with a strong focus on Sage 200 and complementary reporting and data solutions. As our customers increasingly look to better understand and use their data, we are growing our analytics capability and are looking for a data focused consultant to join our team.
The Role
As a Junior / Mid Level Data & Reporting Consultant, you will support the delivery of reporting and analytics solutions for external customers. You will work closely with clients and internal consultants to understand their data, prepare accurate reports, and help turn raw information into meaningful business insight. You’ll initially focus on Excel based reporting, data analysis, and validation, with the opportunity to grow into more advanced Power BI and SQL based solutions over time as your skills develop. This is a hands on, customer facing role offering exposure to real world business data and clear progression into business intelligence consultancy. This role is well suited to someone with strong Microsoft Excel skills, a logical and analytical mindset, and an interest in developing their career in data, reporting, and business intelligence. Experience with SQL and Power BI is beneficial but not essential, as training and development will be provided.
Key Responsibilities
- Build, maintain, and improve Excel based reports and data models for customers.
- Analyse and validate data from Sage 200 and other business systems.
- Work with customers to understand reporting needs and data challenges.
- Support the development of dashboards and visual reports (Excel and Power BI).
- Assist with data preparation, cleansing, and reconciliation tasks.
- Collaborate with senior consultants on BI and analytics projects.
- Produce clear documentation and provide user support and guidance.
- Learn and apply best practices around data accuracy, reporting, and insight.
About you
Skills & Experience:
- Strong Microsoft Excel skills, including:
- Advanced formulas
- Pivot tables
- Data validation and reconciliation
- Logical data structuring
- A data focused mindset with strong attention to detail and accuracy.
- Experience working with business data in a reporting, analyst, or systems environment.
- Comfortable working with numbers, trends, and large datasets.
- An interest in developing skills in SQL, Power BI, and business intelligence.
- SQL and/or Power BI experience is desirable but not essential.
- Any exposure to Sage 200 or ERP systems is an advantage, but not required.
- Good communication skills and confidence working with customers.
- Organised, methodical, and keen to learn.
What we offer
- Salary of £30,000 - £40,000 per annum, depending on experience.
- A clear development pathway into Business Intelligence and analytics.
- Hands on exposure to customer data and real world reporting challenges.
- Ongoing training in Excel, Power BI, SQL, and data best practices.
- Supportive team environment with mentoring from experienced consultants.
- Long term career progression as our data and analytics offering expands.
Junior / Mid-Level Data & Reporting Consultant employer: Onyx-Conseil
Join a dynamic and supportive team in Hull as a Junior / Mid-Level Data & Reporting Consultant, where you will have the opportunity to develop your skills in data analytics and reporting. With a clear pathway for career progression and ongoing training in essential tools like Excel, Power BI, and SQL, this role offers hands-on experience with real-world business data. Our collaborative work culture fosters growth and mentorship, making it an excellent place for those looking to build a meaningful career in data consultancy.
StudySmarter Expert Advice🤫
We think this is how you could land Junior / Mid-Level Data & Reporting Consultant
✨Tip Number 1
Network like a pro! Reach out to people in the industry on LinkedIn or at local meetups. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your Excel skills. We recommend doing mock interviews with friends or using online platforms to get comfortable with the process.
✨Tip Number 3
Showcase your passion for data! When chatting with potential employers, share your thoughts on recent trends in data analytics or any personal projects you've worked on. It’ll help you stand out from the crowd.
✨Tip Number 4
Don’t forget to apply through our website! We’re always on the lookout for talent, and applying directly can sometimes give you an edge. Plus, it shows you’re genuinely interested in joining our team!
We think you need these skills to ace Junior / Mid-Level Data & Reporting Consultant
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the job description. Highlight your strong Microsoft Excel skills and any relevant data experience to catch our eye!
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're passionate about data and reporting. Share specific examples of how you've used data to solve problems or improve processes in the past.
Show Your Enthusiasm for Learning:We love candidates who are eager to grow! Mention your interest in developing skills in SQL and Power BI, and how you’re excited about the training opportunities we offer.
Apply Through Our Website:For the best chance of getting noticed, apply directly through our website. It’s the quickest way for us to see your application and get you into the process!
How to prepare for a job interview at Onyx-Conseil
✨Master Your Excel Skills
Since the role heavily relies on Excel, brush up on your advanced formulas, pivot tables, and data validation techniques. Practising these skills will not only boost your confidence but also show the interviewers that you’re ready to hit the ground running.
✨Understand the Company’s Data Needs
Do some research on the company and its use of Sage 200 and other business systems. Familiarise yourself with common reporting challenges they might face. This will help you demonstrate your understanding of their needs and how you can contribute to solving them.
✨Prepare for Customer Interaction
As this is a customer-facing role, think about how you would communicate complex data insights to clients. Prepare examples of how you've successfully worked with customers in the past, showcasing your communication skills and ability to understand their requirements.
✨Show Your Willingness to Learn
Express your enthusiasm for developing skills in SQL and Power BI. Even if you don’t have extensive experience, showing a proactive attitude towards learning and growth will resonate well with the interviewers, especially since they offer training and development.
