Frontdoor Jobs

Job Information

Frontdoor Principal Data Engineer in Denver, Colorado

You will be responsible for:

  • Creating and maintaining the enterprise data model in Snowflake

  • Merging multiple sets of data via SQL from marketing to finance to operations into data model including data from different brands, products, and marketing tactics

  • Work with the business to understand business goals and translate into Enterprise Data Model architecture that covers multiple brands and products

  • Serve as the SME and DBA for Snowflake including cost optimization and DCL

  • Work with data engineers to help build pipelines into Snowflake using Python and Fivetran. Take over pipelines with ELT processes written

  • Work with BI engineers on how to model data for better visualization via Looker

  • Work with various Data Science groups on sharing data across the enterprise and modeling data in a way that works well for advanced predictive and descriptive analytics

  • Be an expert on homegrown MDM application that collapses unifies all individuals, addresses, households, and organization into persistent keys


  • 7+ years’ experience in architecting large data models unifying varied data sources

  • 7+ years’ experience in advanced SQL queries including DDL, stored procedures, and analytical queries

  • 3+ years’ experience with cloud-based MPP databases like Snowflake, Redshift, BigQuery, or Azure

  • Understanding of cloud-based development platforms like AWS or GCP

  • Must have a strong grasp of business elements and the ability to convert requirements into database models and full-data pipeline systems

  • Familiar with Agile development methodology

  • Background in data science, marketing analytics, and insurance-based data modelling is a plus

Frontdoor is a company that’s obsessed with taking the hassle out of owning a home. With services powered by people and enabled by technology, it is the parent company of four home service plan brands: American Home Shield, HSA, Landmark and OneGuard, as well as Candu Home Solutions, an on-demand membership service for home repairs and maintenance, and Streem, a technology company that enables businesses to serve customers through an enhanced augmented reality, computer vision and machine learning platform. Frontdoor serves more than two million customers across the U.S. through a network of more than 16,000 pre-qualified contractor firms that employ over 45,000 technicians. The company’s customizable home service plans help customers protect and maintain their homes from costly and unexpected breakdowns of essential home systems and appliances. With nearly 50 years of experience, the company responds to over four million service requests annually (or one request every eight seconds). For more details, visit .

Job Category: Engineering

ID: R0014785