Industry: Consultancy
Location: West Midlands (hybrid working available)
Salary: £45,000 per year
Overview
We are seeking an Analytics Engineer to design, build, and maintain trusted analytical datasets that enable clear, consistent reporting and insight for a range of clients. You will sit between data engineering and analytics, owning transformation logic, data modelling, and data quality so that stakeholders can self-serve confidently.
Key Responsibilities
* Develop and maintain scalable ELT/ETL pipelines, transforming raw data into curated analytical models.
* Build dimensional and/or wider analytical models (e.g., star schemas) to support BI and operational reporting.
* Implement robust testing, documentation, and version control for analytics code and datasets.
* Partner with consultants, analysts, and client stakeholders to translate requirements into well-defined metrics and data products.
* Ensure data quality through monitoring, anomaly detection, and root-cause investigation.
* Optimise performance and cost across warehouses and transformation workloads.
* Support dashboarding and semantic layers where required, ensuring consistent definitions and governance.
* Contribute to best practice, reusable patterns, and internal accelerators across multiple client engagements.
Essential Requirements
* Commercial experience in analytics engineering, data engineering, or BI engineering.
* Strong SQL skills and experience with data modelling for analytics.
* Hands-on experience with a modern cloud data warehouse (e.g., Snowflake, BigQuery, Redshift, or Azure Synapse).
* Experience with transformation tooling (e.g., dbt or equivalent) and orchestration (e.g., Airflow, Azure Data Factory, or similar).
* Proficiency with Git-based version control and CI/CD principles.
* Understanding of data governance, lineage, and metric definitions.
* Ability to communicate clearly with both technical and non-technical stakeholders in a consultancy environment.
Desirable
* Experience with BI tools (e.g., Power BI, Tableau, Looker) and semantic modelling.
* Python for data manipulation and automation.
* Familiarity with privacy, security, and compliance considerations.
* Consulting experience delivering to multiple clients and industries.
What You’ll Need
* Strong problem-solving skills, attention to detail, and a quality-first mindset.
* Ability to manage priorities across concurrent workstreams.
* Eligibility to work in the UK