Data Analyst II

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.

 

Job Summary

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.

 

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

Licenses and Credentials

Experience
Experience working with data, preferably healthcare 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, data visualization, and Business Intelligence tools such as Tableau.
- 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.

 

The Department of Orthopaedic Surgery at Massachusetts General Hospital (MGH), a Harvard teaching hospital, is seeking a mid-level Clinical Data Analyst II to join its orthopaedic research data team. This role is central to the department's participation in the American Academy of Orthopaedic Surgeons (AAOS) data registries and supports a broad portfolio of clinical and operational research projects.

This is a technical, research-facing position that combines data engineering, statistical analysis, and scientific collaboration. The successful candidate will work at the intersection of clinical research and applied data science, directly supporting surgeon-investigators, research staff, and trainees on projects that translate registry data into evidence for clinical and operational decision-making.

The role offers the opportunity to contribute to peer-reviewed publications, work with large-scale national registry data, and develop and maintain reusable infrastructure that supports the long-term research mission of the department.

Responsibilities and daily activities include:

• Maintaining the AAOS data registries — including AJRR, ASR, SER, and FTR — by building and updating data pipelines in Python and SQL (Snowflake) that pull, clean, and organize registry data.
• Troubleshooting data quality and integrity issues across registry-specific ingestion scripts and downstream datasets.
• Preparing analysis-ready datasets for faculty and collaborators, including cohort definition, variable derivation, and quality checks.
• Working with PROMIS data to support research projects through statistical analysis, machine learning, and data visualization to help answer clinical and operational questions.
• Collaborating with clinical and research teams to translate research questions into clear analysis plans and study designs.
• Supporting manuscript and publication efforts, including figure and table generation, methods writing, and revisions.
• Mentoring students, research assistants, and junior team members on data handling, analysis, and reproducible workflows.
• Documenting code, pipelines, and data sources for long-term use, reproducibility, and onboarding.
• Coordinating data access and compliance needs tied to registry participation, including data use agreements and institutional r