State of Massachusetts Data Warehouse Developer in Quincy, Massachusetts

The mission of MassHealth is to improve the health outcomes of our diverse members, their families and their communities by providing access to integrated health care services that sustainably promote health, well-being, independence and quality of life.

The Executive Office of Health and Human Services (EOHHS) is seeking an experienced Data Warehouse Developer to join MassHealth’s data warehouse payment reform and data quality team. MassHealth data warehouse stores claims, provider, member, eligibility, enrollment and other data from different sources including data received from Managed Care Organizations known as “Encounter” data. In order to support the Medicaid Accountable Care Organization implementation in Massachusetts a team is being developed to analyze the current Encounter data process and perform quality remediation. Strategic planning around automated resolutions will be developed and maintained by this team. The developer position requires extensive knowledge of SQL and PL/SQL, data warehouse architecture and methodologies, business intelligence (BI) tools, health care and government data and processes.

The developer for implementing code based solutions as determined by the team’s project manager and analysts. The developer is responsible for unit testing their code, checking in code on a daily basis and maintaining their code as needed. The developer will work with a team of programmers who share key concepts and knowledge in order to create a unique and exciting work environment. The developer will work closely with the project team and business in order to determine best practices and solutions for current data quality issues and to plan for future strategic goals implementation. The developer will be responsible for providing documentation as needed based on EOHHS standards and working with the current defect tracking tool, JIRA.

The developer will work on a team of contractors and full time employees. The developer will report directly to the Operations lead.

Duties and Responsibilities (these duties are a general summary and not all inclusive):**

  • Understand and translate business requirements into Data Warehouse solutions.

  • Create data models and designs to meet specific business needs that require sourcing data from multiple source systems.

  • Code Oracle ETL scripts that will extract data from an operational database and populate the staging and target data warehouse schemas.

  • Document code and processes for distribution to all interested parties.

  • Document design using industry standard artifacts for documenting data warehouse designs.

  • Provide query writing support and tuning expertise to analysts and end users.

  • Develop shell scripts for production job automation.

  • Work in a 24x7 environment which requires on-call rotation.

Preferred Qualifications:

  • 3-5 years of experience in database development including analyzing, designing, documenting, coding, testing and implementing SQL, PL/SQL code.

  • Thorough knowledge of data warehouse principles and techniques, specifically dimensional data modeling.

  • Exceptional Oracle SQL skills and PL/SQL skills.

  • Hands on experience with set based operations, analytic functions and query hints.

  • Command of data warehouse modeling concepts is required.

  • Strong problem solving and analytical skills.

  • Proficiency with Linux and shell scripting.

  • Experience working with a large, multi-terabyte data warehouse.

  • Experience with Perl, system administration, database administration, storage architectures, backup & recovery and networking.

  • Technophile with command of the command line.

  • BS in Computer Science or related degree, or equivalent experience.

  • Medicaid or other healthcare or claims processing experience.

  • Informatica ETL experience.

  • Cognos 10.3 reporting experience.

*Special Requirements*:

Based on assignment, possession of a current and valid Massachusetts Class D Motor Vehicle Operator’s license or the equivalent from another state may be required.

*Pre-Hire Process*:

A criminal background check will be completed on the recommended candidate as required by the regulations set forth by the Executive Office of Health and Human Services prior to the candidate being hired. For more information, please visit http://www.mass.gov/hhs/cori.

  • Education, licensure and certifications will be verified in accordance with the Human Resources Division’s Hiring Guidelines

Education and license/certification information provided by the selected candidate(s) is subject to the Massachusetts Public Records Law and may be published on the Commonwealth’s website.

For questions, please contact the CYF Office of Human Resources at 1-800-510-4122 and select option #2.

This requisition will remain open until filled; however, first consideration will be given to those applicants that apply within the first 14 days.

Please see Preferred Qualifications.

*An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.


Job: *Information Systems and Technology

Organization: *Exec Office Of Health and Human Services

Title: Data Warehouse Developer

Location: Massachusetts-Quincy - 100 Hancock Street

Requisition ID: 160006T6