KPMG UK

Copilot Consultant

KPMG UK

full-time

Posted on:

Location Type: Office

Location: London • United Kingdom

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AzureETLSpark

About the role

  • Delivery & Engineering Design, build, and optimise data pipelines and architectures using Microsoft Fabric and adjacent Azure data services.
  • Implement ingestion and transformation patterns in Fabric using Lakehouse, Pipelines, and Notebooks, ensuring data is accessible, well-organised, and high-quality.
  • Build and maintain scalable data processing systems that transform complex datasets into trusted, analytics-ready assets.
  • Establish practices for data quality measurement, monitoring, and feedback loops across ingestion/migration activities.
  • Create and enhance Power BI semantic models (relationships, measures, security rules).
  • Implement data-access controls for analytical consumption (e.g., row-level/object-level security patterns in semantic models).
  • Develop insightful reporting and analytics experiences in Power BI to augment client decision-making and operational outcomes.
  • Translate business requirements into end-to-end data architecture, balancing performance, cost, security, and maintainability.
  • Apply and advise on security patterns and contribute to governance-by-design.
  • Enforce technical documentation standards, architectural artefacts, and implementation patterns that improve repeatability and delivery quality.
  • Engage stakeholders to shape problem statements, clarify requirements, and define pragmatic delivery approaches.
  • Support scoping, estimation, and delivery planning; produce high-quality client-facing documentation and presentations.
  • Collaborate with adjacent teams (e.g., Dynamics/Power Platform/AI) to integrate analytics and data capabilities into broader solutions.

Requirements

  • Hands-on experience delivering data solutions with Microsoft Fabric, including Lakehouse, Pipelines, and Notebooks/Spark-based processing.
  • Strong capability in data pipeline and architecture design and optimisation across Microsoft tooling (Fabric and/or other Azure services).
  • Strong Power BI capability (reporting + modelling) and ability to connect engineering outputs to analytics consumption.
  • Understanding of Direct Lake semantic modelling design considerations (model creation, table choices, and enforcing access rules).
  • Proven experience with ingestion and transformation patterns (ETL/ELT concepts), data modelling, and delivering analytics-ready datasets.
  • Ability to implement approaches that improve delivery reliability: data quality checks, monitoring, and operational feedback mechanisms.
  • Strong written and verbal communication, able to present technical concepts clearly to mixed audiences.
  • Strong relationship-building and stakeholder management in complex client environments.
  • CI/CD for Fabric items.
  • Git-based workflow.
  • Testing frameworks.
  • Performance tuning patterns.
  • Cost/capacity optimisation.
Benefits
  • (No benefits explicitly stated in available content)
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data pipeline designdata architecture optimisationMicrosoft FabricLakehousePipelinesNotebooksPower BIETLELTdata modelling
Soft Skills
communicationrelationship-buildingstakeholder managementproblem-solvingdocumentationpresentation skillscollaborationdelivery planningclient-facing skillsfeedback mechanisms