Open to opportunities

Yijia Sun

@yijiasun

Message

Research data analyst delivering decision-ready healthcare insights and dashboards for stakeholders.

United States

Message

What I'm looking for

I’m seeking to leverage my analytical expertise in a healthcare analytics role—delivering decision-ready insights, building interactive dashboards, and converting stakeholder questions into reproducible logic that supports better clinical and medication-safety outcomes.

I’m a Research Data Analyst delivering decision-ready insights for healthcare and pharmaceutical stakeholders. In my current role, I analyze large-scale healthcare claims and real-world data for over 10 million patients, translating clinical outcomes, treatment pathways, medication utilization, safety events, and recovery patterns into strategy-ready evidence.

I build and maintain interactive Power BI and Tableau dashboards (and Looker-ready visualizations) that help senior leadership monitor utilization trends and make informed decisions. I also develop medical coding codebooks across ICD-10-CM, ICD-10-PCS, CPT, HCPCS, NDC, LOINC, SNOMED, and modifiers to support cohort definition, claims variable validation, and data quality improvements—and I lead production of abstracts, manuscripts, posters, and final reports to deliver accurate interpretations and secure client approval.

Experience

Work history, roles, and key accomplishments

Current

Research Data Analyst

Current

Columbia Dataanalytics

Feb 2025 - Present (1 year 4 months)

Analyzed healthcare claims and real-world data for 10M+ patients using SQL, Python, PySpark, and Databricks to deliver decision-ready insights on clinical outcomes, treatment pathways, and medication safety. Built and maintained Power BI/Tableau/Looker-ready dashboards and produced client-facing deliverables, including 10 medical coding codebooks and conference-ready posters/manuscripts.

SQL Python Pyspark Databricks Healthcare Claims Analysis Power BI Tableau Looker

Education

Degrees, certifications, and relevant coursework

Cornell University

Master of Science, Biostatistics and Data Science

Master of Science in Biostatistics and Data Science, completed in Dec 2024. Coursework included Artificial Intelligence, Big Data, and Hierarchical Modeling & Longitudinal Data Analysis.

Case Western Reserve University

Bachelor of Arts, Mathematics

Bachelor of Arts in Mathematics, completed in May 2023. Coursework included Exploratory Data Science, Data Science Models & Prediction, and Data Visualization & Analytics.