Data Engineer L4 (Remote)

Frontdoor, Inc.; Northern (KY); Hybrid; USD 114,000 - 145,000; Full time

Benefits offered by this job

Health, dental, vision insurance

401(k) matching

Employee stock purchase plan

Wellbeing programs

Job summary

Frontdoor, Inc. in the United States is seeking an intermediate Data Engineer to transform raw data into reliable data systems and align data with business goals.

You will build scalable pipelines, apply dimensional modeling, and optimize data architecture across AWS/GCP, Looker, Tableau, and Snowflake. Collaborate with stakeholders, automate processes to improve efficiency, and support new products through data ingestion, processing, and reporting.

Qualifications

• Bachelor’s degree in CS/Engineering/Data Science or related field, with 5+ years in data engineering.
• Strong data modeling, ETL, warehousing, and data lake experience.
• Experience with cloud platforms (AWS/GCP) and Python/SQL.

Responsibilities

• Build and maintain scalable data pipelines for batch and streaming in cloud environments.
• Design tables and views using dimensional modeling to map business processes.
• Optimize architecture for cost, performance, and reliability.
• Deliver clean, reliable data through ETL pipelines for analytics.
• Collaborate with stakeholders to understand data needs and translate into models.
• Automate processes to improve efficiency and governance.
• Support new products via data ingestion, processing, and reporting.

Skills

Data modeling

ETL development

Data warehousing

Data pipelines

Python

SQL

Cloud (AWS/GCP)

Looker

Tableau

Big data tools

Education

Bachelor's in Computer Science, Engineering, Data Science, or related field

Tools

Snowflake

Looker

Tableau

AWS

GCP

Job description

Overview

Frontdoor is reimagining how homeowners maintain and repair their most valuable asset – their home. As the parent company of two leading brands, we bring over 50 years of experience in providing our members with comprehensive options to protect their homes from costly and unexpected breakdowns through our extensive network of pre-qualified professional contractors. American Home Shield, the category leader in home service plans with approximately two million members, gives homeowners budget protection and convenience, covering up to 23 essential home systems and appliances. Frontdoor is a cutting edge, one-stop app for home repair and maintenance. Enabled by our Streem technology, the app empowers homeowners by connecting them in real time through video chat with pre-qualified experts to diagnose and solve their problems. The Frontdoor app also offers homeowners a range of other benefits including DIY tips, discounts and more. For more information about American Home Shield and Frontdoor, please visit frontdoorhome.com .

Responsibilities

Summary:

As an intermediate level Data Engineer, you will use various methods to transform raw data into useful data systems. You will create complex algorithms for the purpose of aligning data systems with business goals. You will manage projects within larger projects.

Responsibilities:

• Build and maintain complex scalable data pipelines for both batch and stream processing in a cloud-computing environment.

• Apply complex dimensional modeling to design tables and views that map business processes into an enterprise data model.

• Optimize database architecture by trading off storage and computation to achieve low cost and high performance.

• Build and support complex ETL infrastructure to deliver clean and reliable data to the organization.

• Support the development of new products and services via ingestion, processing, and formatting data for reporting and analytics.

• Interact face-to-face with business stakeholders, develop cooperative relationships, and acquire domain knowledge of the business.

• Proactively automate manual processes throughout the business for higher efficiency, robustness, and speed.

• Help enforce production standards and governance best practices in the management of enterprise-level data, metrics, and reports.

• Manage projects within larger projects

• May include other duties as assigned.

Qualifications

Minimum Education, Licensure and Professional Certification requirements: Bachelor’s in Computer Science, Engineering, Data Science, or related field (Masters or PhD preferred)

Minimum Experience required: 5+ years of experience in data engineering or similar work

Required Skills:

• Excellent communication and inter-personal skills.

• Versatile and quick learner with ability to pick up any new skills necessary to get the job done.

• Demonstrated strength in data modeling, ETL development, data warehousing, data pipeline and data lake creation.

• Extensive experience with cloud infrastructure and tools for AWS and GCP.

• Demonstrable proficiency in Python development and advanced SQL querying.

• Strong grasp of business elements and ability to convert requirements into database models and full-data pipeline systems.

• Experience with visualization and reporting tools, such as Looker and Tableau.

• Experience with cloud data warehouses such as Snowflake

• Experience building data lakes in the cloud

Preferred Skills:

• Full stack experience, including microservice and web app development.

• Knowledge of big data platforms, such as Hadoop and Spark.

Other/State Specific

This role pays between $114k to $145k, and your actual base pay will depend on your skills, qualifications, responsibilities, experience, and location.

At Frontdoor certain roles are eligible for additional rewards and incentives. Speak directly to your recruiter to learn more.

Our approach to benefits is holistic, and includes health, wellbeing and financial components including: insurance for medical/pharmacy, dental, vision, life, and disability, weight loss and smoking cessation programs, matching 401(k) and ability to participate in our employee stock purchase plan.

Job Locations

US

ID 2026-4177

Category Engineering

Type Full Time

Company AHS American Home Shield Corp