Sr. ETL Developer contracted

$187,200 - $208,000/Yr

CHIA - Boston, MA

Full-time - Senior

Remote - Boston, MA

Executive, Legislative, and Other General Government Support

About the position

The Sr. ETL Developer at the Center for Health Information and Analysis (CHIA) is responsible for designing and developing ETL systems to manage and analyze health data. This role involves creating new ETL processes, maintaining existing systems, and ensuring data integrity and quality. The developer will work with various database technologies and scripting languages, collaborating with stakeholders to deliver high-quality solutions that support evidence-based decision-making in health care.

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.
• Mentor and lead junior developers.
• Collaborate with major stakeholders in the organization to understand project requirements and design/deliver high quality solutions.
• 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.
• Lead 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.

Requirements

• Bachelor's degree in computer science, information technology, or a related field.
• 10+ years experience working for an organization performing ETL Development activities with large volumes of data, including PII/PHI data.
• Expertise with ETL tools such as IBM DataStage or Qlik Talend with more than 10 years experience using these tools in a senior design and architect role.
• Experience with Linux and Windows systems.
• 10+ years experience with Snowflake, PostGreSQL, and SQL Server database technologies.
• 10+ years experience working in cloud computing environments such as Microsoft DevOps / Azure.
• Ability to work independently in a fully remote, hybrid, or in-person work environment.
• Demonstrated knowledge of SDLC models.
• 10+ years experience understanding 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.

Benefits

• Hourly rate range $90.00 - $100.00 per hour.