Data Analyst II

Mass General Brigham•Boston, MA

1d•$63,648 - $90,750•Hybrid

About The Position

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.

Requirements

Bachelor's Degree Analysis required or Bachelor's Degree Related Field of Study required
Experience working with data, preferably healthcare data
2-3 years required
Working knowledge of relational databases, SQL, data visualization, and Business Intelligence tools such as Tableau.
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.
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.
Maintains 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.
Troubleshoots data quality and integrity issues across registry-specific ingestion scripts and downstream datasets.
Prepares analysis-ready datasets for faculty and collaborators, including cohort definition, variable derivation, and quality checks.
Works with PROMIS data to support research projects through statistical analysis, machine learning, and data visualization to help answer clinical and operational questions.
Collaborates with clinical and research teams to translate research questions into clear analysis plans and study designs.
Supports manuscript and publication efforts, including figure and table generation, methods writing, and revisions.
Mentors students, research assistants, and junior team members on data handling, analysis, and reproducible workflows.
Documents code, pipelines, and data sources for long-term use, reproducibility, and onboarding.
Coordinates data access and compliance needs tied to registry participation, including data use agreements and institutional requirements.