The mission of the Center for Health Information and Analysis (CHIA) is to monitor the Massachusetts health care system and to provide reliable information and meaningful analysis for those seeking to improve health care quality, affordability, access, and outcomes. CHIA also acts as a principal repository for health care data collected by the state and is responsible for the Massachusetts All Payer Claims Database (APCD) and Acute Hospital Case Mix Database.
We are looking to hire a skilled Extract, Transform, and Load (ETL) developer to work with the Master Data Management (MDM) and ETL Design team to create new and maintain existing ETL systems. The developers’ duties will include developing data preparation, analysis, and reporting jobs, performing technical troubleshooting, and providing technical expertise for ETL systems. The developer will work with multiple database technologies, and scripting languages.
The ETL Developer is a key member of CHIA’s software Development organization and our Data Operations and Technology team reporting to the Associate Director of Master Data Management and ETL Design.
CHIA has a hybrid work environment, all employees are expected to work in-person at the Center’s 501 Boylston Street office, on at least two (2) designated days each week.
Specifically, the Developer will:

• Design, implement, and continuously maintain and enhance flexible, enterprise-scale ETL and MDM systems
• Work closely with others within the MDM/ETL team as well as with data architects, data modelers, DBAs, business and data analysts, software quality assurance testers, and data quality testers throughout the software development life cycle
• Provide critical thinking, problem solving, and attention to detail and quality on all projects
• Create and maintain documentation for MDM/ETL systems including, but not limited to system design; support and maintenance procedures; production runbooks
• Investigate data anomalies to identify potential issues within ETL systems, notify stakeholders and propose adequate solutions
• Always remain committed to ensuring the privacy, security, quality, and integrity of the data

Preferred Qualifications at Hire:

• Bachelor’s degree in computer science, information technology, or a related field.
• Five years’ experience working for a health data organization performing ETL Development activities.
• Has worked with an ETL tool such as IBM DataStage, SSIS/Azure Data Factory/Synapse, Informatica, etc...
• Experience with Linux and Windows systems
• Experience with SQLServer and PostGreSQL 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.
• Commitment to complying with data security requirements and ability to assist in identifying potential data security risks.
• Effective at managing competing priorities and can work independently with little or no 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.
• Experience with Microsoft DevOps / Azure preferred.

Total Compensation:
As an employee of the Commonwealth of Massachusetts you are offered a great career opportunity influencing a wide-spectrum of services to the diverse populations we serve - but it's more than a paycheck. The State's total compensation package features an outstanding set of employee benefits which you should consider towards your overall compensation, including:

• 75% state paid medical insurance premium
• Reasonable Dental and Vision Plans
• Flexible Spending Account and Dependent Care Assistance programs
• Low cost basic and optional life insurance
• Retirement Savings: State Employees' Pension and a Deferred Compensation 457(b) plan
• 12 paid holidays per year and competitive Sick, Vacation and Personal Time
• Tuition Benefit for employee and spouse at state colleges and universities
• Extended Illness program participation
• Professional Development and Continuing Education opportunities
• Qualified Employer for Public Service Student Loan Forgiveness Program

To apply visit: http://www.chiamass.gov/join-our-team/
This TPLB position will remain open until filled. The anticipated full time salary range for this position is $74,658.74 to $107,692.78 commensurate with experience.

At CHIA, we are committed to earning a reputation as a great place to work and build a career. So if you’re excited to be part of a diverse and innovative team responsible for identifying opportunities to improve health care in Massachusetts, come join us! To apply and for more information visit: https://www.chiamass.gov/join-our-team/
CHIA is an Equal Opportunity / Affirmative Action Employer. Women, people of color, veterans, and persons with disabilities are strongly encouraged to apply.
If you have Diversity, Affirmative Action or Equal Employment Opportunity questions or need a Reasonable Accommodation, please contact Diversity Officer / ADA Coordinator: Tonya Bourassa 617-701-8127.
Information submitted by applicants is collected through the JazzHR Platform, your submission of application materials constitutes your express consent for this information to be provided to JazzHR for processing. Please do not include any personally identifiable information with your application materials other than that specifically requested by CHIA. CHIA requests basic information such as name, address, telephone number, and email address. You may also self identify race/ethnicity, gender, disability and/or veteran status if you so choose. However, you should not provide more detailed personal information such as your date of birth or Social Security Number with your application materials.
In compliance with federal laws, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.
CHIA has adopted Executive Order #595: COVID-19 Vaccination Requirement for Executive Department Employees
As a condition of employment, successful candidates will be required to have received COVID-19 vaccination and/or boosters prior to the finalization of the hiring process. Details relating to complying with this requirement will be provided to finalists.
Finalists who can provide documentation that the vaccine is medically contraindicated or who object to vaccination due to a sincerely held religious belief may make a request for a reasonable accommodation.
Executive order can be found here: https://www.mass.gov/doc/august-19-2021-executive-department-employee-vaccination-order

uFBACvay8A

Job Type: Full-time

Pay: $74,658.74 - $107,692.78 per year

Please Note :
apexdining.ca is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, apexdining.ca provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.