Data Analytics Engineer

We are looking for a Data Analytics Engineer to join our passionate and diverse Data Team. Treatwell is an organisation built on data, but we’re just getting started. In this role, you will be instrumental in shaping our future by ensuring that our data models and analytical capabilities adapt to the rapid pace of our business.

As part of the Data Domain Team, you will take ownership of the end-to-end delivery of our data products designed to empower analysts, product managers, and key business stakeholders with valuable insights. You will collaborate closely with various teams to understand their needs and translate them into actionable data assets. 

In this role, you will leverage your expertise in SQL and data model design to deliver the right data in the best format through self-serve tools. We value open-source platforms such as DBT, Airbtye, Docker, Gitlab and Airflow orchestration in our tech stack. Our services run on a modern cloud platform using Amazon AWS, including Redshift, ECS, Lambda, Cloudwatch, S3, EMR, EC2, Athena. Additionally, we incorporate third-party tools like Fivetran, Monte Carlo, Looker, JIRA, and Slack, while continuously evaluating new technologies to enhance our data strategy.

About Treatwell

Hi, we’re Treatwell. Nice to meet you.

We’re a team of 500 (and growing) passionate and brilliantly talented people across Europe. We’re the industry’s smartest salon management software, all connected to Europe’s leading booking platform, working with over 31,000 salon partners across 13 countries and processing over 4 million bookings every month. And….breathe.

But we’re not done yet. We’re on an exciting journey to digitally revolutionise the hair and beauty community.

If this excites you, we might have just the role for you.

You will be responsible for:

• Collaborate with various business teams to understand their needs and create relevant data assets that reveal performance and key action points within their areas 
• Perform data modelling of core data assets using SQL, DBT, and LookML 
• Contribute to the strategy and design of data models and the data warehouse
• Support the discovery and integration of new data from various sources (OLTP, APIs, S3)
• Empower analysts and business users through self-serve tools, education, and documentation
• Define and manage data quality, documentation, observability and governance of core data models 
• Manage data exposures in our BI Tool, Looker, ensuring smooth delivery of data to the business
• Automate repetitive analyses and tasks whenever possible
• Foster a data-driven culture and approach to decision-making
• Collaborate with analysts, stakeholders, and data engineers on broader analytics projects
• Assist with both ad-hoc requests and the automation of regular reporting for the business

Requirements

About You

• Strong experience with data modelling and data design concepts, especially Dimensional Models (Kimball, Inmon, Data Marts) but also OBT 
• Excellent SQL skills with a focus on writing performant queries. Experience in other programming languages, such as Python, is a plus
• A passionate team player who enjoys collaborating and pairing to achieve shared goals 
• Articulate communicator comfortable discussing technical matters with both engineers and stakeholders at all levels of the business 
• Experienced in working with and understanding various business functions such as product, marketing, commercial, and finance teams
• Creative problem solver with an understanding of when a minimally viable solution can deliver 80% of the required needs ahead of a fully perfect solution
• Proficient with version control principles, git, and the command-line interface 
• Familiarity with ETL (ELT) Tools such as DBT (preferred), GCP,  SSIS, Databricks, Airflow
• Analytical mindset with exposure to data warehouses from a previous role
• You are experienced with BI Visualisation tools
• Prior experience using DBT and LookML is a plus 
• You can communicate fluently in English
  

Benefits

We’ll treat you with:

• 28 days holiday, plus bank holidays
• Monthly 40 EUR Treatwell vouchers so you can treat yourself too.
• Growth funds for you to develop and grow with your team.

Equal Ops

Treatwell is an ‘Open to All’ employer and warmly welcomes everybody to the team. We are committed to making reasonable adjustments to the recruitment process as required. Please add any adjustment requests to your application.