Clinical Data Analyst
Mass General BrighamAbout the role
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.
Key Responsibilities:
- Query and extract clinical data from Epic Clarity and enterprise data warehouses (primarily Snowflake) to support approved research projects.
- Translate clinical questions into precise data requirements and SQL logic; design reusable views, UDFs, and stored procedures.
- Build and maintain ELT/ETL pipelines (e.g., Airflow or equivalent) to create curated data marts (encounters, diagnoses, procedures, labs, meds, orders, vitals, EEG/telemetry linkages, imaging metadata).
- Perform rigorous QA/validation, reconciliation, and documentation of data lineage and definitions.
- Optimize SQL for performance and cost (e.g., Snowflake warehouses, clustering, time travel, tasks/streams).
- Collaborate with clinicians, research staff, and data scientists to ensure datasets are complete, accurate, and analysis-ready.
- Handle PHI responsibly; comply with IRB, HIPAA, and institutional data governance.
- Create basic exploratory summaries and dashboards (Tableau/Power BI or Python/pandas) to verify data quality and usability.
Preferred Skills (Not Required, but a Plus):
- Familiarity with HIPAA/IRB processes and secure handling of PHI.
- Working knowledge of the Epic Clarity data model (patient/encounter, diagnoses, procedures, orders, labs, medications, etc.).
- Experience with cloud data platforms - Azure strongly preferred (e.g., Azure Data Factory, Synapse, Databricks, Azure SQL, ADLS Gen2, Key Vault; AWS/GCP a plus).
- Knowledge of clinical terminologies (ICD-10, RxNorm) and cohort/phenotype definitions.
- Knowledge of clinical NLP.
- Minimum 1-year experience working with clinical/EHR data.
- Familiarity with de-identification workflows and privacy-preserving analytics.
Job Summary
SummaryResponsible for extracting knowledge, trends, 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
-Writes and runs basic queries as needed.
-Assists in maintaining existing reporting systems.
-Contributes to presentations to key stakeholders.
-Works with senior analysts to design, maintain and distribute reports.
-Learn leading practice analysis methodologies.
-Compare results to forecast and identify opportunities for improvement.
-Perform continual analysis of current performance and be able to forecast data trends.
Qualifications
Education
Bachelor's Degree Analytics 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
Data Analysis Experience 0-1 year preferred
Knowledge, Skills and Abilities
- Building proficiency in statistics, data analysis, and data sets.
- Proficient time management and project management skills.
- Ability to exercise sound judgments to make decisions within scope of job responsibilities.
- Demonstrated knowledge of and skill in word processing, spreadsheet, and database PC applications.
- Solid quantitative, analytical and technical aptitude skills.
- Participate in dealing with all levels of employees /management and building proficient relationships with teams and all organizational customers.
- Able to find and define problems, understand business impact, identify solutions and provide recommendations for corrective action.
Additional Job Details (if applicable)
Remote Type
Hybrid
Work Location
101 Merrimac Street
Scheduled Weekly Hours
40
Employee Type
Regular
<
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s