Data Analyst (Power BI)

Do you thrive on building scalable data solutions and translating complex business requirements into meaningful insight? We’re looking for a Data Analyst with strong Power BI and Azure expertise to help shape and deliver a best-in-class data capability.

This is a fantastic opportunity to work at the heart of a forward-thinking organisation, where data plays a critical role in supporting key business decisions.

The Role

As a Data Analyst, you’ll be instrumental in the design, development, and optimisation of our data assets. Your focus will be on building and evolving data marts, semantic models, and dashboards using Power BI and the Microsoft Azure data stack.

Working closely with analysts, developers, and business stakeholders, you’ll ensure that data is structured, reliable, and ready to support self-service reporting and advanced analytics across departments.

What You’ll Be Doing

• Design and maintain scalable data warehouses, data marts, and semantic models
• Develop and enhance Power BI datasets, dashboards, and paginated reports
• Use SQL and Power Query (M) to prepare and transform data
• Implement best practices in data modelling using DAX and Tabular Editor
• Monitor model performance and proactively manage data reliability and integrity
• Collaborate with business teams to understand data needs and translate them into sustainable data models
• Test, validate, and troubleshoot issues across data pipelines and reporting layers
• Contribute to the ongoing improvement of our Azure data platform including Azure SQL, Data Factory, and Synapse Analytics

Tech You’ll Work With

• Power BI (Desktop, Service, Premium, Paginated Reports)
• DAX, M / Power Query, Tabular Editor, ALM Toolkit
• SQL Server, SSMS, T-SQL
• Azure Data Factory, Azure SQL Database, Synapse Analytics, Data Lake
• CI/CD pipelines, Git, DevOps for BI
• Power BI REST APIs, Row-Level Security (RLS)

What We’re Looking For

• Strong experience in Power BI development and data modelling
• Hands-on expertise in SQL and Microsoft’s Azure data services
• A strong understanding of data warehousing, ETL processes, and semantic modelling
• Demonstrated experience working with internal teams to define data needs and build appropriate models
• Excellent communication skills and the ability to simplify technical information for a non-technical audience

Nice to Have

• Microsoft certifications such as:
• PL-300 (Power BI Data Analyst Associate)
• DP-203 (Data Engineering on Microsoft Azure)
• DP-500 (Azure Enterprise Data Analyst Associate)
• Degree in a relevant subject area or equivalent professional experience
• Background in working within medium to large organisations

Why Apply?

• Be part of a growing and ambitious team that values innovation
• Work with modern tools and technology in a cloud-first environment
• Hybrid working with a strong base in Hertfordshire
• Support for certifications, learning, and career progression

Ready to take your Power BI and data modelling skills to the next level?

Apply now and help shape the future of data in a forward-thinking, tech-driven organisation.