Data Warehouse Developer
Location: Boston, MA
Department: IT Unit
Type: Full Time
Min. Experience: Experienced
Duties:
The mission of the Center for Health Information and Analysis 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.
This position is an opportunity to work with a team on the cutting edge of medical claims analysis and health care reform in Massachusetts. As a Data Warehouse Developer for the Division’s SQL Server and Netezza assets, the individual will be responsible for the day to day administration of Warehouse extracts and Data release provisioning of the agencies large database assets using Microsoft SQL Server 2012, ETL and Netezza development tools. This will include design and monitoring of main database updates, creation of views, data aggregations, release datasets, and ETL graphs. The Data Warehouse Developer will interact closely with DBA and systems staff to develop processes that will simplify and/or automate routine tasks to clean, standardize and enhance data.
Work will involve development and implementation of the All Payer Claims Data (APCD) and Case Mix Warehouse applications. The individual will became a knowledge expert on APCD and claim level based data and will enthusiastically share the knowledge with interested parties.
The deadline to apply is December 17, 2014 with a salary range of $68,000-$80,000 annually.