Senior Data & Analytics Consultant

We are seeking a Senior Data & Analytics Consultant to join our growing team and play a key role in helping our customers turn data into meaningful insight and measurable impact. In this role, you will design and deliver robust data and analytics solutions that strengthen data foundations, enable AI-driven initiatives, and support better operational and strategic decision-making.

About the Role

The Senior Data & Analytics Consultant designs and delivers data and analytics solutions that help customers improve operational performance and decision-making. Working closely with the AI Practice Lead, Business Consultants, Functional Consultants and delivery teams, this role ensures strong foundations in data management, governance, analytics, and integration, enabling both AI-driven initiatives and standalone data solutions. The role combines hands on expertise, solution leadership, and customer engagement to ensure our customers can effectively leverage their data to improve decision-making, operational performance, and service delivery.

Main Duties and Responsibilities

Data Strategy & Advisory

• Contribute to the development of customer data strategies aligned to business objectives
• Ensure data foundations are structured, governed, and scalable so they can support analytics, reporting, and AI-driven initiatives
• Provide expert guidance on modern data platforms, governance, and architecture

Data Governance & Quality

• Define and implement data governance practices to ensure accuracy, integrity, security, and compliance
• Support customers in establishing policies, standards, and data management frameworks

Data Analytics & Insights

• Analyse complex datasets and translate findings into clear operational and strategic insights for customers
• Translate data into actionable insights that support operational improvement and decision-making

Data Management & Warehousing

• Design and implement scalable data platforms including data warehouses, lakes, and relational databases
• Ensure efficient data storage, accessibility, and performance

ETL & Data Integration

• Design and oversee ETL pipelines integrating data from multiple business systems and external sources
• Ensure reliable and scalable data ingestion across cloud and on premise environments

Data Architecture & Engineering

• Collaborate with project teams to design secure, scalable, and high performance data solutions
• Support implementation of modern cloud data architectures

Automation & Workflow Optimisation

• Leverage Microsoft Power Platform and related tools to streamline data processes and improve efficiency

Advanced Data Solutions

• Design and deliver data solutions within the Microsoft ecosystem, including Azure Data Services, Microsoft Dataverse, Power BI, and Dynamics 365 integrations
• Enable predictive analytics and advanced modelling where appropriate
• Support AI initiatives by ensuring high quality, well structured data foundations
• Deliver data solutions that provide value independent of AI use cases
• Develop dashboards and reporting solutions using Power BI and other analytics platforms
• Provide real time visibility into key performance indicators and operational metrics

Stakeholder Collaboration

• Work closely with customers to ensure solutions align with operational needs
• Communicate complex technical concepts in a clear, business focused manner

Delivery Leadership & Capability Development

• Support pre sales engagements including discovery workshops, solution design, and proposal input
• Contribute to shaping commercially viable data solutions aligned to customer outcomes
• Mentor consultants and analysts to build organisational data capability
• Promote a data driven culture within projects and the wider business

Knowledge and Experience

• 5+ years' strong experience in data analytics, engineering, or business intelligence within a consultancy or technology services environment
• Proven expertise in data modelling, warehousing, and relational database design
• Experience designing and delivering cloud based data solutions, particularly within Microsoft Azure
• Knowledge of ETL processes and data integration across multiple systems
• Experience integrating Microsoft technologies (e.g., Dynamics 365, Azure Data Services, Power BI) with third party platforms
• Understanding of data governance, security, and compliance principles
• Hands on experience with SQL and one or more data programming languages
• Strong understanding of Microsoft Dataverse data structures and integration patterns
• Experience delivering complex data projects in customer environments
• Experience working with and understanding public sector data, security and governance

Personal Characteristics

• Pragmatic problem solver with a strong data driven mindset
• Collaborative and customer focused
• Innovative, with interest in emerging data and AI technologies
• Strong communicator able to bridge technical and business perspectives
• Adaptable in a fast moving consultancy environment

Personal Abilities

• Ability to translate business requirements into practical data solutions
• Strong stakeholder engagement skills across technical and non technical audiences
• Ability to manage multiple priorities across concurrent projects
• Commercial awareness and focus on delivering measurable value

Technical Abilities

• Proficiency in Microsoft Power BI, SQL, and Azure Data Services
• Experience with data integration tools, APIs, and middleware
• Knowledge of ETL tools such as Azure Data Factory, SSIS, or similar
• Experience with data warehouses, data lakes, and modern data platforms
• Familiarity with advanced analytics or machine learning concepts
• Experience with Microsoft Power Platform for process automation
• Understanding of statistical analysis, reporting, and visualisation techniques

What We Offer

• Industry aligned competitive salary
• 33 days annual leave, including bank holidays
• Access to learning resources to support study to achieve Microsoft certifications
• Bonus paid on passing agreed exams to gain specific Microsoft certifications
• Auto enrolment pension scheme with options to increase your contributions
• Employee wellbeing strategy
• Free flu jabs
• Company events
• Free on site parking.

About Us

We believe in our culture, values and staff successes. We invest in developing our staff and we support our employees with their professional development goals. We strive to offer an environment that provides our staff with the right work/life balance. We offer genuine career prospects: you will have a clear career progression path with the opportunity to become stakeholders within the business as it transitions to an employee owned company.

This role is UK based but we particularly welcome applications from candidates within commuting distance of our Northampton HQ, as on site collaboration and client engagement form part of the role. Candidates must have full entitlement to work and reside in the UK.

Strictly Personal Applicants Only. Please apply below to upload your CV and cover letter, describing why you feel you are right for this position, together with details of your current and minimum salary expectations, current benefits and notice period. Applications will be reviewed on a rolling basis; we encourage you to apply as soon as possible.

Please note we cannot sponsor applicants for a visa. Please only apply if you have the right to work in the UK and are resident in the UK. Ashton Court is committed to supporting individuals with the desire and capacity for long term career growth and development to achieve their full potential. Because the limitations of a time bound visa do not align with our long term career development plans, we regret we cannot accept applications from candidates whose right to work in the UK relies on a temporary, time limited or dependency visa.

Interview Process

Ashton Court Group is an equal opportunities employer. Interviews are conducted in a two stage process. Successful applicants will be invited to an initial 30 minute Teams meeting with a senior member of staff in the same discipline as the role for which you have applied. If successful, we will be inviting candidates to a second interview of up to one hour, including an assessment of your skills and experience and may include a technical test. Final interview and offer of employment is held in person at our offices. Full details will be provided at a later date for those who are selected.

Recruitment Agencies

Strictly no agency contact in response to this vacancy. We have a strict company policy to recruit directly. We therefore do not accept speculative CVs and/or cold calls to our Recruitment Team or Hiring Manager.

Apply Now To Work With Us

Apply here.