Back to jobs

Data Warehouse Analyst

Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting

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.

The primary work location for this role will be at 1 Enterprise Drive, Quincy MA, 02171.

  • Develop and maintain reports, dashboards and ad-hoc extracts in Tableau Server

  • Perform ETL development and manage data exchange processes within AWS

  • Validate accuracy and completeness of data extracts and reports

  • Recode existing macro-based code, including approved remediation

  • Review technical documents, test plans and test results with end users and EDME staff

From the employer’s posting
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.
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
Validate the accuracy and completeness of data extracts and reports.
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
Education & alternatives
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.
Apply at Massanf

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,020 similar postings that came down. Coming down is not always a hire.

Massanf is hiring

9 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SAS
  • SQL
  • AWS
  • Cognos
  • Snowflake
  • Tableau
Where the posting names them
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.
- 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.
- 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.
- 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.
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.

Your next step

Complete your application on massanf.taleo.net. The employer’s form will show what is required.

Applying through Taleo

  • You sign in or register with the employer’s Taleo careers section before you can apply. Each employer sets its own accepted files and size limit.

Already applied? Track this application

Job description

View original posting ↗

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.

 

 

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.

 

Comprehensive Benefits

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.

Want the specifics? Explore our Employee Benefits and Rewards!

 

 

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.

Tell us about a friend who might be interested in this job. All privacy rights will be protected.

Apply for a Job
Apply for a Job for JAWS Users
Create a Profile
System Requirements

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Massachusetts-Quincy

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:
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.