Data Analyst II - PCS Finance & Analytics - MGH
Mass General Brigham
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.
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
Work Location
Scheduled Weekly Hours
Employee Type
Work Shift
Pay Range
$62,400.00 - $90,750.40/Annual
Grade
6
EEO Statement:
Mass General Brigham Competency Framework
At Mass General Brigham, our competency framework defines what effective leadership “looks like” by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused, half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance, make hiring decisions, identify development needs, mobilize employees across our system, and establish a strong talent pipeline.