Analytics Engineer

AnaVation LLC; Remote; GBP 55,000 - 65,000; Full time

Job summary

A growing pet travel solution company is looking for a highly motivated Analytics Engineer in the UK. The role involves transforming raw data into reliable datasets and collaborating with stakeholders to build scalable data pipelines. Candidates should have strong SQL and DBT skills, along with a solid understanding of ETL processes. The position offers a salary of £55,000-£65,000 and benefits including a remote work option and generous equity options.

Benefits

Generous equity options

Discretionary 10% annual bonus

25 days holiday

Pension scheme

Bupa Health Insurance

Monthly working from home stipend

Qualifications

• 3+ years of experience in analytics engineering or data engineering.
• Hands-on experience with advanced modeling techniques in DBT.
• Strong understanding of data warehousing principles and analytics best practices.

Responsibilities

• Design and maintain robust data models in DBT for analytics.
• Optimize data transformation for scalability.
• Ensure data accuracy and governance through validation.

Skills

Advanced SQL skills

DBT skills

ETL/ELT processes

Data visualization tools

Git-based workflow

Tools

Databricks

Fivetran

Mode

Job description

TrustedHousesitters is a fast growing, direct-to-consumer marketplace that is redefining pet care and travel.

Here at TrustedHousesitters, we’re on a mission to make travel work better for pets, for their people, and for the global community of animal lovers who look after them. We’ve got big plans on becoming the world’s most-loved travel solution for pet people. We’ve built something pretty special: a trusted place where pet owners and sitters connect to keep pets happy at home while their humans explore the world.

We’ve already grown into a global community with members in over 140 countries, a product people genuinely love, and a team of more than 100 brilliant humans powering it all.

But we’re only just getting started. Our goal? To grow to 1 million members and make TrustedHousesitters the world’s most-loved travel solution for pet people.

At the moment, a sit starts every two minutes somewhere on the planet. We want that to be every single minute and we know the only way we’ll get there is with the right people in the right roles.

The right people in the right roles will shape our future. So, here’s the big question: Could that be you?

We are looking for a highly motivated Analytics Engineer with strong skills working in dbt to join our growing data team. In this role, you will be responsible for transforming raw data into clean, reliable, and well-documented datasets that enable self-serve analytics and advanced data modeling across the business.

You’ll sit in our growing Data Platform team, working closely with our Data Manager, Engineers, and business stakeholders to create scalable data pipelines and semantic layers that power reporting, dashboards, MLOps and decision-making. You’ll be working with a modern data stack that is built around Databricks, Segment, Fivetran and dbt.

This is a remote, UK-based role, and the hours of work are 37.5 hours per week. The salary range will be £55,000-£65,000 per annum, dependent on experience, plus discretionary bonus and generous equity options.

Key Responsibilities

• Data Modeling: Design, build, and maintain robust, tested, and documented data models in dbt to support analytics and business intelligence.
• Data Transformation: Optimise the way in which our transformation layer builds to ensure scalability
• Collaboration: Partner with data analysts, data scientists, and business stakeholders to understand data needs and translate them into technical solutions.
• Governance & Quality: Ensure data accuracy, consistency, and security through validation testing and monitoring tools.
• Documentation: Maintain clear documentation for datasets, definitions, and data flows to support data literacy and self-serve analytics.
• Tooling & Automation: Improve and automate data workflows, version control, and deployment practices across the analytics stack.

Qualifications

• 3+ years of experience in analytics engineering, data engineering, or a related field.
• Advanced SQL skills and experience working with modern data warehouses (e.g., Snowflake, BigQuery, Redshift - we use Databricks).
• Hands‑on experience with advanced modelling techniques in dbt.
• A deep understanding of ETL/ELT processes and tools (e.g. Airbyte, Stitch - we use Fivetran).
• Experience with data visualisation tools (e.g. Looker, Tableau, Power BI - we use Mode) and BI semantic layers.
• Strong understanding of data warehousing principles, dimensional modelling, and analytics best practices.
• Git‑based workflow familiarity (version control, CI/CD pipelines for data).
• Excellent communication skills and ability to work cross‑functionally.

Nice to have

• Experience in a cloud environment (e.g. AWS, GCP, Azure).
• Exposure to Python for data scripting or orchestration.
• Experience designing and implementing data models using Medallion Architecture.
• Background in a fast‑paced, high‑growth environment (e.g., tech, SaaS, ecommerce).
• Knowledge of data privacy and governance frameworks.
• Experience using Databricks

£55,000 - £65,000 a year

Benefits

• Fully remote work
• Generous equity options
• Discretionary 10% annual bonus scheme
• 25 days holiday annually plus bank holidays and Christmas to New Year closure
• Pension scheme: 5% from you as an employee and 3% from TrustedHousesitters
• Premium TrustedHousesitters pet owner and sitter membership. This includes benefits like airport lounge passes, sit cancellation insurance, and home and contents insurance for sits for you
• X5 premium memberships for your friends and family each year
• Our team have an unlimited housesitting allowance, can work remotely from their sits, and are eligible to £500 per year towards travel costs
• £200 annually towards home office equipment
• Access to Spaces (co‑working) Locations across the globe
• Monthly working from home stipend
• Macbook
• Find a rescue pet to join your family and we’ll cover the adoption fees, as well as paternity to help any pet settle into their new home.
• We host a quarterly all‑expenses paid meet‑up and will fund team events (remote or in‑person) throughout the year
• We can cover costs of personal development resources, and have a regular time set aside for personal development
• Bupa Health Insurance and Dental Insurance plan
• SimplyHealth Healthcare Cash plan
• Trusted Giving scheme - employee volunteering via Onhand and employee giving via Tyve
• Weekly virtual yoga sessions
• Brighton Bikeshare
• Recruitment Referral Bonus

If you’re ready to join us on our mission to become the most loved pet travel solution, we’d love to hear from you!

In your application, please feel free to note which pronouns you use (For example- she/her/hers, he/him/his, they/them/theirs, etc).

At the heart of our team are a mix of diverse backgrounds. Here at TrustedHousesitters, we’re committed to the equal opportunities policy throughout the interview process and selection. Offers of employment into TrustedHousesitters are based solely on individual merit, qualifications, and the person's professional suitability.

Gender identity, sexual orientation, marital or civil partnership status, colour, race, nationality, ethnic or national origins, religion or beliefs, age, mental or physical disability, medical condition, pregnancy or maternity status, or any other protected characteristics do not enter into our decision‑making process.