Fabric / Power BI Analytics Consultant

Capgemini

Saltley

On-site

GBP 55,000 - 85,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Capgemini is seeking a Fabric / Power BI Analytics Consultant to join its AI & Analytics team in the Insights and Data unit. You will translate business needs into trusted data models, reports and insights using Fabric and Power BI, collaborating with data engineers, scientists and solution architects.

You will contribute to design, build, test and deployment of analytics solutions while adhering to governance, security and delivery practices across engagements.

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.
  • Awareness and experience of Microsoft Fabric capabilities such as OneLake, Lakehouse, Warehouse, Data Factory and semantic models, with practical exposure to at least one area.
  • Ability to translate requirements into user stories, prototypes or working analytics outputs.
  • Good analytical, written and verbal communication skills, with the confidence to work collaboratively in a client‑facing team.
  • Commitment to inclusive design, accessibility, data quality and secure handling of client information.

Responsibilities

  • Work with client stakeholders and delivery colleagues to understand business questions, user needs, data sources and acceptance criteria.
  • 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.
  • Apply agreed security controls, including workspace and app access, row-level security and sensitivity or endorsement settings.
  • Test solutions, investigate defects and performance issues, and produce concise technical and user documentation.
  • Participate in agile ceremonies, estimation, peer reviews, demonstrations and knowledge sharing.
  • Support proposals, demonstrations, accelerators and reusable assets for the wider AI & Analytics practice.
  • Develop your consulting capability by communicating clearly, managing commitments and seeking feedback from clients and colleagues.

Skills

Power BI
DAX
Power Query
Data modelling
SQL databases
Data preparation
Fabric
Communication skills

Tools

Fabric
Git
Azure DevOps

Job description

Fabric / Power BI Analytics Consultant

You will join Capgemini's AI and Analytics team within the Insights and Data Global Business Unit. You will work with visualisation specialists, data engineers, data scientists, business analysts and solution architects to solve client problems using modern data and analytics services.

Role purpose

Build high-quality analytics solutions using Microsoft Fabric and Power BI, translating business needs into trusted data models, reports and insights. Work as part of a client delivery team, with support from senior consultants and architects.

PLEASE NOTE: Security clearance

To be successfully appointed, you must be eligible to obtain Security Check (SC) clearance. This normally requires continuous UK residency for the previous five years, alongside other criteria. Some assignments may be restricted to sole UK nationals for security reasons.

The Focus Of Your Role

This is a hands‑on consulting role for someone developing their career across Microsoft Fabric and Power BI. You will help clients turn data into clear, accessible and actionable insight. You will contribute to the design, build, test and deployment of analytics solutions, while learning how enterprise security, governance and delivery standards are applied in practice. The role is broader than report development alone.

Depending on the engagement, you may work across:

  • Microsoft Power BI reports, dashboards, semantic models and apps
  • Microsoft Fabric lakehouses, warehouses, data pipelines and dataflows
  • DAX, Power Query and dimensional data modelling
  • Data quality, security, governance and deployment controls
  • Requirements discovery, prototyping, testing and user adoption
  • Monitoring, support, troubleshooting and continuous improvement
Key responsibilities
  • Work with client stakeholders and delivery colleagues to understand business questions, user needs, data sources and acceptance criteria.
  • 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.
  • Apply agreed security controls, including workspace and app access, row-level security and sensitivity or endorsement settings.
  • Test solutions, investigate defects and performance issues, and produce concise technical and user documentation.
  • Participate in agile ceremonies, estimation, peer reviews, demonstrations and knowledge sharing.
  • Support proposals, demonstrations, accelerators and reusable assets for the wider AI & Analytics practice.
  • Develop your consulting capability by communicating clearly, managing commitments and seeking feedback from clients and colleagues.
What You'll Bring

You will combine practical analytics skills with curiosity, structured problem‑solving and an interest in helping clients make better decisions. You do not need to be an solutions architect, but you should understand how your work fits within a governed data and analytics solution.

Essential skills and experience
  • 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.
  • Awareness and experience of Microsoft Fabric capabilities such as OneLake, Lakehouse, Warehouse, Data Factory and semantic models, with practical exposure to at least one area.
  • Ability to translate requirements into user stories, prototypes or working analytics outputs.
  • Good analytical, written and verbal communication skills, with the confidence to work collaboratively in a client‑facing team.
  • Commitment to inclusive design, accessibility, data quality and secure handling of client information.
Desirable skills and experience
  • Experience with SQL, Azure data services, Databricks, Microsoft Purview, Power Platform or other cloud data platforms.
  • Exposure to version control and CI/CD using Git, Azure DevOps or Fabric deployment pipelines.
  • Awareness of capacity, licensing, performance optimisation and governance considerations in Power BI or Fabric.
  • Experience working in agile delivery and producing documentation, test evidence or training materials.
  • A relevant Microsoft certification, or willingness to work towards one, such as PL-300 or DP-600.
Development and progression

This Grade B role is expected to deliver defined work packages with appropriate guidance, progressively taking greater ownership as e

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Fabric / Power BI Analytics Consultant
Fabric / Power BI Analytics Consultant

Capgemini • Greater London

Hybrid
GBP 60,000 - 90,000
Hybrid working
Fabric / Power BI Analytics Consultant
Fabric / Power BI Analytics Consultant

Capgemini • Birmingham

Hybrid
GBP 55,000 - 90,000
Senior Fabric Architect
Senior Fabric Architect

Cognizant • Greater London

Hybrid
GBP 110,000 - 150,000
Microsoft Fabric Architect
Microsoft Fabric Architect

Salt • Greater London

Hybrid
GBP 104,000 - 136,000
Fabric & Power BI Analytics Specialist
Fabric & Power BI Analytics Specialist

Capgemini • Greater London

Hybrid
GBP 60,000 - 90,000
Hybrid working
Microsoft Fabric and Power BI Analyst
Microsoft Fabric and Power BI Analyst

Essential Employment • England

On-site
GBP 72,000 - 94,000
Senior Fabric Engineer
Senior Fabric Engineer

Cognizant Technology Solutions Corporation • Greater London

Hybrid
GBP 85,000 - 110,000
Fabric & Power BI Analytics Specialist
Fabric & Power BI Analytics Specialist

Capgemini • Birmingham

Hybrid
GBP 55,000 - 90,000
Fabric & Power BI Analytics Specialist
Fabric & Power BI Analytics Specialist

Capgemini • Saltley

On-site
GBP 55,000 - 85,000
Fabric & Power BI Analyst – Data Viz & Governance
Fabric & Power BI Analyst – Data Viz & Governance

ESSENTIAL EMPLOYMENT LTD • England

On-site
GBP 72,000 - 94,000