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
Reporting & Visualisation
- 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
- Provide technical leadership across data engagements
- 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
- Continuous professional development
- 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
- Eyecare vouchers
- 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.
