Data Engineer L4

frontdoor, Inc.•,

4d•$114,000 - $145,000

About The Position

Frontdoor is hiring an intermediate-level Data Engineer to transform raw data into useful data systems and develop complex algorithms that align data systems with business goals. The role manages projects within larger projects and supports enterprise data systems, products, services, reporting, and analytics. The Data Engineer builds and maintains scalable batch and stream data pipelines in cloud environments; applies dimensional modeling to represent business processes in an enterprise data model; and optimizes database architecture for cost and performance. The role also builds and supports ETL infrastructure, ingests and formats data for products and analytics, works directly with business stakeholders to develop domain knowledge, automates manual processes, and helps enforce production and data-governance standards. Other duties may be assigned.

Requirements

Bachelor’s degree in Computer Science, Engineering, Data Science, or a related field.
At least 5 years of experience in data engineering or similar work.
Excellent communication and interpersonal skills.
Ability to learn quickly and acquire new skills as needed.
Demonstrated strength in data modeling, ETL development, data warehousing, data pipeline creation, and data lake creation.
Extensive experience with AWS and GCP cloud infrastructure and tools.
Proficiency in Python development and advanced SQL querying.
Ability to understand business requirements and convert them into database models and end-to-end data pipeline systems.
Experience with visualization and reporting tools such as Looker and Tableau.
Experience with cloud data warehouses such as Snowflake.
Experience building cloud data lakes.

Nice To Haves

Master’s or Ph.D. degree.
Full-stack experience, including microservice and web application development.
Knowledge of big data platforms such as Hadoop and Spark.

Responsibilities

Build and maintain complex, scalable data pipelines for 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 balancing 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 new products and services by ingesting, processing, and formatting data for reporting and analytics.
Interact face-to-face with business stakeholders, develop cooperative relationships, and acquire business domain knowledge.
Proactively automate manual business processes to improve efficiency, robustness, and speed.
Help enforce production standards and governance best practices for enterprise data, metrics, and reports.
Manage projects within larger projects.
Perform other duties as assigned.