Job Overview
We are committed to laying a factual groundwork for data-driven healthcare interventions. As an independent state agency, our initiatives are trusted by policymakers, healthcare leaders, and researchers who aim to enhance the quality and equity of care while managing costs for families.
In this role, you will be an integral part of our ETL Development team, responsible for transforming healthcare data into actionable insights through comprehensive data management and analytics.
Key Responsibilities
- Design and implement ETL processes for extracting, transforming, and loading data from diverse sources, such as databases and flat files.
- Gain practical experience with leading ETL tools, including IBM DataStage and Qlik Talend.
- Develop and design essential database tables using 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 utilizing ETL tools or scripting languages such as SQL, Bash, and Python.
- Cleanse, validate, and transform data to adhere to target schema and quality standards.
- Collaborate with the team to execute data quality improvement initiatives.
- Engage in troubleshooting activities to uphold data integrity and optimize process efficiency.
Required Skills
- Proficient in ETL development within a healthcare data organization.
- Familiarity with ETL tools like IBM DataStage and Qlik Talend.
- Skilled in Snowflake, PostgreSQL, and SQL Server database technologies.
- Knowledge of programming languages including SQL and Bash.
- Experience with Linux and Windows systems.
- Strong ability to manage competing priorities and work independently.
- Excellent verbal and written communication skills, along with robust documentation capabilities.
- A detail-oriented and organized approach to tasks, particularly under pressure to meet deadlines.
- Familiarity with Microsoft DevOps/Azure is advantageous.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience in ETL development within a healthcare organization.
- Understanding of SDLC models and knowledge of HIPAA regulations concerning PII and PHI data.
- Demonstrated success in collaboration within a diverse IT team.
Career Growth Opportunities
By joining our team, you will have the chance to make a significant impact in healthcare while enhancing your skills and advancing your career. Our environment encourages professional development and continuous learning.
Company Culture And Values
We promote a flexible and collaborative culture that balances in-person and remote work. You will have the opportunity to engage with colleagues in our vibrant Boston office at least two designated days each week, while retaining the flexibility to work remotely on other days.
Compensation And Benefits
We recognize and appreciate the expertise you bring to our organization, which is reflected in our competitive salary range of \(105,000 - \)115,000 for this position.
Join us in making a meaningful impact in healthcare. Your expertise will help shape the future of health policy, and you will have access to an outstanding suite of employee benefits designed to support you and your future.
Employment Type: Full-Time