Data Engineer L4

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.

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.

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.

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.