Data Engineering Solutions Architect (Remote)

Virtual, USA

  • ID:2024-3406
  • Category: Computer Programmers


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 .


Summary :

As a Data Engineer Solutions Architect, you will be instrumental in crafting and executing advanced data architectures and acquisition strategies and integrating complex analytical models into our sophisticated data platform. This role demands a collaborative spirit to work with cross-functional teams, ensure the development and implementation of solutions that meet and exceed business requirements, and optimize the utilization of data assets.


  • Hands-on design and deploy scalable, high-performance, real-time data architectures on AWS, complemented by proficiency in GCP and OCI.

  • Pioneer the integration of Generative AI and LLM technologies to bolster our data analysis and innovation capabilities.

  • Construct and manage efficient data pipelines using tools such as Snowflake, dbt, Kafka, Airflow, and Fivetran, focusing on seamless data ingestion, processing, and distribution.

  • Facilitate API integrations with external data sources like Salesforce and Qualtrics, ensuring their coherent incorporation into our centralized data strategy.

  • Champion data governance and observability frameworks to uphold data integrity, compliance, and security across all platforms.

  • Utilize MongoDB to develop sophisticated database solutions and enhance data storage and retrieval mechanisms.

  • Implement and promote microservices architecture as needed, aligning technology solutions with business strategies through scalable and maintainable application development.

  • Lead the adoption of business-focused domain architectures, effectively marrying technology solutions with business goals.

  • Master and apply various data modeling techniques, including dimensional modeling, with emphasis on Star and other related analytical modeling techniques.

  • Engage with internal stakeholders to deeply understand data needs, delivering solutions that drive strategic business objectives.

  • Offer leadership and mentorship to the data engineering team, cultivating a culture of innovation and continuous learning.


Minimum Experience required :

  • Bachelor’s or MS in Computer Science, Engineering, Data Science, or a related field preferred.

  • A minimum of 7 years in data engineering, with a demonstrated focus on cloud solutions (AWS, with GCP and OCI as a plus).

  • Expertise in Snowflake, dbt, Airflow, Fivetran, and Kafka, with experience in Oracle and Mongo databases, is a plus.

  • Proven capability in integrating external APIs from platforms like Salesforce and Qualtrics.

  • Proficiency in programming languages (Python, SQL, Scala) and familiarity with big data technologies (Hadoop, Spark).

  • Deep knowledge of data governance and observability tools, ensuring high data quality, security, and compliance.

  • Understanding of microservices architectures and the implementation of business-focused domain architectures.

  • Advanced skills in various data modeling techniques and schema types, showcasing an ability to design efficient and scalable data architectures.

Other/State Specific

This role pays between $ 160k to $190k , 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.

Need help finding the right job?

We can recommend jobs specifically for you!

Job Locations US

ID 2024-3406

Category Computer Programmers

Type Full Time

Company AHS American Home Shield Corp

Apply Now opens a new window

Frontdoor is a company that’s obsessed with taking the hassle out of owning a home. With services powered by people and enabled by technology, it is the parent company of four home service plan brands: American Home Shield, HSA, Landmark and OneGuard, as well as AHS Proconnect , an on-demand membership service for home repairs and maintenance, and Streem, a technology company that enables businesses to serve customers through an enhanced augmented reality, computer vision and machine learning platform. Frontdoor serves more than two million customers across the U.S. through a network of more than 16,000 pre-qualified contractor firms that employ over 45,000 technicians. The company’s customizable home service plans help customers protect and maintain their homes from costly and unexpected breakdowns of essential home systems and appliances. With nearly 50 years of experience, the company responds to over four million service requests annually (or one request every eight seconds). For more details, visit