Data Analyst

About the job

Job Title: Data Analyst – Power BI & Microsoft Fabric
Location: Birmingham
Salary: £50,000 + Benefits
Contract Type: Full-time, Permanent

About the Role

We're recruiting for an experienced Data Analyst – Power BI & Microsoft Fabric to join the Information Systems team of a well-established professional services organisation in Birmingham.

This is an exciting opportunity for a data professional who enjoys transforming complex information into meaningful business insights and developing reporting solutions that support better decision-making.

You'll play a key role in developing and improving business intelligence and reporting capabilities across the organisation, creating interactive Power BI dashboards, improving data accuracy and supporting the transition of existing reporting processes into Microsoft Fabric.

Working closely with stakeholders across different business functions, you'll help shape how data is accessed, understood and used. You'll encourage greater adoption of self-service reporting, challenge existing approaches and identify opportunities to improve reporting efficiency, consistency and reliability.

This role would suit an experienced Data Analyst, BI Analyst, Reporting Analyst or Power BI Developer who combines strong technical reporting skills with commercial awareness, enjoys solving problems and is confident translating business requirements into practical data solutions.

With a salary of £50,000 plus benefits, this is an excellent opportunity to contribute to the development of modern reporting capabilities within an established professional services environment.

Key Responsibilities

Power BI Reporting & Dashboard Development

• Design, develop and maintain Power BI reports and interactive dashboards that provide meaningful insights into business performance.
• Translate complex datasets into clear, accessible and actionable management information.
• Work closely with business stakeholders to understand reporting requirements and develop effective reporting solutions.
• Monitor and review reporting metrics to ensure they remain aligned with business processes, KPIs and organisational objectives.
• Support the development of consistent, reliable and user-friendly reporting across different business functions.
• Identify opportunities to improve existing dashboards, reports and reporting processes.

Microsoft Fabric & Reporting Transformation

• Support the consolidation and migration of existing reports and reporting processes into Microsoft Fabric.
• Contribute to the development of modern business intelligence and reporting capabilities.
• Review existing reporting methods and identify opportunities to streamline and improve how information is delivered.
• Encourage greater adoption of self-service reporting across the organisation.
• Challenge existing reporting approaches and recommend practical improvements that support business requirements.
• Collaborate with wider technology and business teams to support ongoing reporting improvements.

Data Analysis, Quality & Accuracy

• Perform data profiling and analysis to identify anomalies, inconsistencies and opportunities for improvement.
• Ensure the accuracy, completeness and reliability of data used across reporting platforms.
• Use SQL, relational databases and advanced Microsoft Excel to analyse and interpret complex datasets.
• Investigate data quality issues and work collaboratively with relevant teams to support their resolution.
• Support the development of streamlined and consistent reporting processes.
• Identify opportunities to improve data reliability and the overall quality of management information.

Stakeholder Engagement & Business Intelligence

• Build effective relationships with stakeholders across multiple business functions.
• Gather, understand and translate business reporting requirements into practical technical solutions.
• Communicate complex data findings clearly to both technical and non-technical audiences.
• Provide analytical insight that supports business performance monitoring and informed decision-making.
• Use data and reporting insights to identify trends, challenges and opportunities for improvement.
• Support stakeholders in understanding and making effective use of business intelligence reports and dashboards.

Continuous Improvement & Collaboration

• Take a proactive approach to identifying opportunities to improve reporting and analytical capabilities.
• Challenge existing processes and recommend more effective approaches to data analysis and reporting.
• Collaborate with the wider Information Systems team to support reporting development and improvement initiatives.
• Manage multiple reporting requirements and projects while maintaining accuracy and meeting deadlines.
• Contribute ideas and practical solutions that strengthen the organisation's use of data.

Candidate Profile

• Proven experience in a Data Analyst, Reporting Analyst, Business Intelligence Analyst or similar position.
• Strong experience developing reports and interactive dashboards using Microsoft Power BI.
• Good working knowledge of SQL and relational databases.
• Advanced Microsoft Excel skills, with the ability to analyse and interpret complex datasets.
• Experience working with business performance metrics, KPIs and management reporting.
• Strong analytical and problem-solving skills with excellent attention to detail.
• Ability to understand business requirements and translate them into practical reporting solutions.
• Confident communicating data insights to stakeholders at different levels of an organisation.
• Strong organisational skills with the ability to manage multiple priorities and deadlines.
• Proactive, self-motivated and comfortable taking ownership of reporting requirements.
• Collaborative approach with the ability to build effective relationships across different departments.
• Commercial awareness and an understanding of how effective reporting supports business performance.

Desirable Experience

• Experience working with Microsoft Fabric and modern data analytics platforms.
• Exposure to reporting migrations, consolidation projects or business intelligence transformation initiatives.
• Experience developing or supporting self-service business intelligence solutions.
• Previous experience within professional services or another complex business environment.
• Experience improving data quality, reporting consistency or analytical processes across multiple departments.

We welcome applications from candidates of all backgrounds and are committed to inclusive and fair recruitment practices.

What Our Client Offers

• Salary of £50,000 plus benefits.
• Permanent, full-time position based in Birmingham.
• Opportunity to support the development of modern reporting and business intelligence capabilities.
• Exposure to Microsoft Fabric and evolving data technologies.
• Opportunity to work with stakeholders across multiple business functions.
• Collaborative working environment within an established Information Systems team.
• Scope to contribute ideas, challenge existing processes and influence how reporting is delivered across the organisation.
• Opportunities for ongoing professional development.

How to Apply

If you're an experienced Data Analyst, BI Analyst or Reporting Analyst with strong Power BI and SQL skills who enjoys using data to improve business performance, we'd love to hear from you.

This is an opportunity to help shape the future of business intelligence and reporting within an established professional services organisation.

Please apply with your CV or contact the PYVITAL team for a confidential discussion about this opportunity.

About Us

PYVITAL is a recruitment agency specialising in mid to senior-level roles across IT, Finance, Sales, Marketing, Operations, HR and professional services.

Our expertise and industry knowledge allow us to connect talented professionals with outstanding career opportunities, supporting both clients and candidates in achieving their long-term success.