Fabric & Power BI Analytics Specialist

Capgemini; Birmingham; Hybrid; GBP 55,000 - 90,000; Full time

Job summary

Capgemini’s AI and Analytics team seeks a hands-on analytics consultant to deliver high-quality Power BI solutions. You will translate client requirements into trusted data models, reports and insights, working with data engineers, scientists and architects to solve complex problems.

You’ll contribute across Power BI reports, dashboards, semantic models and KPI scorecards, applying governance, security and deployment best practices while learning Fabric lakehouses and data pipelines.

Qualifications

• Hands-on experience building Power BI reports and dashboards for business users.
• Working knowledge of DAX, Power Query and data modelling, including facts, dimensions and relationships.
• Experience connecting to, preparing and validating data from common sources such as SQL databases, files, APIs or cloud platforms.
• Understanding of Power BI Service concepts, including workspaces, apps, refresh, gateways, permissions and deployment.

Responsibilities

• Build and enhance Power BI reports, dashboards, semantic models and KPI scorecards using appropriate visualisation and accessibility practices.
• Develop data preparation and transformation logic using Power Query, Dataflows Gen2, SQL and, where appropriate, Fabric pipelines or notebooks.
• Create clear, maintainable DAX measures and dimensional models that support accurate and performant analysis.
• Contribute to the configuration and use of Fabric workspaces, deployment pipelines, source control and release processes.

Skills

Power BI

DAX

Data modelling

SQL

Tools

Power Query

Fabric Gen2

Azure

Git

Job description

Capgemini’s AI and Analytics team seeks a hands-on analytics consultant to deliver high-quality Power BI solutions. You will translate client requirements into trusted data models, reports and insights, working with data engineers, scientists and architects to solve complex problems.

You’ll contribute across Power BI reports, dashboards, semantic models and KPI scorecards, applying governance, security and deployment best practices while learning Fabric lakehouses and data pipelines.