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 objectivesEnsure data foundations are structured, governed, and scalable so they can support analytics, reporting, and AI-driven initiativesProvide expert guidance on modern data platforms, governance, and architecture Data Governance & Quality Define and implement data governance practices to ensure accuracy, integrity, security, and complianceSupport 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 customersTranslate 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 databasesEnsure efficient data storage, accessibility, and performance ETL & Data Integration Design and oversee ETL pipelines integrating data from multiple business systems and external sourcesEnsure 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 solutionsSupport 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 integrationsEnable predictive analytics and advanced modelling where appropriateSupport AI initiatives by ensuring high-quality, well-structured data foundationsDeliver data solutions that provide value independent of AI use casesDevelop dashboards and reporting solutions using Power BI and other analytics platformsProvide real-time visibility into key performance indicators and operational metrics Stakeholder Collaboration Work closely with customers to ensure solutions align with operational needsCommunicate complex technical concepts in a clear, business-focused manner Delivery Leadership & Capability Development Support pre-sales engagements including discovery workshops, solution design, and proposal inputContribute to shaping commercially viable data solutions aligned to customer outcomesMentor consultants and analysts to build organisational data capabilityPromote a data-driven culture within projects and the wider business

5+ years’ strong experience in data analytics, engineering, or business intelligence within a consultancy or technology services environmentProven expertise in data modelling, warehousing, and relational database designExperience designing and delivering cloud-based data solutions, particularly within Microsoft AzureKnowledge of ETL processes and data integration across multiple systemsExperience integrating Microsoft technologies (e.g., Dynamics 365, Azure Data Services, Power BI) with third-party platformsUnderstanding of data governance, security, and compliance principlesHands-on experience with SQL and one or more data programming languagesStrong understanding of Microsoft Dataverse data structures and integration patternsExperience delivering complex data projects in customer environmentsExperience working with and understanding public sector data, security and governance Personal Characteristics Pragmatic problem-solver with a strong data-driven mindsetCollaborative and customer-focusedInnovative, with interest in emerging data and AI technologiesStrong communicator able to bridge technical and business perspectivesAdaptable in a fast-moving consultancy environment Personal Abilities Ability to translate business requirements into practical data solutionsStrong stakeholder engagement skills across technical and non-technical audiencesAbility to manage multiple priorities across concurrent projectsCommercial awareness and focus on delivering measurable value Technical Abilities Proficiency in Microsoft Power BI, SQL, and Azure Data ServicesExperience with data integration tools, APIs, and middlewareKnowledge of ETL tools such as Azure Data Factory, SSIS, or similarExperience with data warehouses, data lakes, and modern data platformsFamiliarity with advanced analytics or machine learning conceptsExperience with Microsoft Power Platform for process automationUnderstanding of statistical analysis, reporting, and visualisation techniques What We Offer Industry aligned competitive salary33 days annual leave, including bank holidaysAccess to learning resources to support study to achieve Microsoft certificationsBonus paid on passing agreed exams to gain specific Microsoft certificationsAuto-enrolment pension scheme with options to increase your contributionsEmployee wellbeing strategyFree flu jabsCompany eventsFree on-site parking.

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.