Fabric / Power BI Analytics Consultant

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

Who You'll Be Working WithYou 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 purposeBuild 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 RoleThis 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 appsMicrosoft Fabric lakehouses, warehouses, data pipelines and dataflowsDAX, Power Query and dimensional data modellingData quality, security, governance and deployment controlsRequirements discovery, prototyping, testing and user adoptionMonitoring, support, troubleshooting and continuous improvementKey responsibilitiesWork 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 BringYou 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 experienceHands-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 experienceExperience 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 progressionThis Grade B role is expected to deliver defined work packages with appropriate guidance, progressively taking greater ownership as experience grows. You will have access to learning, certification and coaching, with opportunities to develop towards senior consultant, analytics lead or solution architecture pathways.Additional InfoHybrid working:Your working location will vary according to the role, client needs and business requirements, with a blend of Capgemini offices, client sites and home working. The role is not expected to be home-based 100% of the time.Pre-employment checks: Checks may include identity, nationality or immigration status, three years of employment history and an unspent criminal record check through the Disclosure and Barring Service.What we'll offer youYou will be supported to maintain a positive work-life balance and to build your career through Capgemini's learning-for-life culture. This includes practical delivery experience, coaching, professional communities, internal learning and access to external certification pathways.Why we're differentAt Capgemini, we help organisations become more agile, competitive and successful through tailored technology and data solutions. Our work combines technical quality with collaboration, inclusion and a close understanding of client goals. We value diversity of thought and the different experiences people bring to our teams.