Senior Analytics Engineer

<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 testing workflows, and fostering team collaboration.</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Demonstrated ability to collaborate with data engineering teams to build new data pipelines and integrate transformation layers seamlessly with ingestion layers.</span></li>
</ul>
<p><span style="font-size: 12pt;"><strong>Preferred Experience..</strong></span></p>
<ul>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Use of AI for coding workflows. Claude Code preferred.</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">AI context for semantic layers, especially in Omni. Curate AI context, field descriptions and sample queries in the semantic layer so AI assistants answer questions accurately.</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Experience in the hospitality industry and familiarity with hospitality-specific data and KPIs.</span></li>
</ul>
<p>&nbsp;</p>
<p><span style="font-size: 12pt;"><strong>Benefits…</strong></span></p>
<p><span style="font-size: 12pt;">Soho House offers competitive compensation packages that feature global benefits and perks. Whether you’re seeking entry-level employment or a new opportunity to expand your profession, we offer training to develop the technical and managerial skills necessary to grow your career.</span></p>
<ul>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Annual Every House Membership</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">50% off Food &amp; Drink, 7 days a week</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Staff Room Rates</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Private Health and Dental Care</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Weekly Pay</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Life Assurance</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Up to 50% Staff Discount on Cowshed &amp; Soho Home</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">In Office Dog Policy on Fridays</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Season Ticket Loan</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Christmas Office Closure</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">In conjunction with Soho Impact, take 2 days paid a year to support a charity of your choice.</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Free Counselling Sessions</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Cookhouse &amp; House Tonic: Our Cookhouse &amp; House Tonic programmes offer unique food and drink trainings, events and opportunities to inspire and educate.</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Continuous training to develop yourself personally and professionally</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Exclusive access to our benefits platform with hundreds of discounts on shopping, gym memberships, holidays, insurance and much more</span></li>
<li style="font-size: 12pt;"><span style="font-size: 12pt;">Team Events: From fitness sessions to cinema screenings and art classes, each month we hold a series of fun events which you can sign up to.</span></li>
</ul>
<p>&nbsp;</p>
<p>&nbsp;</p>Find more English Speaking Jobs in United Kingdom on Arbeitnow