Data Analyst II

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 requirements.

Applicants are selected based on technical skill, research experience, and enthusiasm for clinical data work. Strong organizational, communication, and documentation skills are essential given the collaborative nature of the position.