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.