Data Warehouse Analyst

Commonwealth of Massachusetts•Quincy, MA

4d•Hybrid

About The Position

The Data Warehouse Analyst supports existing warehouse analytics and provides input on best practices and potential efficiencies. The role works on multiple assignments concurrently to meet aggressive due dates, applies expert technical skills grounded in data warehouse concepts, and requires high proficiency with Snowflake SQL. The analyst queries tables and views to develop, enhance, and update reports, and develops data visualizations using business intelligence tools such as Tableau, Cognos, Snowflake, and/or SAS. The position is part of the MassHealth Enterprise Data Management and Engineer Team (EDME), which supports organizational data exchange, storage, transformation, access, query, technology, and reporting needs. The role’s primary work location is 1 Enterprise Drive, Quincy, Massachusetts, with a Monday-through-Friday schedule from 9:00 AM to 5:00 PM EST. The position follows a hybrid work model combining in-office and remote work as needed.

Requirements

At least two years of full-time or equivalent part-time professional or practical experience in information technology application development and support, or an equivalent combination of experience and qualifying education.
High proficiency in Snowflake SQL and demonstrated proficiency in SQL.
Experience querying tables and views to develop, enhance, and update reports.
Ability to work on multiple assignments concurrently and meet aggressive due dates.
Ability to gather and evaluate business requirements, manage requests from diverse business users, and develop effective solutions.
Ability to understand business requirements and regulatory needs and assess their impact on business operations and EDME.
Ability to maintain comprehensive code documentation and develop business and system documentation in accordance with EOHHS standards and policies.
Strong initiative and problem-solving skills, including the ability to research issues independently, identify solutions, and improve processes.
Ability to quickly learn 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.
An associate degree in a related field may substitute for one year of required experience; a bachelor's degree or higher in a related field may substitute for the required experience.

Nice To Haves

Two to five years of experience supporting and maintaining data warehouse environments.
Experience with data analysis tools such as Snowflake, SAS, and Tableau.
Experience producing standard and ad-hoc reports, performing advanced data mining, and generating accurate queries and outputs under tight deadlines.

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, identifying process gaps and recommending improvements.
Validate the accuracy and completeness of data extracts and reports.
Interact professionally and personably with internal and external staff.
Develop reports for general, financial, clinical and case management, Managed Care, and Health Care and payment Reform purposes as requested.
Support ongoing development of cost, utilization, and other reporting metrics, collaborating with business program managers on 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 and impediments to users and managers.
Recode existing macro-based code, including remediation as approved.
Review technical documents, test plans, and 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.