Note: The job is a remote job and is open to candidates in USA. Frontdoor is reimagining how homeowners maintain and repair their homes through home service plans, digital tools, and expert contractor networks. The intermediate-level Data Engineer will build scalable data pipelines, develop enterprise data models and ETL infrastructure, optimize cloud data architecture, and support reporting, analytics, and data governance initiatives.
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
Skills
- 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 preferred
- Full stack experience, including microservice and web app development
- Knowledge of big data platforms, such as Hadoop and Spark
Benefits
- Additional rewards and incentives for eligible roles
- Insurance for medical/pharmacy, dental, vision, life, and disability
- Weight loss and smoking cessation programs
- Matching 401(k)
- Ability to participate in the employee stock purchase plan
Company Overview