Verified Job On Employer Career Site

Job Summary:

The Center for Health Information and Analysis (CHIA) is an independent state agency that provides data-driven insights for health care interventions. They are seeking a skilled ETL Developer to design and maintain ETL systems, code data preparation and reporting jobs, and support data quality improvement efforts.

Responsibilities:

• Design and implement ETL for extracting and transforming data from diverse sources, including databases and flat files.

• Learn and work with Gartner Magic Quadrant leading ETL tools; IBM DataStage and Qlik Talend

• Design and develop required database tables using Snowflake, PostGreSQL, and SQL Server database technologies.

• Collaborate with Team members to understand source system structures and data retrieval methods/techniques, and tools within the organization.

• Support the development of data transformation logic using ETL tools or scripting languages like SQL, Bash, Python, etc.

• Clean, validate, and transform data to conform to target schema and quality standards.

• Work with the team to execute data quality improvement plans.

• Participate in troubleshooting activities to maintain data integrity and process efficiency.

Qualifications:

Required:

• Bachelor’s degree in computer science, information technology, or a related field.

• Experience working for a health data organization performing ETL Development activities.

• Experience with ETL tools such as IBM DataStage or Qlik Talend.

• Experience with Linux and Windows systems.

• Experience with Snowflake, PostGreSQL, and SQL Server database technologies.

• Experience with languages such as SQL and Bash.

• Ability to work independently in a fully remote, hybrid, or in-person work environment.

• Demonstrated knowledge of SDLC models.

• Working knowledge and understanding of HIPAA policies and working with PII and PHI sensitive data.

• Demonstrated success working collaboratively on an IT team with diverse skillsets.

• Effective at managing competing priorities and can work independently with minimal supervision.

• Excellent communication skills: verbal and written, along with excellent documentation skills.

• Ability to stay well organized, detailed and process oriented when under pressure to meet development deadlines.

• Applicants must have at least (A) one (1) year of full-time or equivalent part-time, professional, or practical experience in information technology applications development or (B) any equivalent combination of the required experience and the substitutions below.

• An Associate's degree or higher in a related field may be substituted for the required experience.

Preferred:

• Experience with Microsoft DevOps / Azure preferred.

Company:

The Center for Health Information and Analysis (CHIA) is an independent state agency established as the Commonwealth’s primary hub for health care data. Founded in , the company is headquartered in Boston, Massachusetts, US, with a team of 51-200 employees. The company is currently Growth Stage.