Senior Data Analytics Consultant

Reporting to a Practice Lead, you will work across the full delivery lifecycle - from data ingestion and modelling through to semantic layers and Power BI reporting. You will design and develop Azure-based data pipelines, build scalable datasets, and deliver high quality reporting experiences that drive real business value. You will work closely with customers to understand their challenges and help shape the solutions that support their data and analytics strategy. You are an experienced data and analytics professional who enjoys working across data engineering, semantic modelling, and BI/reporting. You understand how to design scalable data solutions, build robust models, and create reporting experiences that support real business outcomes. You are curious, collaborative, and comfortable working directly with customers in a consulting environment.

Key Responsibilities: :
• Shape end-to-end analytics architectures spanning ingestion, transformation, semantic modelling, and reporting.
• Design and build high-performance Fabric data pipelines, lake houses/warehouses, and Power BI datasets, reports, and dashboards following best practice standards.
• Apply data governance, security, lineage, and quality practices across Azure/Fabric and Power BI ecosystems, including workspace administration and controls within Power BI.
• Partner with customers to understand requirements and translate them into clear technical designs.
• Support testing, validation, and deployment of data and analytics solutions.
• Contribute to internal frameworks, accelerators, and delivery standards as part of a growing practice.
• Collaborate closely with peers, share knowledge, and continuously evolve your technical capability.
• Contribute to DevOps practices such as CI/CD for Fabric pipelines, semantic models, and Power BI assets.

Required Skills & Qualifications:
• Strong hands-on experience with Azure data engineering tools such as Data Factory, Synapse, Data Lake, or Fabric.
• Strong Power BI capability including DAX, Power Query, data modelling, and design principles.
• Confidence working with SQL and modern data platform concepts.
• Experience translating business requirements into effective data and reporting solutions.
• Strong understanding of how data engineering, semantic modelling, and BI/reporting fit together in modern analytics architectures.
• Experience designing solutions that balance performance, governance, usability, and maintainability.
• Familiarity with data governance concepts such as workspace design, security models, access patterns, and content certification.
• Ability to advise customers on best practices across modelling, data architecture, and visualisation.
• A balanced skillset across data engineering, semantic modelling, and business intelligence, with the ability to work confidently across the full data and analytics lifecycle.
• Clear communication skills and the ability to engage with technical and non-technical stakeholders.
• A focus on quality, consistency, and continuous improvement.
• An interest in Microsoft Fabric and modern analytics approaches.
• Experience with Python or Power Platform is beneficial but not essential.