> Markdown version of [/jobs/ext/2490604-senior-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/2490604-senior-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Analytics Engineer - **Company:** Perk - **Location:** London, UK - **Experience:** Expert - **Salary:** £70,098.0 - **Contract:** Permanent contract - **Skills:** Airflow, Data Analysis, Cloud Database, Code Review, Continuous Integration, Information Engineering, Extract Transform Load (ETL), Data Transformation, Data Structures, Data Visualization, Data Warehousing, Python (Programming Language), Performance Tuning, Software Engineering, SQL Databases, Workflow Management Systems, Freeform SQL, Data Ingestion, Snowflake, Data Build Tool (dbt), Git, Data Layers, Data Analytics, Google Bigquery, Data Management, Looker Analytics, Software Version Control, Data Pipelines, Amazon Redshift - **Published:** August 24, 2026 - **Apply:** https://www.adzuna.co.uk/jobs/details/5856955316 ## About the Role * Experience: Multiple years of experience in a data-focused role (e.g., Analytics Engineer, Data Analyst, BI Developer). * SQL Mastery: Expert-level proficiency in writing and optimising complex SQL queries. * Data Transformation Tooling: Hands-on experience with dbt (Data Build Tool) or similar data transformation frameworks is essential. * Data Warehousing: Experience working with cloud-based data warehouses such as Snowflake, Google BigQuery, or Amazon Redshift. * Data modelling: Solid understanding of data warehousing concepts, ETL/ELT principles, and dimensional modelling techniques. * Version Control: Proficiency with Git for collaborative development and version control. * Familiarity with reporting/ BI tools like Looker. Preferred Qualifications * Python expertise for automation, integration, and orchestration * Experience with Semantic layers * Experience with orchestration tools like Airflow. * Knowledge of modern software engineering practices applied to data (e.g., modularity, code review, testing). ## Description This critical role sits at the intersection of Data Engineering and Data Analytics, focusing on transforming raw data into high-quality, trustworthy, and easily consumable datasets and visualisations for business users. The ideal candidate will possess a strong background in SQL, dbt, data modelling, ETL/ELT principles and experience with modern cloud data platforms. Core Responsibilities Develop and Maintain Transformation best practices in ELT Pipelines: Design, develop, and maintain efficient and scalable workflows using tools like dbt to transform raw data loaded into our data warehouse (Snowflake) into clean, ready-to-use data models. Data Modelling: Implement best-practice data modelling and software engineering techniques to ensure data structures are optimised for performance, accuracy, and ease of use in reporting and analytical applications (e.g. CI/CD, testing, lineage). Data Quality and Testing: Write comprehensive data quality checks, tests, and monitoring scripts to ensure the accuracy, completeness, and reliability of all transformed data assets. Establish and maintain documentation for all data transformations and models. Collaboration: Work closely with Data Analysts and business users to understand their reporting needs and optimise data models to support their analytical use cases. Collaborate with Data Engineers on data ingestion strategies and platform optimisation. Performance Optimisation: Tune and optimise SQL queries and data models to reduce latency and improve the performance of our data warehouse and downstream applications. Tool Adoption: Champion the adoption of modern data stack tools and practices (e.g. Git, CI/CD). ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)