Data Analyst II - PCS Finance & Analytics - MGH

Brigham and Women's Hospital•Boston, MA

35d•Hybrid

About The Position

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.

Requirements

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 working with data, preferably healthcare or financial data 2-3 years required
Proficiency with Microsoft Office Suite, including Word, Excel and PowerPoint.

Nice To Haves

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.

Responsibilities

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume