Senior Analytics Engineer

About the role

<p>&nbsp;</p> <p><span style="font-size: 12pt;"><strong>The Role..</strong></span></p> <p><span style="font-size: 12pt;">We are looking for an experienced Analytics Engineer to join our data team to enhance our data-platform. This role will develop advanced analytics features into our transformations layer, optimise performance, and work with data engineers to ensure scalability and robustness.</span></p> <p><span style="font-size: 12pt;">Candidates for the role will have proven expertise in developing complex and performant SQL data models, with a deep understanding of dbt Core or dbt Cloud and Snowflake. The ideal candidate will have experience managing semantic layer based BI tools, such as Omni or Looker.</span></p> <p><span style="font-size: 12pt;"><strong>Key Responsibilities..</strong></span></p> <ul> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Develop advanced and performant SQL transformations in dbt to support complex analytics and reporting needs, ensuring optimised performance in handling large-scale data.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Optimise sql codebase for Snowflake credit spend and dbt build times, tune materialisations and incremental models, and report against build KPIs.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Set up and manage dbt projects to ensure that the codebase is stable, scalable, and maintainable, adhering to best practices for long-term success.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Administer and manage dbt Cloud (Fusion), including scheduling and job monitoring.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Collaborate with data engineering teams to ensure our transformation layer integrates seamlessly with our ingestion layer, enabling end-to-end analytics pipelines.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Implement and manage data observability processes and tools to monitor and ensure data quality, accuracy, and reliability.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Administer our semantic layer in Omni (Omni.co) to ensure transformed business data and governed metrics are available for end-users.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Manage our GitHub repository, ensuring version control best practices, implementation of automated testing workflows, and seamless collaboration between teams.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Contribute to the development of master data management documentation and coding standards.</span></li> </ul> <p><span style="font-size: 12pt;"><strong>Required Skills and Experience..</strong></span></p> <ul> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Expertise in advanced SQL and data modelling techniques utilising dbt, with a strong emphasis on performant and optimised transformations for complex analytics and reporting.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Hands-on experience with Snowflake, including familiarity with its SQL dialect, performance tuning features and AI functions.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Experience administering dbt Cloud, setting up scalable and maintainable projects, and scheduling workflows.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Experience working with semantic layers for BI tooling, including defining metrics and relationships, ensuring data availability, user access and performance. Omni or Looker strongly preferred.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Knowledge of data observability tools and processes to monitor data quality and identify anomalies.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Experience managing GitHub repositories, including version control, automated tes

Skills