Kaygen - Boston, MA
posted 3 months ago
The Data Operations and Technology unit, within the Center for Health Information and Analysis (CHIA), is seeking a highly skilled Senior ETL Developer with extensive experience in the Talend Data Fabric toolset. This role is crucial for assisting with the development efforts to convert an existing ETL system to the Talend ETL technology. The successful candidate will be responsible for understanding and following all CHIA supplied requirements, asking clarifying questions as needed, and collaborating with CHIA staff to ensure the project progresses from initiation to completion. In this position, the developer will utilize the Talend ETL toolset to create new ETL jobs, design and implement ETL processes for extracting and transforming data from various sources, including Snowflake, PostgreSQL, and SQL Server databases. The role also involves designing and developing necessary database tables along with the required constraints as per project specifications. The developer will work closely with team members to understand source system structures and data retrieval methods, supporting the development of data transformation logic using ETL tools or scripting languages such as SQL, Bash, and Python. Additionally, the developer will be responsible for cleaning, validating, and transforming data to meet target schema and quality standards, executing data quality improvement plans, and participating in troubleshooting activities to maintain data integrity and process efficiency. This position requires a strong understanding of HIPAA policies and the ability to work independently in a hybrid work environment, managing competing priorities effectively while maintaining organized and detailed work habits.