Data Engineer L4 (Remote)

Frontdoor, Inc. is a home services company that helps homeowners maintain and repair their homes through home service plans, technology, and contractor networks. The Data Engineer will transform raw data into reliable data systems by building scalable pipelines, modeling enterprise data, optimizing databases, and supporting reporting, analytics, and new products.

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