Staff Data Engineer, RVU

• Advanced SQL, including writing complex queries, partitioning, clustering and cost-aware query optimisation
• Experience of modern orchestration/ELT tooling, ideally Dagster and dbt
• Strong Python for data engineering
• Solid understanding of data warehousing techniques; ETL/ELT processes and dimensional modelling
• Experience designing data models and documentation that are usable by AI/LLM-based analytics tools (semantic layers, metadata, access controls)
• In-depth knowledge of cloud data infrastructure, ideally GCP (Azure or AWS also considered)
• Excellent problem-solving skills and the ability to work independently and collaboratively in a fast-paced environment
• Hands-on experience building CI/CD pipelines to test and deploy data code reliably across environments
• Proficiency with Git/DevOps for version control and collaboration
• You don’t need to tick off everything on this list - so don’t let that hold you back from applying. We want to make sure you’re learning plenty during your time with us!

Desirable

• The Data and Analytics team within Tempcover provide a vital role in bringing data, MI and Insight to life for internal & external stakeholders and partners
• The Staff Data Engineer will be responsible in partnership with the Data Engineering team for the development of the Tempcover cloud based data platform, supporting the wider business in making data-driven decisions
• Drive the development and optimisation of data pipelines, data models and data quality controls. This role will require collaboration with data analysts and business stakeholders to translate data needs into scalable and reliable solutions
• Tempcover has chosen Google BigQuery, Dagster+ and dbt as the foundation of its new data platform, and you'll help build it. We're delivering the first "pizza slice" now: a thin, end-to-end piece of the platform that proves the architecture and gives stakeholders value early
• You’ll spend most of your time building new capability on our GCP platform. You’ll also help support and maintain the existing Azure platform, keeping it dependable and helping us decommission it over the next twelve months
• This is a deliberate redesign, not a lift-and-shift. The platform has grown over five years through new data models, integrations and technologies
• We're now using that experience to define what "great" looks like. Several significant upcoming projects will create more data for our analysts to use in marketing, pricing, product and commercial decisions. In particular, we want an AI first data platform that analysts and stakeholders can use directly
• Raise the technical bar. Work with our Staff and Lead Data Engineers to set the architecture and engineering standards for the new platform, and bring a fresh view of what "great" looks like
• Deliver in slices. Deliver high-value features on BigQuery quickly to win stakeholder buy-in, on foundations that can support future AI and advanced analytics
• Keep Azure running. Help support the existing platform and keep it dependable while we move away from it over the next 12 months
• Challenge and influence. Question the status quo, steer technical direction, and help the wider team do the same
• Own the outcome. Stay with the platform from the first slice to a fully scaled ecosystem that grows with Tempcover's ambition to be the outright leader in the temp market
• Design, build and maintain ELT pipelines on BigQuery using dbt and Dagster+, with reliability, testing and idempotency built in from the start
• Create and manage accurate and performant data models to support Tempcover’s analytical capability
• Propose and implement internal improvement initiatives to the data platform
• Lead proactive approach to performance monitoring/tuning
• Implement data contracts, observability and lineage so that data quality issues are caught early and downstream consumers can trust and trace what they use
• Define and champion engineering standards, including CI/CD, infrastructure-as-code and testing practices, across the data platform
• Provide continued support to ensure high availability of data to the wider business
• Work closely with analysts across MI, Marketing, Product, Underwriting and Pricing to understand data requirements and translate them into effective solutions
• Work with rigour to ensure data quality/accuracy
• Mentor and guide junior data engineers, providing technical expertise and project oversight