Data Analyst II

Site:
The General Hospital Corporation

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.

• 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 in Analysis or a related field required.

Experience:

2-3 years working with data, preferably healthcare data.

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

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

Remote Type Hybrid

Work Location 32 Fruit Street

Scheduled Weekly Hours 40

Employee Type Regular

Work Shift Day (United States of America)

Pay Range $63,648.00 – $90,750.40/Annual

Grade 6

1200 The General Hospital Corporation is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.

To ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Veteran’s Readjustment Act of 1974, and Title I of the Americans with Disabilities Act of 1990, applicants who require accommodation in the job application process may contact Human Resources at .