Develop and optimize SQL transformations and dbt projects on Snowflake, administer dbt Cloud workflows, and maintain scalable analytics infrastructure. Manage semantic layers in Omni, data observability, GitHub workflows, automated testing, and data quality processes. Collaborate with data engineering teams to integrate ingestion and transformation layers, establish coding standards, and support governed metrics and AI-ready semantic context.
The Role..
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.
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.
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.
Preferred Experience..
- Use of AI for coding workflows. Claude Code preferred.
- 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.
- Experience in the hospitality industry and familiarity with hospitality-specific data and KPIs.
Benefits…
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.
- 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.
Soho House & Co London, England Office
London, United Kingdom
Similar Jobs
Enterprise Web • HR Tech • Information Technology • Software • Cybersecurity
Develop and maintain analytical data models, datasets, semantic layers, and customer-facing reporting infrastructure. Lead data quality, observability, lineage, and model optimization initiatives while collaborating with data, software, and analytics engineers. Apply SQL and cloud data warehouse expertise, mentor junior engineers, and contribute to engineering best practices, including testing, documentation, version control, and continuous integration.
Top Skills:
AWSAzureContinuous IntegrationDbtGCPGitLookerPower BISnowflakeSQL
Fintech • Software • Financial Services
Build and maintain scalable data models and transformations in Snowflake using advanced SQL, Coalesce, and/or dbt. Develop structured and unstructured data models, optimize queries, support data pipelines and BI reporting, and uphold data quality and governance standards. Collaborate with Product, Engineering, BI, Analytics, and business stakeholders to deliver reliable, business-ready data assets and improve data modeling practices.
Top Skills:
CoalesceDbtSnowflakeSQL
Information Technology • Professional Services • Industrial
Leads complex analytics engineering workstreams and builds scalable data models and solutions using SQL, dbt, Python, and modern data platforms. Drives data quality, testing, CI/CD, documentation, performance, and operational excellence. Partners with cross-functional teams to deliver trusted data products, reporting, and commercial insights. Owns data incidents, mentors engineers, influences technical strategy, and establishes engineering standards across the organization.
Top Skills:
Ci/CdCloud-Based Data PlatformsDbtGitPythonSQL
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
