Senior Data Engineer

Many Group; United Kingdom; Remote; GBP 40,000 - 80,000; Full time

Job summary

Join a forward-thinking company dedicated to enhancing the lives of pets and their owners as a Senior Data Engineer. In this pivotal role, you'll lead the charge in transforming data processes and building a robust data warehouse that supports business intelligence and AI initiatives. Your expertise will drive the creation of efficient data pipelines, while your leadership will inspire a culture of collaboration and innovation. This is an exciting opportunity to make a significant impact in a fast-paced environment where your contributions will directly influence data-driven decision-making. If you’re passionate about data and eager to drive change, we want you on our team!

Benefits

Best-in-class technology

Financial support for home office setup

Vision support

Flexible working hours

Qualifications

• Strong SQL skills for complex queries and large datasets.
• Expertise in dimensional data models for analytics.

Responsibilities

• Architect and build scalable data pipelines aligned with business needs.
• Mentor junior data engineers and foster knowledge-sharing.

Skills

SQL

Dimensional Data Modeling

Apache Airflow

Python

Data Governance Practices

CI/CD Principles

Event-Driven Design Patterns

Job description

About us

We love pets - which is why we’re on a mission to make the world a better place for pets and their parents. We offer pet insurance policies with generous pet health benefits that are designed with their needs in mind. We’ve helped half a million pets stay happy and healthy since 2017 - and many more customers throughout the world are joining us every day. Our company is respectful, fun-loving and (most importantly) passionate about pets and their wellbeing. Throughout our business you'll meet people who think differently, aim for impact, and love to try new things. Want to join our pack? Join us. Love every moment. Love ManyPets.

A day in the life

As a Senior Data Engineer at ManyPets, you'll be at the forefront of our data transformation journey, playing a crucial role in our transformation into modern data warehouse powering the business and AI. You will deep-dive into complex ELT processes, design innovative solutions to integrate first-party and third-party data sources resiliently. As you work, you're constantly building data models that are effective and consumable, and you will translate business requirements into well-curated datasets that answer critical questions.

Throughout the day, you'll wear multiple hats - from maintaining and improving our data platform to mentoring junior team members and championing best practices in data engineering. You might spend a few hours collaborating with upstream teams to ensure incoming data meets quality standards, then switch gears to work with analysts and data scientists, transforming raw data into actionable insights. The fast-paced environment keeps you on your toes, as you adapt to ever-changing business needs and lead creative initiatives to enhance our data infrastructure.

As the day winds down, you might find yourself in a brainstorming session, exploring new ways to make ManyPets a leader in the data space. You're not just writing code; you're architecting the backbone of our data platform, working with both dimensional and transactional models to create a mature, scalable system. Your role is central to our success, as you balance technical expertise with business acumen, constantly pushing the boundaries of what's possible with our data. It's a challenging but rewarding position, where your leadership and innovation directly impact the company's data-driven decision-making capabilities.

Your responsibilities

• Architect and build scalable, efficient data pipelines and models aligned with business needs optimising for performance and cost.
• Actively participate in mobbing and knowledge-sharing sessions, fostering a collaborative environment.
• Provide input on improving the scalability, reliability, and performance of the data platform. Identify and resolve issues to minimise downtime and ensure reliable data delivery.
• Support and enforce data governance policies, including data access, retention, and quality.
• Establish frameworks for metadata management, data lineage, and monitoring of data quality issues.
• Implement advanced strategies like data partitioning, indexing, and clustering to improve speed and reduce costs.
• Provide mentorship to junior data engineers, offering guidance on problem-solving, code reviews, and career development. Take ownership of your responsibilities while diplomatically managing workload and help build a culture of knowledge-sharing and continuous improvement within the team.

Your skills and experience

• Strong proficiency in SQL for writing complex queries, optimising for performance, and managing large-scale datasets.
• Expertise in designing and implementing dimensional data models (e.g., Star/Snowflake schema) for analytics.
• Knowledge of event-driven design patterns and decoupling systems.
• Extensive experience in building and managing data workflows using Apache Airflow for orchestration and scheduling.
• Proficient in implementing data governance practices, including data ownership, lineage, and quality monitoring.
• Foundation in understanding of CI/CD principles, implementing automated testing, and deployments for data pipelines.
• Proficient in Python and using it to support the data warehouse.

Ways of working

On a typical day you’ll be working from a laptop with a screen, mouse, keyboard, and headset. You’ll be meeting your colleagues on Zoom and keeping in touch regularly via email and Slack too – we’d expect you to be using your computer for around seven hours a day. We’d ask that you have a distraction-free work area and a reliable internet connection with a speed of 25Mbps so you can work effectively. We’ll make sure you have the right home set-up that supports you in the role by providing best-in-class technology, money towards a desk, and vision support.

Inclusion at ManyPets

We promise to give you the same opportunities as everyone else and we won’t discriminate against you at any point in the process. This includes how we source talent, our interview process, our conditions of employment (including pay) and feedback. If you'd like to read more about this, please download our Approach to Inclusion policy.

Reasonable adjustments and support

If you need any help, support, or advice at any point during the hiring process please email [e-mail]. If you want to ask any questions or request an adjustment, please let us know and we'll do what we can to flex our approach.

Connect with us!

LinkedIn | Glassdoor | Indeed | FeeFo | Trustpilot | YouTube | Instagram | Facebook | Twitter | TikTok | USA Instagram | Facebook | Twitter