Date PostedMarch 6, 2023
Expiration dateMay 25, 2023
Join Frontdoor as Senior Data Engineer in Memphis, Frontdoor is a company that’s on a mission to make home ownership simple at all refer details to know more about role and responsibility.
Post: Senior Data Engineer
Work Location: Memphis, Tennessee, United States
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) and an expanding portfolio of home services. Frontdoor serves more than two million customers across the U.S. through a network of 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 unplanned breakdowns of essential home systems and appliances. With more than 45 years of experience, the company responds to over four million service requests annually (or one request every eight seconds). For more details, visit frontdoorhome.com.
Build and maintain scalable data pipelines for both batch and stream processing in a cloud-computing environment. Use Amazon AWS and Google GCP technologies and tools to develop ingestion pipelines. Implement monitoring and logging capabilities using Datadog, Splunk, and Looker. Automatically test and deploy code in production using CICD process. Build data warehouse using dimensional modeling to map business processes into an enterprise data model. Collect business and technical requirements across multiple business areas. Design logical and physical models using Star Schema. Implement robust, high-performance tables in Snowflake database. Build complex ETL infrastructure do deliver clean and reliable data to the organization. Build SQL code to clean, process, and format raw data into tables that can be used for analytics, reporting, and data science. Use Airflow to schedule and orchestrate jobs. Implement unit tests using Data Build Tool (DBT). Enforce production standards and governance best practices in the management of enterprise-level data, metrics, and reports. Be an active participant of code reviews. Develop and enforce coding and data standards to be applied across the team. Mentor junior members of the team. Optimize database architecture by trading off storage and computation to achieve low cost and high-performance. Build well-optimized SQL and Python code that reduces cost while increasing performance. Identify opportunities for cost optimization and propose alternative, more efficient architectures. Monitor storage and minimize wasted storage usage within Snowflake database.
Must have a bachelor’s degree in Computer Science or related and 5 years of data engineering experience, including:
SQL database design
Schema design and dimensional data modeling
Experience designing, building, and maintaining data processing systems
Data models, data mining, and segmentation techniques
Java and Python
Big data pipelines, cloud databases, and data architecture
Apache Spark, Apache Airflow
AWS cloud architecture
Must have AWS Solution Architect Associate Certification.
Remote work is an option.
Need help finding the right job?
We can recommend jobs specifically for you!
Job Locations US-TN-Memphis
Type Full Time
Company AHS American Home Shield Corp
Support words: Frontdoor Vacancy in Memphis, Frontdoor careers in Memphis, Memphis jobs, Jobs nearby me in Memphis Tennessee, career notification in Memphis, Frontdoor Jobs in Memphis,
Yellow Career is the place where you can have the verified jobs belongs to Frontdoor field from listed employers at the single platform, Would you be right fit for yellow gig in Memphis? If not, you could help with passing to the relevant your friends/colleague.