At a Glance
- Tasks: Support delivery of reporting and analytics solutions for clients using Excel, Power BI, and SQL.
- Company: Specialist software implementation and consultancy company focused on data solutions.
- Benefits: Salary between £30,000 - £40,000, ongoing training, and clear career progression.
- Other info: Join a supportive team with mentoring from experienced consultants and growth opportunities.
- Why this job: Gain hands-on experience with real-world data and develop your skills in business intelligence.
- Qualifications: Strong Excel skills and a logical mindset; SQL and Power BI experience is a plus.
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: 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.
Please click the APPLY button to send your CV and covering letter for this role.
Locations
Junior / Mid-Level Data & Reporting Consultant in Hull, North East employer: Reality Solutions Ltd
Contact Detail:
Reality Solutions Ltd Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Junior / Mid-Level Data & Reporting Consultant in Hull, North East
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend local meetups or webinars, and connect with potential colleagues on LinkedIn. 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 related to data analysis and reporting. Think about how your Excel skills can solve real-world problems and be ready to share examples of your work. Confidence is key!
✨Tip Number 3
Showcase your skills through a portfolio! Create a few sample reports or dashboards using Excel or Power BI that demonstrate your analytical abilities. This will give you an edge and show potential employers what you can do.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are genuinely interested in joining our team.
We think you need these skills to ace Junior / Mid-Level Data & Reporting Consultant in Hull, North East
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your strong Microsoft Excel skills and any relevant experience with data reporting. We want to see how your background aligns with the role, so don’t be shy about showcasing your analytical mindset!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're interested in the Junior / Mid-Level Data & Reporting Consultant role and how your skills can help us deliver top-notch reporting solutions for our clients.
Showcase Your Data Skills: If you have experience with SQL or Power BI, make sure to mention it! Even if you’re still learning, we appreciate enthusiasm for developing these skills. Let us know how you’ve worked with data in the past!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity to join our team!
How to prepare for a job interview at Reality Solutions Ltd
✨Master Your Excel Skills
Since this role heavily relies on Microsoft Excel, make sure you brush up on your advanced formulas, pivot tables, and data validation techniques. Practise creating reports and data models that showcase your analytical skills, as this will demonstrate your readiness for the job.
✨Understand the Company and Its Tools
Familiarise yourself with Sage 200 and the types of reporting solutions they offer. Even if you haven't worked with these tools before, showing that you've done your homework will impress the interviewers and show your genuine interest in the role.
✨Prepare for Customer Interaction
This position is customer-facing, so be ready to discuss how you would approach understanding client needs and challenges. Think of examples from your past experiences where you successfully communicated with clients or solved their problems, as this will highlight your communication skills.
✨Show Your Willingness to Learn
Since training in SQL and Power BI will be provided, express your eagerness to develop these skills. Share any relevant experiences or courses you've taken that demonstrate your commitment to continuous learning and growth in the field of data and analytics.