Data Engineer L4

Frontdoor, Inc.

United States

Remote

USD 114,000 - 145,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health insurance
Dental insurance
Vision insurance
Life insurance
Disability insurance
401(k) matching
Employee stock purchase plan

Job summary

AHS American Home Shield Corp is seeking an intermediate Data Engineer to transform raw data into usable data systems and align data initiatives with business goals.

You will build scalable data pipelines, apply dimensional modeling, and optimize data architectures in a cloud environment. Collaboration with stakeholders and automation of processes are key aspects of the role.

Qualifications

  • Bachelor’s in Computer Science, Engineering, Data Science, or related field (Masters or PhD preferred).
  • 5+ years of experience in data engineering or similar work.
  • Proficient in Python development and advanced SQL.
  • Experience with cloud infrastructure (AWS and GCP) and data warehousing.

Responsibilities

  • Build and maintain complex scalable data pipelines for batch and stream processing in a cloud environment.
  • Apply dimensional modeling to design tables and views mapped to enterprise data model.
  • Optimize database architecture balancing storage and compute for cost and performance.
  • Develop ETL infrastructure delivering clean data for reporting and analytics.
  • Support product development by ingesting, processing, and formatting data for reporting.
  • Engage with business stakeholders to gather domain knowledge.
  • Automate manual processes for efficiency and robustness.
  • Enforce production standards and governance for enterprise data and reports.
  • Manage projects within larger initiatives.

Skills

Data modeling
ETL development
Data warehousing
Data pipeline
Python
SQL
Cloud (AWS
Cloud (GCP)
Looker
Tableau
Snowflake

Education

Bachelor’s in Computer Science, Engineering, Data Science, or related field
Masters or PhD preferred

Tools

Looker
Tableau
Snowflake
AWS
GCP
Python
SQL

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.

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.

  • insurance for medical/pharmacy
  • dental
  • vision
  • life
  • 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-4211

Category

Engineering

Type

Full Time

Company

AHS American Home Shield Corp

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer (Remote)
Data Engineer (Remote)

Frontdoor, Inc. • Idaho

Remote
USD 85,000 - 107,000
Insurance for medical/pharmacy
Dental and vision insurance
Matching 401(k)
+1
Data Quality Specialist
Data Quality Specialist

Frontdoor, Inc. • Idaho

On-site
USD 66,000 - 90,500
Medical, dental, and vision insurance
401(k) matching
Employee stock purchase plan
Software Engineer L4 (Remote)
Software Engineer L4 (Remote)

Frontdoor, Inc. • United States

Hybrid
USD 103,000 - 120,000
Health insurance
401(k) matching
Stock purchase plan
+1
Software Engineer III - Build Scalable Home Tech
Software Engineer III - Build Scalable Home Tech

Frontdoor, Inc. • United States

Hybrid
USD 85,000 - 120,000
Health insurance
401(k) matching
Employee stock purchase plan
+1
Software Engineer IV – Product & Scale
Software Engineer IV – Product & Scale

Frontdoor, Inc. • United States

Hybrid
USD 103,000 - 120,000
Health insurance
401(k) matching
Stock purchase plan
+1
Sr. Software Engineer (Frontend)
Sr. Software Engineer (Frontend)

Frontdoor, Inc. • Idaho

Remote
USD 123,000 - 140,000
Health benefits
Retirement plan
Flexible working hours
Software Engineer L3
Software Engineer L3

Frontdoor, Inc. • United States

Hybrid
USD 85,000 - 120,000
Health insurance
401(k) matching
Employee stock purchase plan
+1
Database Engineer (Remote)
Database Engineer (Remote)

Frontdoor, Inc. • Idaho

Remote
USD 100,000 - 125,000
Health insurance
401(k) matching
Employee stock purchase plan
Software Quality Engineering L4
Software Quality Engineering L4

Frontdoor, Inc. • United States

Remote
USD 103,000 - 120,000
Health insurance
Dental insurance
Vision insurance
+2
Sr. Solution Architect (Remote)
Sr. Solution Architect (Remote)

Frontdoor, Inc. • Idaho

Remote
USD 145,000 - 195,000
Insurance for medical/pharmacy
Dental and vision insurance
401(k) matching
+1