Data Engineer L4 (Remote)

Frontdoor, Inc.; United States; On-site; USD 114,000 - 145,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Stock purchase plan

Job summary

Frontdoor, Inc. is seeking an intermediate level Data Engineer to transform raw data into useful systems and align data architectures with business goals. You will manage projects within larger initiatives and partner with stakeholders to drive data-driven decisions.

The role emphasizes building scalable data pipelines, applying dimensional modeling, and optimizing data infrastructure in a cloud environment.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Data Science, or related field; Masters or PhD preferred.
• 5+ years of experience in data engineering or similar work.
• Excellent communication and inter-personal skills.
• Versatile and quick learner capable of picking up new skills quickly.
• Demonstrated strength in data modeling, ETL development, data warehousing, data pipeline and data lake creation.
• Experience with cloud infrastructure and tools for AWS and GCP.
• Demonstrable proficiency in Python development and advanced SQL querying.
• Strong ability to translate business requirements into database models and pipelines.
• Experience with visualization and reporting tools such as Looker and Tableau.
• Experience with cloud data warehouses such as Snowflake and building data lakes in the cloud.

Responsibilities

• Build and maintain complex scalable data pipelines for batch and stream processing in a cloud environment.
• Apply complex dimensional modeling to design tables and views mapping business processes into an enterprise data model.
• Optimize database architecture by trading off storage and computation for cost and performance.
• Build and support complex ETL infrastructure to deliver clean data for reporting and analytics.
• Support development of new products and services via data ingestion, processing, and formatting for reporting.
• Interact with business stakeholders, build cooperative relationships, and gain domain knowledge.
• Automate manual processes for efficiency, robustness, and speed.
• Help enforce production standards and governance for enterprise data, metrics, and reports.
• Manage projects within larger projects.
• May include other duties as assigned.

Skills

Data modeling

ETL development

Data warehousing

Data pipelines

Python

SQL

Looker/Tableau

Snowflake

Cloud data lakes

Education

Bachelor's degree in CS/Engineering/Data Science

Tools

AWS

GCP

Snowflake

Looker

Tableau

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