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 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 our data engineers and data product manager to understand their needs and translate them into actionable data assets. In this role, you will leverage your expertise in SQL to deliver the right data in the best format through self-serve tools. We value open-source platforms such as DBT, Docker, Gitlab, Grafana, Airbyte 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 and Secrets. Additionally, we incorporate third-party tools like mParticle, Segment, Fivetran, Looker, JIRA, and Slack, while continuously evaluating new technologies to enhance our data strategy. You will be responsible for: - Collaborate with data product managers and 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 domain and 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, and governance of core and domain data models
- Manage data exposures in our BI Tool, Looker, ensuring smooth and reliable 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 product managers, analysts, stakeholders, and data engineers on broader analytics projects
- Assist with both ad-hoc requests and the automation of regular reporting for the business
- Create reports and dashboards as required
Experience with data modelling and data design concepts, including Dimensional Models (Kimball, Inmon, Data Marts) - Excellent SQL skills with a focus on writing performant queries. Experience in other programming languages, such as Python, is a plus but not required
- 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, supply, commercial, and finance teams
- Creative problem solver with an understanding of when a minimal 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 (Tableau, Power BI, Redash, Looker or similar)
- Prior experience using DBT and LookML is a plus but not required
We're a team of 700 passionate and brilliantly talented people across Europe. We're the industry's smartest salon management software, all connected to Europe's leading bookings platform, working with over 50,000 salon partners across 13 countries, processing over 8 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 just have the role for you. We'll treat you with: - 28-days holiday, plus bank holidays
- Monthly £40 Treatwell vouchers so you can treat yourself too
- Mental health support through our partnership with Plumm
- 100% remote position with flexible working
- Growth funds for you to develop and grow with your team
- All the tools / devices supplied to do the best job you can eg. laptop, monitor, keyboard etc
