Description
You will design and develop ETL/ELT solutions using data warehouse best practices and database modeling methodologies.
Responsibilities
- Design, develop, test, and adapt ETL/ELT code and jobs to accommodate source data changes and new business requirements.
- Manage big data pipelines using Hadoop and Hive.
- Develop automated data audit, validation processes, and error handling with rollback capabilities.
- Execute data administration tasks including job scheduling, troubleshooting, database backups, and performance tuning.
- Create data lineage maps and technical documentation for support team transitions.
Required Skills
- 4+ years of experience in ETL/ELT development.
- Experience with Hadoop and Hive.
- Proficiency in database modeling and data warehouse design.
- Ability to develop automated data audit and validation processes.
- Experience managing job workflows and file processing automation.
- Knowledge of performance tuning and troubleshooting job errors.
- Experience working within HIPAA and healthcare regulatory frameworks.
- Bachelor's degree or equivalent graduate level education.
Preferred Skills
- Experience providing technical leadership in data sourcing platform architecture.