Clinical Data Analyst
Mass General Brigham
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
Work Location
Scheduled Weekly Hours
Employee Type
Work Shift
Pay Range
$52,000.00 - $74,401.60/Annual
Grade
5
EEO Statement:
Mass General Brigham Competency Framework
At Mass General Brigham, our competency framework defines what effective leadership “looks like” by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused, half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance, make hiring decisions, identify development needs, mobilize employees across our system, and establish a strong talent pipeline.