Data Engineer L4 (Remote)

Frontdoor, Inc. is a home services company that helps homeowners maintain and repair their homes through service plans, professional contractors, and digital solutions. The intermediate-level Data Engineer will transform raw data into useful data systems by building scalable pipelines, data models, ETL infrastructure, and analytics solutions while supporting data governance and business automation.

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

Requirements:

• Bachelor's in Computer Science, Engineering, Data Science, or related field
• 5+ years of experience in data engineering or similar work
• 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
• Masters or PhD
• Full stack experience, including microservice and web app development
• Knowledge of big data platforms, such as Hadoop and Spark