# Senior Analytics Engineer

**Company**: Soho House
**Location**: London, England
**Experience**: senior
**Job type**: full-time
**Category**: Engineering
**Industry**: Technology

**Apply**: https://job-boards.greenhouse.io/sohohouseco/jobs/5017400101?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_bafcda42-8f3

## Description

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.

Key Responsibilities:

- Develop advanced and performant SQL transformations in dbt to support complex analytics and reporting needs, ensuring optimised performance in handling large-scale data.

- Optimise sql codebase for Snowflake credit spend and dbt build times, tune materialisations and incremental models, and report against build KPIs.

- Set up and manage dbt projects to ensure that the codebase is stable, scalable, and maintainable, adhering to best practices for long-term success.

- Administer and manage dbt Cloud (Fusion), including scheduling and job monitoring.

- Collaborate with data engineering teams to ensure our transformation layer integrates seamlessly with our ingestion layer, enabling end-to-end analytics pipelines.

- Implement and manage data observability processes and tools to monitor and ensure data quality, accuracy, and reliability.

- Administer our semantic layer in Omni (Omni.co) to ensure transformed business data and governed metrics are available for end-users.

- Manage our GitHub repository, ensuring version control best practices, implementation of automated testing workflows, and seamless collaboration between teams.

- Contribute to the development of master data management documentation and coding standards.

Required Skills and Experience:

- Expertise in advanced SQL and data modelling techniques utilising dbt, with a strong emphasis on performant and optimised transformations for complex analytics and reporting.

- Hands-on experience with Snowflake, including familiarity with its SQL dialect, performance tuning features and AI functions.

- Experience administering dbt Cloud, setting up scalable and maintainable projects, and scheduling workflows.

- 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.

- Knowledge of data observability tools and processes to monitor data quality and identify anomalies.

- Experience managing GitHub repositories, including version control, automated testing workflows, and fostering team collaboration.

- Demonstrated ability to collaborate with data engineering teams to build new data pipelines and integrate transformation layers seamlessly with ingestion layers.

Benefits:

- Annual Every House Membership

- 50% off Food & Drink, 7 days a week

- Staff Room Rates

- Private Health and Dental Care

- Weekly Pay

- Life Assurance

- Up to 50% Staff Discount on Cowshed & Soho Home

- In Office Dog Policy on Fridays

- Season Ticket Loan

- Christmas Office Closure

- In conjunction with Soho Impact, take 2 days paid a year to support a charity of your choice.

- Free Counselling Sessions

- Cookhouse & House Tonic: Our Cookhouse & House Tonic programmes offer unique food and drink trainings, events and opportunities to inspire and educate.

- Continuous training to develop yourself personally and professionally

- Exclusive access to our benefits platform with hundreds of discounts on shopping, gym memberships, holidays, insurance and much more

- 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.

## Skills

### Required
- SQL
- dbt
- Snowflake
- data modelling
- data observability
- GitHub

### Nice to have
- AI
- Claude Code
- Omni
- Looker

---

Source: [Apply at job-boards.greenhouse.io](https://job-boards.greenhouse.io/sohohouseco/jobs/5017400101?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)