At a Glance
- Tasks: Create impactful reports and insights to drive key business decisions.
- Company: Join a dynamic team at a forward-thinking company in Bolton.
- Benefits: Enjoy hybrid work, competitive salary, and opportunities for professional growth.
- Other info: Be part of a supportive team with excellent career advancement opportunities.
- Why this job: Shape reporting solutions and automate processes while making a real difference.
- Qualifications: Experience with Power BI, SQL Server, and strong analytical skills required.
The predicted salary is between 35000 - 45000 £ per year.
We are looking for a talented and detail driven MI Analyst to join our growing MI team. This role is pivotal in delivering high quality reporting and insight to support key business decisions. You will be responsible for the development and maintenance of data marts, ensuring they are robust, reliable, and scalable, alongside delivering business as usual reporting requirements. This is an opportunity to play a key role in shaping reporting solutions, driving automation, and producing meaningful analysis that identifies trends and patterns across the business.
Key Responsibilities
- Delivery & BAU Reporting
- Produce weekly and monthly reports for internal and external stakeholders
- Create and maintain ad hoc reports
- Balance project work with day-to-day reporting to meet deadlines
- Review existing reporting to reduce duplication and improve efficiency
- Technical Development
- Develop and maintain data marts and warehouses using SQL Server
- Build and maintain reporting solutions in Power BI (Microsoft Fabric) and SSRS
- Lead automation and scheduling of standardised reporting
- Ensure all outputs align with team and company standards
- Troubleshoot and resolve production issues quickly and effectively
- Stakeholder Management
- Gather and document business requirements
- Engage stakeholders using workshops, interviews and other methods
- Promote MI capabilities across the business
- Build and maintain strong relationships with internal and external stakeholders
- Provide guidance and support to stakeholders on reporting solutions
- Team & Continuous Improvement
- Support and mentor junior team members
- Stay up to date with industry tools, techniques and trends
- Recommend and implement improvements
- Act as a role model within the team
- Compliance & Quality
- Ensure data accuracy, consistency and governance standards are met
- Maintain awareness of GDPR, Data Protection Act 2018, ISO 27001, and SOX
- Follow departmental standards, processes and best practices
- Contribute to continuous improvement initiatives
Skills & Experience
Essential
- Experience building reports in Power BI (Fabric preferred)
- Experience with SSRS reporting
- Working knowledge of SQL Server (2016+) and T-SQL
- Experience working with multiple data sources and platforms
- Previous experience in an MI / BI reporting role
- Advanced Excel skills
- Strong understanding of relational databases
- Excellent stakeholder engagement skills
- Strong analytical and problem-solving abilities
- Ability to manage multiple priorities and deliver to deadlines
Desirable
- Experience with Azure Data Factory (ADF)
- Experience with Power Automate
- Advanced SQL development (stored procedures, performance tuning)
- Data modelling experience
- Experience mentoring or supporting junior team members
- Aware of emerging BI and analytics technologies
- Understanding of ISO 27001 and SOX environments
Qualifications
Required
- GCSE (or equivalent) in English and Maths
Desirable
- Degree (2:1 or above)
- BCS Diploma in IT or Database Development
- Microsoft certifications (e.g. PL-300, DP-600)
MI Analyst in Bolton employer: ExamWorks Group
Join our dynamic team as an MI Analyst in Horwich, Bolton, where we prioritise a collaborative work culture that fosters innovation and continuous improvement. We offer a hybrid working model, competitive benefits, and ample opportunities for professional growth, ensuring you can thrive while contributing to impactful business decisions. With a focus on mentorship and skill development, you'll be empowered to shape reporting solutions and drive automation in a supportive environment.
StudySmarter Expert Advice🤫
We think this is how you could land MI Analyst in Bolton
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect 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 MI Analyst questions. Get comfortable talking about your experience with Power BI, SQL Server, and stakeholder engagement. The more you rehearse, the more confident you'll feel!
✨Tip Number 3
Showcase your skills through a portfolio! Create sample reports or dashboards that highlight your analytical abilities and technical expertise. This will give potential employers a taste of what you can bring to the table.
✨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 proactive about their job search!
We think you need these skills to ace MI Analyst in Bolton
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experience mentioned in the job description. Highlight your experience with Power BI, SQL Server, and any relevant reporting roles. We want to see how you can bring value to our MI team!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about the MI Analyst role and how your background aligns with our needs. Don’t forget to mention any specific projects or achievements that showcase your analytical skills.
Showcase Your Technical Skills:Since this role involves technical development, be sure to highlight your experience with data marts, SQL, and reporting tools like Power BI. We love seeing examples of how you've used these skills to solve problems or improve processes in previous roles.
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to keep track of your application status. Plus, we love seeing candidates who take the initiative to connect with us directly!
How to prepare for a job interview at ExamWorks Group
✨Know Your Tools
Make sure you’re familiar with Power BI, SQL Server, and SSRS before the interview. Brush up on your technical skills and be ready to discuss how you've used these tools in past roles. This will show that you’re not just a theoretical candidate but someone who can hit the ground running.
✨Showcase Your Reporting Skills
Prepare examples of reports you've created or improved in previous positions. Be ready to explain the impact of your work on decision-making processes. This will demonstrate your ability to deliver high-quality reporting and insight, which is crucial for the MI Analyst role.
✨Engage Stakeholders
Think about how you’ve gathered business requirements in the past. Be prepared to discuss your approach to stakeholder engagement, including any workshops or interviews you've conducted. This will highlight your strong communication skills and ability to build relationships, which are key for this position.
✨Continuous Improvement Mindset
Show that you’re committed to continuous improvement by discussing any initiatives you’ve led or been part of. Mention how you stay updated with industry trends and tools. This will reflect your proactive attitude and willingness to contribute to the team’s success.
