Data Warehouse Analyst

Commonwealth of Massachusetts; Quincy (MA); Hybrid; USD 84,000 - 126,000; Full time

Job summary

Mass is seeking a Data Warehouse Analyst II in Quincy, MA, to support MassHealth analytics, develop visualizations, and optimize ETL processes. The role emphasizes Snowflake SQL proficiency, reporting, and collaboration with BI teams in a hybrid in-office/remote schedule.

The ideal candidate has 2–5 years of data warehouse experience, strong SQL skills, and experience with Tableau, Cognos, and SAS. This position offers a day shift in a hybrid work setting.

Qualifications

• 2–5 years of experience in data warehouse analytics and support.
• Proficiency in SQL and experience with data analysis tools such as Snowflake, SAS, and Tableau.
• Ability to gather and evaluate business requirements and translate them into technical solutions.
• Experience producing standard and ad-hoc reports under tight deadlines.
• Knowledge of regulatory requirements and impact on operations.

Responsibilities

• Develop and maintain reports, data visualizations, and ad-hoc extracts using Tableau Server.
• Perform ETL development and manage data exchange processes within AWS platforms.
• Validate accuracy and completeness of data extracts and reports.
• Interact professionally with internal and external staff and stakeholders.
• Communicate requirements to Cognos and Snowflake developers and ensure delivery.

Skills

SQL

Snowflake

Tableau

SAS

Data analysis

Requirements gathering

Regulatory awareness

Education

Bachelor's degree

Tools

Tableau Server

Cognos

Snowflake

Job description

An Official website of the Commonwealth of Massachusetts

Job Description - Data Warehouse Analyst (260006UI)

Job Description

Data Warehouse Analyst - ( 260006UI )

Description

The Executive Office of Health and Human Services (EOHHS) oversee expenditures ofover $28 billion annually. As the largest secretariat, has approximately 22,000 employeesand 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.

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

Qualifications

First consideration will be given to those applicants that apply within the first 14 days.

Minimum Entrance Requirements:

Applicants must have (A) at least two (2) years of full-time or equivalent part-time professional or practical experience in the field of information technology application development and support, or (B) any equivalent combination of the required experience and the substitutions below.

Substitutions:

I. An Associate’s degree in a related field may substitute for one (1) year of the required experience.

II. A Bachelor’s degree or higher in a related field may substitute for the required experience.

Salary placement is determined by a combination of factors, including the candidate’s years of directly related experience and education, and alignment with our internal compensation structure as set forth by the Human Resources Division’s Hiring Guidelines. For all bargaining unit positions (non-management), compensation is subject to the salary provisions outlined in the applicable collective bargaining agreement and will apply to placement within the appropriate salary range.

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.

An Equal Opportunity / affirmative action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.

The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law. Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC)may self-select out of opportunities if they don't meet 100% of the job requirements. We encourage individuals who believe they have the skills necessary to thrive to apply for this role.

Official Title : Data Warehouse Analyst II

Primary Location

United States-Massachusetts-Quincy - 1 Enterprise Dr

Job

Information Systems and Technology

Agency

Exec Office Of Health and Human Services

Schedule

Full-time

Shift

Day

Number of Openings

1

Salary

84,407.18 - 125,924.24 Yearly

If you have Diversity, Affidantialy Action or Equal Employment Opportunity questions or need a Reasonable Accommodation, please contact Diversity Officer / ADA Coordinator : Sandra Semedo ([e-mail]) - 6173524250

Bargaining Unit : 06-NAGE - Professional Admin.

Confidential : No

Potentially Eligible for a Hybrid Work Schedule : Yes