Senior Data Analytics Engineer
Treatwell · Spain
- Hybrid
- Full-time
- €100,000 / year
- Spain
Job highlights
- Own data products end-to-end for business insights.
- Build and design data models using SQL, Python, DBT.
- Develop ML models with Python and AWS SageMaker.
- Modernize data stack to a Lakehouse architecture.
- Foster a data-driven culture across Europe.
About the role
Senior Data Analytics Engineer - Treatwell
We're looking for a Senior Data Analytics Engineer to join our passionate and diverse Data Team at Treatwell. You'll be instrumental in shaping our future by ensuring our data models and analytical capabilities keep pace with the rapid growth of our business. As part of the Data Domain Team, you'll take end-to-end ownership of data products that empower analysts, product managers, and business stakeholders with meaningful insights. You'll work closely with teams across the business, translating their needs into reliable, well-structured data assets. You'll bring strong expertise in SQL, Python, and data model design to deliver the right data in the best format through self-serve and Machine Learning-enabled tools. We work with open-source platforms including DBT, Airbyte, Docker, GitLab, SageMaker, and Airflow. Our services run on AWS, including Redshift, ECS, Lambda, Cloudwatch, S3, EMR, and EC2, alongside third-party tools like Fivetran, Monte Carlo, Looker, JIRA, and Slack. We're also at an exciting point in our data journey with plans to modernise our data stack and transition to a Lakehouse architecture. This is a great opportunity to help shape the direction of how we store, model, and access data at Treatwell.
You Will Be Responsible For
- Collaborating with your data peers and business teams to understand their needs and build data products that surface performance insights and drive action.
- Modelling core data assets using SQL, DBT, Python and LookML.
- Supporting the development of Machine Learning models using Python and AWS SageMaker.
- Contributing to the strategy and design of data models and the data warehouse.
- Supporting the discovery and integration of new data sources (OLTP, APIs, S3).
- Empowering analysts and business users through conversational analytics, self-serve tooling, education, and documentation.
- Defining and managing data quality, documentation, observability, and governance of core data models.
- Managing data exposures in Looker, ensuring smooth and reliable delivery of data to the business.
- Automating repetitive analyses and tasks wherever possible.
- Investigating and proposing solutions for data warehouse issues arising from daily query processing and end-user needs.
- Fostering a data-driven culture across the organisation.
Requirements
About You
- Strong experience with data modelling and design concepts, including Dimensional Models (Kimball, Inmon, Data Marts) and OBT.
- Excellent SQL skills with a focus on writing performant queries.
- Strong working knowledge of Python, including data transformation and data science packages such as pandas and numpy.
- A collaborative team player who enjoys pairing and working toward shared goals.
- A confident communicator, comfortable discussing technical topics with both engineers and non-technical stakeholders at all levels.
- Experience working with and understanding business functions such as product, marketing, commercial, and finance.
- A creative problem solver who knows when an 80% solution delivered quickly is more valuable than a perfect one delivered late.
- Proficient with version control principles, Git, and the command line.
- Familiarity with ELT tools such as DBT (preferred), Airflow, Databricks, or similar.
- An analytical mindset with prior exposure to data warehouses.
- Prior experience with DBT and LookML is a plus.
- You communicate fluently in English. Any other European language will be a plus.
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.
We'll Treat You With
- 28-day holiday, plus bank holidays.
- Monthly 40 EUR Treatwell vouchers so you can treat yourself too.
- Mental health support through our partnership with Open-Up.
- 100% remote position within Spain or Italy.
- Market-related benefits.
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.
Key skills/competency
- Data Modelling
- SQL
- Python
- DBT
- AWS
- Data Warehousing
- ETL/ELT
- Business Intelligence
- Data Governance
- Data Analysis
Skills & topics
- Data Analytics Engineer
- Senior Data Engineer
- Data Modeling
- SQL
- Python
- DBT
- AWS
- Data Warehousing
- ETL
- Business Intelligence
- Data Governance
- Data Analysis
- Machine Learning
- Remote
- Spain
- Italy
How to get hired
- Tailor your resume: Highlight your expertise in data modelling, SQL, Python, DBT, and AWS, aligning with Treatwell's technical stack.
- Showcase collaboration: Emphasize your experience working with cross-functional teams and communicating technical concepts to non-technical stakeholders.
- Demonstrate problem-solving: Provide examples of your creative problem-solving skills and how you've delivered effective solutions under pressure.
- Prepare for technical interviews: Be ready to discuss data modelling concepts, write performant SQL queries, and explain Python data transformation techniques.
- Understand Treatwell's mission: Research Treatwell's impact on the hair and beauty industry and their commitment to a data-driven culture.
Technical preparation
Behavioral questions
Frequently asked questions
- What are the key technical skills required for the Senior Data Analytics Engineer role at Treatwell?
- The Senior Data Analytics Engineer role at Treatwell requires strong expertise in SQL for performant query writing, Python for data transformation and data science packages (like pandas and numpy), and data modelling concepts (Dimensional Models, OBT). Familiarity with ELT tools such as DBT (preferred), Airflow, or Databricks, along with version control (Git), is also essential. Experience with AWS services and LookML is a plus.
- What is the work arrangement for this Senior Data Analytics Engineer position at Treatwell?
- This Senior Data Analytics Engineer position at Treatwell is a 100% remote position, specifically within Spain or Italy.
- What opportunities for growth and impact does this role offer?
- As a Senior Data Analytics Engineer at Treatwell, you will have end-to-end ownership of data products, directly influencing business insights and decision-making. You'll play a key role in modernizing the data stack and transitioning to a Lakehouse architecture, significantly shaping the future of data at Treatwell. You'll also foster a data-driven culture across the organization.
- What is the company culture like at Treatwell?
- Treatwell fosters a passionate and diverse culture with a team of 500 talented individuals across Europe. They are committed to digitally revolutionizing the hair and beauty community and operate as an 'Open to All' employer, welcoming diversity and providing necessary adjustments for the recruitment process.
- What are the benefits offered to employees at Treatwell for this role?
- Treatwell offers a comprehensive benefits package including 28 days of holiday plus bank holidays, monthly 40 EUR Treatwell vouchers, mental health support through Open-Up, and market-related benefits, alongside the 100% remote work arrangement within Spain or Italy.
- What data stack technologies does Treatwell utilize?
- Treatwell utilizes a range of open-source and AWS-based technologies. These include DBT, Airbyte, Docker, GitLab, SageMaker, Airflow, Redshift, ECS, Lambda, Cloudwatch, S3, EMR, EC2, Fivetran, Monte Carlo, and Looker.
- How does Treatwell approach data quality and governance?
- Treatwell emphasizes defining and managing data quality, documentation, observability, and governance of core data models. This ensures the reliability and trustworthiness of the data products and insights delivered to the business.