MI & Analytics Assistant Manager- 12 Month FTC

KPMG United Kingdom; Birmingham; On-site; GBP 45,000 - 65,000; Full time

Job summary

A leading consulting firm in Birmingham is seeking an MI & Analytics Assistant Manager. The role involves designing and maintaining reports and dashboards, supporting clients with data-driven solutions. Candidates should have advanced Excel and Power BI skills, with a strong background in reporting development. This is an opportunity to develop technical and consulting capabilities in a collaborative environment. If you are passionate about data analytics and committed to team success, apply now.

Qualifications

• Demonstrable experience in a reporting development role.
• Advanced proficiency in Microsoft Excel, including pivot tables.
• Proven experience in designing and creating dashboards in Power BI.

Responsibilities

• Design and maintain reports for stakeholders and clients.
• Create bespoke client dashboards using Power BI.
• Conduct ad-hoc analysis to support decision-making.
• Manage data quality initiatives for report integrity.

Skills

Reporting development experience

Advanced Microsoft Excel

MS SQL Server Management Studio (SSMS)

Power BI dashboard design

Analytical skills

Excellent communication skills

Ability to gather business requirements

Tools

Power BI

Microsoft Excel

SQL

Job description

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

Job description

About the Team:

Our team is at the forefront of helping clients understand the impact of learning within their organisations through sophisticated data analytics and reporting. We work with a range of clients across sectors, leveraging Excel and Power BI to deliver high-quality, flexible, and bespoke analytics and reporting solutions. With team members spread across several locations, we foster a collaborative and supportive environment where innovation and continuous learning are key. If you enjoy transforming raw data into insightful reports and robust models, you'll find your home here.

The Opportunity:

This is an exceptional opportunity to further develop your technical and consulting skills within a leading global firm. As a MI & Analytics Assistant Manager, you will:

• Work closely with diverse teams across our learning business, providing data-driven solutions to our clients and learning business.
• Build relationships with our clients and become a key reporting contact for some of our larger managed learning services clients.
• Become an SME for data and reporting within our business and act as MI workstreams lead on projects.
• Support senior team members in presenting deliverables to clients.
• Contribute to our business development initiatives and growth aspirations.
• Play a vital role in the development of the team by coaching and mentoring junior colleagues.

As a role model, the MI & Analytics Assistant Manager must embody KPMG's values and demonstrate a commitment toward the accomplishment of the team's goals.

Your work will be varied and impactful, including:

• Designing, developing, and maintaining a suite of reports for key stakeholders and clients, covering daily, weekly, and monthly reporting cycles.
• Creating and maintaining bespoke client dashboards using visualisation and analytical software, predominantly Power BI.
• Conducting ad-hoc analysis and providing data to enable informed decision-making, with a focus on transitioning these into long-term reporting capabilities.
• Managing data quality initiatives to ensure the integrity and accuracy of all reports.
• Developing tactical solutions to automate reporting processes and building robust data models to support analytics deliverables.
• Understanding the relationship between business processes and data flows and working with stakeholders to resolve reporting issues.
• Managing client access to external reporting, ensuring compliance with security and contractual requirements.

Leadership & Management:

The Analyst will be responsible for knowledge sharing and promotion of best practices within the team and to junior colleagues.

Stakeholder Interaction & challenges:

The nature of this role will have an important client facing aspect, so strong relationship building skills will be required.

Essential skills & experience

• Demonstratable experience in a reporting development role, ideally within a Management Information, Business Intelligence or Data and Analytics team.
• Advanced proficiency in Microsoft Excel, including pivot tables and advanced functions.
• Advanced knowledge of MS SQL Server Management Studio (SSMS) and T-SQL querying.
• Proven experience in designing and creating interactive dashboards in Power BI.
• Strong analytical and interpretive skills, with the ability to explain complex technical issues clearly to non-technical stakeholders.
• Demonstrated initiative, enthusiasm, and excellent communication skills (verbal and written).
• Ability to quickly assimilate and apply new techniques and knowledge.
• Experience in gathering business requirements to achieve reporting objectives.
• Due to the nature of the work, applicants should either hold or be capable of obtaining UK security clearance.

Desirable Skills & Experience

• Consulting experience.
• Experience working in a fast-paced environment.
• Experience working to month-end/year-end reporting deadlines.

You are someone who

• Is curious and open-minded, always seeking new ideas, approaches, and perspectives.
• Actively engages with others, valuing diverse views and concerns.
• Thrives on finding innovative solutions to complex problems.
• Embodies KPMG's values and demonstrates a commitment to team goals.

If you're ready to make a significant impact and contribute to a leading team, we encourage you to apply!