Senior Data Integration Engineer

At HomeAdvisor, we create digital products and experiences to help hundreds of millions of homeowners connect with talented service professionals to get work done. We are a two-sided marketplace that is reimagining how people care for and improve their homes while also nurturing growth of independent small businesses. As #1 in the Homeservices category, our tremendous scale is the launchpad to boundless inventions in technology and product!

The Team and Role
HomeAdvisor is looking for a Senior-level Data Integration Engineer to play a key role on the Enterprise Intelligence Data Warehouse/Business Intelligence team. The successful candidate will develop and maintain strong relationships with teammates while ensuring delivery of high-quality Engineering solutions. In addition to intrateam partnerships ; development and maintenance of inter-team and business customers relationships will be a must . This role requires the candidate to demonstrate deep hands-on expertise in complex SQL development concepts, scripting for data integrations, ETL Architecture, Design, Development, and testing.

• Design, develop, and implement data-integration solutions to effectively process high-volume disparate data sources and meet processing SLAs
• Design, develop, and implement data base architecture that meets the analytic and reporting needs of the business.
• Interact closely with business partners and Engineering teams to determine analytics and reporting needs and translate those needs intoefficient & scalable data integration processes
• Participate and contribute to enterprise database architecture decisions .
• Accountable for completing tasks timely and setting expectations appropriately internally & with stakeholders.
• Formally serve as mentor to Junior teammates

• Strong analytical and SQL skills
• Design process es with maintainability, scalability, and efficiency in mind.
• Experience in scripting complex ETL scripts and database functions
• Extensive hands on experience in developing data integrations and API integrations using Python or another comparable scripting language
• Familiarity using Docker and/or enterprise level containerize toolsets
• Wide-ranging development e xperience with E L T and automated business processes. in c lu ding shell scripting, Informatica Power Center 10.x, SharePoint, A utomate Enterprise , and Python
• Knowledge in Data Warehouse architecture and Business Intelligence principals
• Hands-on experience with several database technologies, preferably both conventional database technologies ( eg. Oracle, SQL Server, mySQL,etc . ) and cloud big data technologies (e.g. Snowflake, Hadoop, Google, etc.)
• Experience in business requirements gathering, data analysis, data profiling , and dimensional data modeling
• Detail oriented and willingness to be a team player
• Demonstrated history of development and deployment processes
• Knowledge or experience with AWS data services a plus

• The salary band for this position range s from 90k - 120k, commensurate with experience and performance .
• This position will be eligible for a competitive year end performance bonus & equity package.
• Full medical, dental, vision package to fit your needs
• Flexible vacation policy; work hard and take time when you need it

• Pet discount plans & retirement plan with company match (401K)
• The rare opportunity to work with sharp, motivated teammates solving some of the most unique challenges and changing the world