Job Overview
We are an esteemed independent state agency committed to delivering a robust foundation for data-driven health care interventions. Our mission is recognized and respected by policymakers, health care leaders, and researchers, as we strive to enhance the quality and equity of care while ensuring affordability for families.
As an ETL Developer within our dedicated team, you will play a pivotal role in transforming health care data into impactful insights. Your contributions will support evidence-based decision-making and promote transparency in the health care system.
Key Responsibilities
- Design and implement ETL processes for the extraction and transformation of data from various sources, including databases and flat files.
- Gain hands-on experience with industry-leading ETL tools such as IBM DataStage and Qlik Talend.
- Create and develop necessary database tables utilizing Snowflake, PostgreSQL, and SQL Server technologies.
- Collaborate with team members to comprehend source system structures and data retrieval methodologies.
- Support the development of data transformation logic using ETL tools or scripting languages like SQL, Bash, and Python.
- Clean, validate, and transform data to align with target schema and quality benchmarks.
- Work alongside the team to implement data quality improvement initiatives.
- Participate in troubleshooting efforts to uphold data integrity and enhance operational efficiency.
Required Skills
- Proficiency in ETL Development within a health data organization.
- Familiarity with ETL tools including IBM DataStage and Qlik Talend.
- Strong experience with Linux and Windows systems.
- Proficiency in Snowflake, PostgreSQL, and SQL Server database technologies.
- Knowledge of programming languages such as SQL and Bash.
- Ability to work independently in a fully remote, hybrid, or in-person setting.
- Understanding of SDLC models and knowledge of HIPAA policies regarding PII and PHI data.
- Proven experience collaborating within a diverse IT team.
- Strong capability to manage competing priorities and work autonomously with minimal supervision.
- Exceptional communication skills, both verbal and written, along with robust documentation abilities.
- Detail-oriented and organized approach to work, especially under pressure to meet deadlines.
- Experience with Microsoft DevOps/Azure is preferred.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
Career Growth Opportunities
Joining our team provides the opportunity to collaborate with experienced colleagues and engage in significant projects that influence health care policy. As a valued team member, you will have access to resources and professional networks that foster your growth and development.
Company Culture And Values
We promote a flexible, inclusive, and collaborative work environment. Our vibrant office in Boston encourages teamwork and innovation, while also supporting remote work options.
Compensation And Benefits
We recognize and appreciate the expertise you bring, which is reflected in our competitive salary range of \(105,000 - \)115,000.
Together, let's make a meaningful impact in health care. We invite you to apply and contribute your expertise to shape the future of health policy.
Employment Type: Full-Time