> Markdown version of [/jobs/ext/75560-analytics-engineer-ii](https://www.wearedevelopers.com/jobs/ext/75560-analytics-engineer-ii). 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). --- # Analytics Engineer II - **Company:** Wood Mackenzie Limited - **Location:** Edinburgh, UK - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Amazon Web Services, Amazon S3, Data Analysis, Cloud Database, Data Governance, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Visualization, Github, Python (Programming Language), Power BI, SQL Databases, Tableau (Software), Data Processing, Snowflake, Data Build Tool (dbt), Information Technology, Data Analytics - **Published:** May 17, 2026 - **Apply:** https://uk.indeed.com/viewjob?jk=dc26864f77c86306 ## About the Role Do you have experience in Tableau?, Do you have a Bachelor's degree?, The ideal candidate will possess a strong technical background combined with excellent analytical and communication skills., * A Bachelor's degree in a quantitative field such as Data Science, Computer Science, or a related discipline. * 2-4 years of hands-on experience in a data-focused role, with proven experience in data modeling and transformation. * Advanced proficiency in SQL for complex querying and data manipulation. * Demonstrable experience with dbt and cloud data warehouses, particularly Snowflake. * Proficiency with GitHub and AWS tools such as Step Functions, Athena, and S3, etc. * Strong discipline in attention to detail, data accuracy, and structured working practices. * Reliable execution and ownership of deliverables. * Proactive learner with genuine curiosity for emerging technologies and a commitment to continuous professional development. Desirable Skills: * Proficiency in Python for data handling and automation. * Experience with ETL processes and data integration via APIs. * Familiarity with data visualization tools such as Power BI or Tableau. * A strong understanding of data governance frameworks and data security protocols. * Exceptional problem-solving skills and a high level of attention to detail. * The ability to translate complex technical concepts for non-technical audiences. * A collaborative spirit and a commitment to continuous professional development. ## Description A new Analytics Engineer position is being created to enhance the data team's capabilities in managing and transforming data within the Snowflake data platform using dbt (data build tool). This role will be pivotal in building a scalable and reliable data infrastructure to support analytics and data-driven decision-making across the business. The Analytics Engineer will act as a bridge between data engineers and data analysts, applying software engineering best practices to the analytics workflow. This includes developing, testing, and deploying data models, as well as ensuring data quality and creating robust documentation., The successful candidate will be responsible for: * Data Modelling and Transformation: Designing, developing, and maintaining scalable and efficient data models and transformation pipelines in Snowflake using dbt. * Workflow Management: Building and managing data transformation workflows, ensuring data is timely, accurate, and ready for analysis. * Data Quality and Governance: Implementing data quality tests and documentation to ensure the reliability and trustworthiness of the data. This includes supporting data governance and quality assurance activities. * Collaboration: Working closely with data analysts, data engineers, and business stakeholders to understand data requirements and deliver actionable insights. The role involves engaging directly with stakeholders and building their confidence in data-driven outcomes. * System Optimisation: Identifying opportunities to improve data processes, optimise performance, and ensure the scalability of the data platform. * Technical Expertise: Acting as a subject matter expert on dbt and Snowflake, providing guidance and best practices to the wider data team. ## 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) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [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) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [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) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Software Engineer Salary in The UK](https://www.wearedevelopers.com/magazine/231-software-engineer-salary-in-the-uk) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)