Data Warehouse Analyst

The Executive Office of Health and Human Services (EOHHS) oversee expenditures of over $28 billion annually. As the largest secretariat, has approximately 22,000 employees and services almost 2 million people, one in three residents of the Commonwealth. The mission of EOHHS is to provide effective leadership and management in the development and provision of health and human services that promote health and safety, independence, and quality of life for individuals and families, and communities throughout the Commonwealth of Massachusetts. To know more about EOHHS, please visit: Executive Office of Health and Human Services

About the Team:

The MassHealth Enterprise Data Management and Engineer Team (EDME) support MassHealth organizational data exchange, storage, transformation, access, query, technology, and reporting needs. The EDME teams include Business Analytics, Operations, Data Quality, Data Informatics, Federal Reporting, Business Intelligence, and Project Management Office. In addition to maintaining data applications, services, technologies, and infrastructure; the EDME partners with the Data Integrity, Data Strategy, and MassHealth Analytics teams to manage new and existing project portfolio requests received from MassHealth business teams through a formalized Intake, Governance, and Prioritization process.

About the Role:

The Data Warehouse Analyst will support existing warehouse analytics and provide input on best practices and potential efficiencies, work on multiple assignments concurrently to meet aggressive due dates, uses a range of expert technical skills based on a keen knowledge of data warehouse concepts, and must be highly proficient with Snowflake SQL. This resource needs to have extensive experience querying tables and views to develop, enhance, and update new and existing reports. The Data Warehouse Analyst will also be responsible for the development of data visualizations using contemporary business intelligence (BI) tools like Tableau, Cognos, Snowflake, and/or SAS.

The primary work location for this role will be at 1 Enterprise Drive, Quincy MA, 02171. The work schedule for this position is Monday through Friday, 9:00AM-5:00PM EST. This position is expected to follow a hybrid work model that combines in-office and remote work as needed.

Duties and Responsibilities:

• Develop and maintain reports, data visualizations, and ad-hoc data extracts using Tableau Server.

• Perform ETL development and manage data exchange processes within AWS platforms, including identifying process gaps and recommending improvements.

• Validate the accuracy and completeness of data extracts and reports.

• Interact on a professional basis with internal and external staff in a personable manner

• Develop reports for general, financial, clinical and case management, Managed Care, and Health Care and payment Reform purpose as requested.

• Support on-going development of cost, utilization and other reporting metrics, including collaboration with business program managers for MCO, HIX, and MMIS source data

• Communicate business requirements to Cognos and Snowflake developers and work with them to implement solutions for the business community.

• Communicate progress, or impediments to progress, to users and managers.

• Recode existing macro-based code, including remediation as approved

• Review technical documents and test plans, test results and coordinate implementation activities with end-users and EDME staff

• Organize and manage workload independently with minimal supervision while contributing to team projects and meetings.

• Analyze data extract processes, identify gaps, recommend improvements, and validate the accuracy of reports and data extracts.

Preferred Experience, Knowledge and Skills:

• Two (2) to five (5) years of experience supporting and maintaining data warehouse environments.
• Demonstrated proficiency in SQL and experience with data analysis tools such as Snowflake, SAS, and Tableau.
• Ability to gather and evaluate business requirements, manage requests from diverse business users, and develop effective solutions.
• Experience producing standard and ad-hoc reports, performing advanced data mining, and generating accurate queries and outputs under tight deadlines.
• Ability to understand business requirements and regulatory needs and assess their impact on business operations and EDME.
• Experience maintaining comprehensive code documentation and developing business and system documentation in accordance with EOHHS standards and policies.
• Strong initiative and problem-solving skills, with the ability to independently research issues, identify solutions, and improve processes.
• Ability to quickly learn new technologies, tools, systems, data sources, and business processes with minimal guidance.
• Ability to manage competing priorities, adapt to changing demands, and meet deadlines in a fast-paced environment.

Pre-Offer 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.

