Data Analyst II - PCS Finance & Analytics - MGH

Site: The General Hospital Corporation

 

Mass General Brigham relies on a wide range of professionals, including doctors, nurses, business people, tech experts, researchers, and systems analysts to advance our mission. As a not-for-profit, we support patient care, research, teaching, and community service, striving to provide exceptional care. We believe that high-performing teams drive groundbreaking medical discoveries and invite all applicants to join us and experience what it means to be part of Mass General Brigham.

 

Full Time 40 hours, hybrid, Monday - Friday

The MGH Patient Care Services (PCS) Finance & Analytics team provides critical analytical, operational, and workforce-planning support for hospital leadership and frontline care teams. Our work enables data-driven staffing decisions, productivity evaluation, financial forecasting, and daily operational management across all inpatient and ambulatory Nursing units.

Filling this vacant Data Analyst II role is essential to maintaining continuity of several high-visibility reporting workflows and datasets that the organization relies on for safe staffing, regulatory reporting, labor budgeting, and performance monitoring. The role will assume ownership of established analytic pipelines and dashboards that run on a variety of backend technologies, including SQL Server, Python, R, VBA, Power Query, and enterprise data sources such as Workday and UKG Dimensions. This position ensures these assets are refreshed, validated, documented, and delivered reliably to operational leaders.

The position requires strong technical proficiency - specifically advanced Excel skills, SQL development and code management experience, and exposure to scripting languages such as Python, R, or VBA. Beyond technical competency, the role must apply critical thinking, attention to detail, and a commitment to data quality to meet the operational standards of PCS and maintain trust with nurse directors, executive leadership, and finance partners.

As a hybrid role with limited on-site requirements and standard business hours, this position offers an excellent opportunity for an analyst to develop deep expertise in healthcare operations while contributing directly to patient care. By joining PCS Finance & Analytics, the selected candidate will help advance MGH’s mission and support one of the top hospital systems in the country.

 

Job Summary

Responsible for extracting knowledge and insights from data in order to investigate business/operational problems through a range of data preparation, modeling, analysis, and/or visualization techniques.

Does this position require Patient Care? No

Essential Functions
-Collects, analyzes, and reports data to support decisions on day-to-day operations, strategic planning, and/or specific business performance issues.
-Collates, models, interprets, and analyzes data.
-Explains variances and trends in data.
-Identifies and documents enhancements to modeling techniques.
-Completes thorough quality assurance procedures, ensuring accuracy, reliability, trustworthiness, and validity of work.
-Performs data validation of source-to-target data for data visuals and dashboards.

 

Qualifications

Education
Bachelor's Degree Analysis required or Bachelor's Degree Related Field of Study required

Can this role accept experience in lieu of a degree?
Yes

Experience
Experience working with data, preferably healthcare or financial data 2-3 years required

Knowledge, Skills and Abilities
- Healthcare knowledge, particularly as it pertains to electronic medical record data, is preferred but not required.
- Working knowledge of relational databases, SQL, Python, data visualization, and Business Intelligence tools such as Tableau or Power BI.
- Knowledge and application of statistical analyses, including variance analysis and statistical significance, are preferred.
- Project management skills and/or experience are a plus.
- Proficiency with Microsoft Office Suite, including Word, Excel and PowerPoint.

 

Additional Job Details (if applicable)

 

Remote Type

Hybrid

 

Work Location

40 Blossom Street

 

Scheduled Weekly Hours

40

 

Employee Type

Regular

 

Work Shift

Day (United States of America)

 

Pay Range

$63,648.00 - $90,750.40/Annual

 

Grade

6

 

At Mass General Brigham, we believe in recognizing and rewarding the unique value each team member brings to our organization. Our approach to determining base pay is comprehensive, and any offer extended will take into account your skills, rel