Data & Analytics Consultant

Position Overview

The Data & Analytics Consultant is responsible for designing and implementing scalable, secure, and efficient data solutions using Microsoft technologies. This role involves working closely with stakeholders to understand business needs, translating them into technical solutions, and leading the delivery of data platforms and analytics systems. The individual should also be adept at converting pre‑sales opportunities into development work, performing estimates and responding to bids.

The budgeted salary for this role is between £50,000 and £60,000
, depending on experience. for the list of benefits.

Each team within our organisation can decide how to implement this policy. If you have any questions after applying, please reach out to our recruitment team.

• Strong communication skills to effectively engage with customers and convert opportunities into development work.
• Commitment to continuous learning and staying at the forefront of data analytics.
• Agile approach to balancing a time between development and pre‑sales activities, adaptable based on the sales pipeline.
• Define and drive data strategy aligned with business goals.
• Mentor junior staff and foster a culture of continuous improvement.
• Represent the data architecture function in executive and strategic planning meetings.

• Expertise in Microsoft Fabric.
• Strong skills in SQL, Spark, Python (DAX optional).
• Strong data‑modelling background across medallion architecture, Kimball, Star, and Snowflake schema.
• Ability to design and denormalize data models for self‑service analytics.
• Experience with Azure Data Stack (Azure Data Factory, Azure Functions, ADLS Gen2, etc.).
• Knowledge of Databricks.
• Experience with Power BI.
• Familiar with Dev Ops and CI/CD for data solutions.
• Degree in Computer Science or related field (preferred).

• DP-600:
  Microsoft Certified:
  Fabric Analytics Engineer Associate
• DP-700:
  Microsoft Certified:
  Fabric Data Engineer Associate

Please note you need to be eligible to obtain Security Clearance (SC) for this role. This typically requires British nationality and 5 years residency in the UK.

We are the tech company with people  Advania, we believe in empowering people to create sustainable value through the clever use of technology. As one of Microsoft's leading partners in the UK, specialising in Azure, Security, Dynamics 365, and Microsoft 365, we have a proven track record of success in delivering transformational IT services.

We are committed to ensuring an equitable experience for all candidates, regardless of race, religion or belief, ethnic or national origin, disability, age, citizenship, marital, domestic or civil partnership status, sexual orientation, gender identity, or any other basis as protected by applicable law. Please let us know if you’ll need any reasonable adjustments as part of the selection process by highlighting these on your application form.

As part of our commitment to our clients we will need to carry out background checks, including a criminal record check, for all offers of employment. If you have any unspent criminal convictions or questions about the screening process, please notify your recruiter once the application has been submitted.