Copilot Consultant

At KPMG Microsoft Business Solution we implement best in class solutions across the Microsoft technology stack. We have extensive knowledge and expertise in all areas, enabling us to provide our clients with an integrated end-to-end solution. Our solutions are based on the Dynamics 365, Microsoft 365 and Azure range of products which enables us to deliver, powerful, connected business solutions that drive significant client value.

The Role:

We are looking for a client-facing Data Consultant who can design, build, and optimise modern data platforms and analytics solutions using the Microsoft data stack, with a strong emphasis on Microsoft Fabric. You’ll work across data ingestion, transformation, modelling, governance, and visualisation—translating business needs into robust, secure, scalable solutions that deliver measurable outcomes.  This person must be comfortable speaking to client and internal teams on technical matters.

The Data Consultant will be responsible for:

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.

Analytics & Semantic Modelling

• 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.

Architecture, Governance & Standards

• 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.

Consulting, Stakeholders & Pre-sales

• 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.
• Stay current with Fabric capabilities and the evolving Microsoft data ecosystem, bringing innovation into client solutions.

Required Skills & Experience

Microsoft Data Stack

• 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.

Consulting & Communication

• Strong written and verbal communication, able to present technical concepts clearly to mixed audiences.
• Strong relationship-building and stakeholder management in complex client environments.

Code Management

• CI/CD for Fabric items.
• Git-based workflow.
• Testing frameworks.
• Performance tuning patterns.
• Cost/capacity optimisation.

Desirable Skills & Experience

• Experience across adjacent Microsoft services often paired with Fabric (e.g., Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Azure Data Lake).
• Familiarity with Microsoft Purview and broader governance practices.
• Dynamics 365 CE and FO integration and analytics.
• Exposure to AI/ML enablement in Microsoft ecosystem (e.g., Azure ML / AI Foundry / Azure OpenAI), particularly where analytics feeds AI-powered apps.
• Experience designing BI / data analytics solutions and enforcing architecture/documentation standards.

The Person:

• Strong technical skills.
• Experience of delivering client engagements.
• Experience in a consultancy or customer facing role.
• An intelligent, analytical and pragmatic approach to problem solving.
• Excellent relationship building skills with clients and colleagues.
• Excellent interpersonal skills and the ability to influence and manage a range of relationships in a complex environment.
• Strong communication skills (verbal, written and listening): an ability to present information concisely, to communicate in a manner applicable to all levels.
• Able to produce high quality and professional technical documentation.
• Excellent attention to detail and ability to ensure documents are consistent in language, terminology and style.
• Flexible approach to work with a focus on delivery to deadlines and high standards.
• Ability to handle highly confidential information with tact and discretion.
• Be able to achieve SC security clearance.