<p><span>Wood Mackenzie is the global data and analytics business for the renewables, energy, and natural resources industries. Enhanced by technology. Enriched by human intelligence. In an ever-changing world, companies and governments need reliable and actionable insight to lead the transition to a sustainable future. That’s why we cover the entire supply chain with unparalleled breadth and depth, backed by over 50 years’ experience. Our team of over 2,400 experts, operating across 30 global locations, are enabling customers’ decisions through real-time analytics, consultancy, events and thought leadership. Together, we deliver the insight they need to separate risk from opportunity and make confident decisions when it matters most.</span></p><p></p><p></p><p><b><a href="https://www.woodmac.com/">WoodMac.com</a></b></p><p></p><p><a href="https://www.youtube.com/watch?v=Y4AVwhQJj_w&amp;t=10s"><b>Wood Mackenzie Brand Video</b></a></p><p style="text-align:inherit;"></p><p style="text-align:left;"><b>Wood Mackenzie Values</b></p><ul><li>Inclusive – we succeed together</li><li>Trusting – we choose to trust each other</li><li>Customer committed – we put customers at the heart of our decisions</li><li>Future Focused – we accelerate change</li><li>Curious – we turn knowledge into action</li></ul><p style="text-align:inherit;"></p><div><div><p><b><span>Role Purpose</span></b><span> </span></p></div><div><p><span><span>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 </span><span>dbt</span><span> (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.</span></span><span> </span></p></div><div><p><span><span>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.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><b><span>Key Responsibilities:</span></b><span> </span></p></div><div><p><span><span>The successful candidate will be responsible for:</span></span><span> </span></p></div><div><ul><li><p><span><span>Data Modelling and Transformation: Designing, developing, and maintaining scalable and efficient data models and transformation pipelines in Snowflake using </span><span>dbt</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Workflow Management: Building and managing data transformation workflows, ensuring data is timely, accurate, and ready for analysis.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>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.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>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.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>System Optimisation: Identifying opportunities to improve data processes, optimise performance, and ensure the scalability of the data platform.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Technical Expertise: Acting as a subject matter expert on </span><span>dbt</span><span> and Snowflake, providing guidance and best practices to the wider data team.</span></span><span> </span></p></li></ul></div><div><p><b><span>Candidate Profile:</span></b><span> </span></p></div><div><p><span><span>The ideal candidate will possess a strong technical background combined with excellent analytical and communication skills.</span></span><span> </span></p></div><div><p><span><span>Essential Experience and Qualifications:</span></span><span> </span></p></div><div><ul><li><p><span><span>A </span><span>Bachelor’s</span><span> degree in a quantitative field such as Data Science, Computer Science, or a related discipline.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>2-4 years of hands-on experience in a data-focused role, with proven experience in data </span><span>modeling</span><span> and transformation.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Advanced proficiency in SQL for complex querying and data manipulation.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Demonstrable experience with </span><span>dbt</span><span> and cloud data warehouses, particularly Snowflake.</span></span><span> </span></p></li></ul></div></div><div><div><p><span> </span></p></div><div><p><b><span>Desirable Skills:</span></b><span> </span></p></div><div><ul><li><p><span><span>Proficiency in Python for data handling and automation.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Experience with ETL processes and data integration via APIs.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Familiarity with data visualization tools such as Power BI or Tableau.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>A strong understanding of data governance frameworks and data security protocols.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Exceptional problem-solving skills and a high level of attention to detail.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>The ability to translate complex technical concepts for non-technical audiences.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>A collaborative spirit and a commitment to continuous professional development.</span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div><div><p><span><span>This new role is a fantastic opportunity for a data professional passionate about building modern data stacks and enabling organisations to leverage their data assets effectively.</span></span><span> </span></p></div></div><p style="text-align:inherit;"></p><p style="text-align:left;"><b>Equal Opportunities</b></p><p style="text-align:inherit;"></p><p style="text-align:left;"><span><span><span>We are an equal opportunities employer. This means we are committed to recruiting the best people regardless of their race, colour, religion, age, sex, national origin, disability or protected veteran status. You can find out more about your rights under the law at </span><a href="http://www.eeoc.gov/">www.eeoc.gov</a><span> </span></span></span></p><p style="text-align:inherit;"></p><p style="text-align:left;"><span><span><span>If you are applying for a role and have a physical or mental disability, we will support you with your application or through the hiring process.  </span></span></span></p><p style="text-align:inherit;"></p>

<p>In the middle of the energy transition, businesses and governments are faced with significant challenges. But the pace and scale of change mean every decision is made&nbsp;under mounting pressure.&nbsp; Now, more than ever, companies need reliable data, analytics and actionable insight. Wood Mackenzie is the&nbsp;leading global provider of data and analytics solutions&nbsp;for the renewables, energy and natural resources sectors . Wood Mackenzie&rsquo;s services&nbsp;include data, analytics, insight, events and consultancy.&nbsp; A trusted partner for over 50 years, Wood Mackenzie&rsquo;s team has over 2,300 experts across more than 30 global&nbsp;locations who cover the entire supply chain. Wood Mackenzie&rsquo;s data and analytics empowers energy producers, governments and financial institutions to be confident in&nbsp;their investment decisions in the face of rapidly evolving markets. Part of the Veritas group.</p>

Analytics Engineer

<p><span>Wood Mackenzie is the global data and analytics business for the renewables, energy, and natural resources industries. Enhanced by technology. Enriched by human intelligence. In an ever-changing world, companies and governments need reliable and actionable insight to lead the transition to a sustainable future. That’s why we cover the entire supply chain with unparalleled breadth and depth, backed by over 50 years’ experience. Our team of over 2,400 experts, operating across 30 global locations, are enabling customers’ decisions through real-time analytics, consultancy, events and thought leadership. Together, we deliver the insight they need to separate risk from opportunity and make confident decisions when it matters most.</span></p><p></p><p></p><p><b><a href="https://www.woodmac.com/">WoodMac.com</a></b></p><p></p><p><a href="https://www.youtube.com/watch?v=Y4AVwhQJj_w&amp;t=10s"><b>Wood Mackenzie Brand Video</b></a></p><p></p><p><b>Wood Mackenzie Values</b></p><ul><li>Inclusive – we succeed together</li><li>Trusting – we choose to trust each other</li><li>Customer committed – we put customers at the heart of our decisions</li><li>Future Focused – we accelerate change</li><li>Curious – we turn knowledge into action</li></ul><p></p><div><div><p><b><span>Role Purpose</span></b><span>&nbsp;</span></p></div><div><p><span><span>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 </span><span>dbt</span><span> (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.</span></span><span>&nbsp;</span></p></div><div><p><span><span>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.</span></span><span>&nbsp;</span></p></div><div><p><span>&nbsp;</span></p></div><div><p><b><span>Key Responsibilities:</span></b><span>&nbsp;</span></p></div><div><p><span><span>The successful candidate will be responsible for:</span></span><span>&nbsp;</span></p></div><div><ul><li><p><span><span>Data Modelling and Transformation: Designing, developing, and maintaining scalable and efficient data models and transformation pipelines in Snowflake using </span><span>dbt</span><span>.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>Workflow Management: Building and managing data transformation workflows, ensuring data is timely, accurate, and ready for analysis.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>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.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>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.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>System Optimisation: Identifying opportunities to improve data processes, optimise performance, and ensure the scalability of the data platform.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>Technical Expertise: Acting as a subject matter expert on </span><span>dbt</span><span> and Snowflake, providing guidance and best practices to the wider data team.</span></span><span>&nbsp;</span></p></li></ul></div><div><p><b><span>Candidate Profile:</span></b><span>&nbsp;</span></p></div><div><p><span><span>The ideal candidate will possess a strong technical background combined with excellent analytical and communication skills.</span></span><span>&nbsp;</span></p></div><div><p><span><span>Essential Experience and Qualifications:</span></span><span>&nbsp;</span></p></div><div><ul><li><p><span><span>A </span><span>Bachelor’s</span><span> degree in a quantitative field such as Data Science, Computer Science, or a related discipline.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>2-4 years of hands-on experience in a data-focused role, with proven experience in data </span><span>modeling</span><span> and transformation.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>Advanced proficiency in SQL for complex querying and data manipulation.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>Demonstrable experience with </span><span>dbt</span><span> and cloud data warehouses, particularly Snowflake.</span></span><span>&nbsp;</span></p></li></ul></div></div><div><div><p><span>&nbsp;</span></p></div><div><p><b><span>Desirable Skills:</span></b><span>&nbsp;</span></p></div><div><ul><li><p><span><span>Proficiency in Python for data handling and automation.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>Experience with ETL processes and data integration via APIs.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>Familiarity with data visualization tools such as Power BI or Tableau.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>A strong understanding of data governance frameworks and data security protocols.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>Exceptional problem-solving skills and a high level of attention to detail.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>The ability to translate complex technical concepts for non-technical audiences.</span></span><span>&nbsp;</span></p></li></ul></div><div><ul><li><p><span><span>A collaborative spirit and a commitment to continuous professional development.</span></span><span>&nbsp;</span></p></li></ul></div><div><p><span>&nbsp;</span></p></div><div><p><span><span>This new role is a fantastic opportunity for a data professional passionate about building modern data stacks and enabling organisations to leverage their data assets effectively.</span></span><span>&nbsp;</span></p></div></div><p></p><p><b>Equal Opportunities</b></p><p></p><p><span><span><span>We are an equal opportunities employer. This means we are committed to recruiting the best people regardless of their race, colour, religion, age, sex, national origin, disability or protected veteran status. You can find out more about your rights under the law at </span><a href="http://www.eeoc.gov/">www.eeoc.gov</a><span>&nbsp;</span></span></span></p><p></p><p><span><span><span>If you are applying for a role and have a physical or mental disability, we will support you with your application or through the hiring process.&nbsp;&nbsp;</span></span></span></p><p></p>

Analytics Engineer

About the Job

About the Company

Wood Mackenzie

Similar Jobs

Data Engineer

Data Engineer

Data Scientist | Customer Insight & Analytics

Data Scientist | Customer Insight & Analytics

Data Analyst

Data Analyst

Data and Analytics Director

Data and Analytics Director

Senior Data Engineer

Senior Data Engineer

SDE II - Analytics

SDE II - Analytics

Senior Data Scientist

Senior Data Scientist