What are the responsibilities and job description for the ETL Developer position at HouseWorks Home Care?
Visa sponsorship not available for this role
About HouseWorks
Fueled by a real understanding of today's challenges, HouseWorks is committed to a fundamental re-imagining of what it means to age. With over 20 years of operating experience, we have built a replicable service prototype, developed profitable, long-standing referral relationships, and created an innovative brand that positions us to serve the future customer. HouseWorks has grown to be one of the largest single-site private home care companies in the country and is dedicated to improving the health and well-being of its employees and the people it serves. We are embarking on an exciting new growth chapter that focuses on client service excellence, caregiver engagement, technological innovation, and growth in new markets.
The Opportunity
We are a mission-driven organization that is dedicated to improving the lives of seniors as they age. We are passionate about what we doproviding seniors and their families with a comprehensive, vetted and coordinated in-home service network that is high-touch, tech-enabled, compassionate and extremely well managed. We are in the exciting and dynamic home healthcare industry. Our market opportunity is large and growing as the baby boomers age and the home increasingly becomes the epicenter for care as consumers demand convenience and lower-cost solutions.
Job Summary :
We are looking for an ETL Developer with experience working in an Agile / Scrum environment to join our data engineering team. In this role, you will be responsible for designing, developing, and maintaining scalable ETL (Extract, Transform, Load) pipelines using Apache Spark and Python (PySpark) in support our data infrastructure within the AWS ecosystem. You will work closely with data analysts, data scientists, and other stakeholders to ensure that data is available, reliable, and efficiently transformed for analytical and business purposes.
Job Responsibilities :
- Design, develop, and implement ETL workflows, data models and pipelines using PySpark to meet business requirements
- Extract data from multiple sources, transform it for consistency, and load it into data lake / repository.
- Optimize PySpark scripts for performance, scalability, and efficiency, ensuring minimal resource consumption.
- Ensure data accuracy and reliability through quality checks, error handling, and validations within ETL pipelines.
- Monitor, troubleshoot, and enhance ETL pipeline performance.
- Automate ETL processes and integrate with scheduling tools like Apache Airflow, AWS Eventbridge, or similar.
- Manage and optimize data storage, compute resources, and security configurations on cloud platforms (e.g., AWS, Azure, GCP).
- Develop and maintain technical documentation for ETL processes, workflows, and data definitions.
- Participate in code reviews, provide feedback, and collaborate within an agile development environment.
Job Requirements : To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and / or ability required. HouseWorks will consider request for reasonable accommodations to enable individuals with disabilities to perform the essential functions.
Work Environment and Physical Demands :
HWOS1000
HouseWorks is an Equal Opportunity Employer. We do not discriminate against race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, age, disability or genetic information.