ADA Reasonable Accommodation: If you require a reasonable accommodation with the application/interview process, please contact us at: EOHHS Candidate ADA Requests

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

The Executive Office of Health and Human Services (EOHHS) oversee expenditures of over $28 billion annually. As the largest secretariat, has approximately 22,000 employees and services almost 2 million people, one in three residents of the Commonwealth. The mission of EOHHS is to provide effective leadership and management in the development and provision of health and human services that promote health and safety, independence, and quality of life for individuals and families, and communities throughout the Commonwealth of Massachusetts. To know more about EOHHS, please visit: Executive Office of Health and Human Services

About the Team:

The MassHealth Enterprise Data Management and Engineer Team (EDME) support MassHealth organizational data exchange, storage, transformation, access, query, technology, and reporting needs. The EDME teams include Business Analytics, Operations, Data Quality, Data Informatics, Federal Reporting, Business Intelligence, and Project Management Office. In addition to maintaining data applications, services, technologies, and infrastructure; the EDME partners with the Data Integrity, Data Strategy, and MassHealth Analytics teams to manage new and existing project portfolio requests received from MassHealth business teams through a formalized Intake, Governance, and Prioritization process.

About the Role:

The Data Warehouse Analyst will support existing warehouse analytics and provide input on best practices and potential efficiencies, work on multiple assignments concurrently to meet aggressive due dates, uses a range of expert technical skills based on a keen knowledge of data warehouse concepts, and must be highly proficient with Snowflake SQL. This resource needs to have extensive experience querying tables and views to develop, enhance, and update new and existing reports. The Data Warehouse Analyst will also be responsible for the development of data visualizations using contemporary business intelligence (BI) tools like Tableau, Cognos, Snowflake, and/or SAS.

The primary work location for this role will be at 1 Enterprise Drive, Quincy MA, 02171. The work schedule for this position is Monday through Friday, 9:00AM-5:00PM EST. This position is expected to follow a hybrid work model that combines in-office and remote work as needed.

Duties and Responsibilities:

• Develop and maintain reports, data visualizations, and ad-hoc data extracts using Tableau Server.

• Perform ETL development and manage data exchange processes within AWS platforms, including identifying process gaps and recommending improvements.

• Validate the accuracy and completeness of data extracts and reports.

• Interact on a professional basis with internal and external staff in a personable manner

• Develop reports for general, financial, clinical and case management, Managed Care, and Health Care and payment Reform purpose as requested.

• Support on-going development of cost, utilization and other reporting metrics, including collaboration with business program managers for MCO, HIX, and MMIS source data

• Communicate business requirements to Cognos and Snowflake developers and work with them to implement solutions for the business community.

• Communicate progress, or impediments to progress, to users and managers.

• Recode existing macro-based code, including remediation as approved

• Review technical documents and test plans, test results and coordinate implementation activities with end-users and EDME staff

• Organize and manage workload independently with minimal supervision while contributing to team projects and meetings.

• Analyze data extract processes, identify gaps, recommend improvements, and validate the accuracy of reports and data extracts.

Preferred Experience, Knowledge and Skills:

• Two (2) to five (5) years of experience supporting and maintaining data warehouse environments.
• Demonstrated proficiency in SQL and experience with data analysis tools such as Snowflake, SAS, and Tableau.
• Ability to gather and evaluate business requirements, manage requests from diverse business users, and develop effective solutions.
• Experience producing standard and ad-hoc reports, performing advanced data mining, and generating accurate queries and outputs under tight deadlines.
• Ability to understand business requirements and regulatory needs and assess their impact on business operations and EDME.
• Experience maintaining comprehensive code documentation and developing business and system documentation in accordance with EOHHS standards and policies.
• Strong initiative and problem-solving skills, with the ability to independently research issues, identify solutions, and improve processes.
• Ability to quickly learn new technologies, tools, systems, data sources, and business processes with minimal guidance.
• Ability to manage competing priorities, adapt to changing demands, and meet deadlines in a fast-paced environment.

Pre-Offer 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.