Dillon Shearer

Summary

Data Analyst with a strong background in healthcare technology, data standards, and transformation processes. Adept at managing complex data workflows from raw data collection to standardized formats. Passionate about solving complex problems, driving business value, and improving outcomes in the healthcare space. Experienced in data modeling, clinical terminologies, and ETL processes, with a portfolio of projects demonstrating data analysis and visualization expertise.

Skills

Programming

Python, SQL, R

Data Analysis & Visualization

Pandas, Matplotlib, Seaborn, Tableau, Power BI

Machine Learning

Scikit-learn, TensorFlow

Database Management

MySQL, PostgreSQL, SnowSQL

Tools

Jupyter, Git, Excel

Data Standards & Terminologies

SNOMED CT, LOINC, RxNorm

Data Modeling & Integration

ETL processes, relational databases, graph databases

Serialization Formats

XML, JSON

Professional Experience

1. 01

   ANSWER ALS

   Data Concierge

   February 2022 - Present

   • Contributed to OMOP Common Data Model transformations, mapping clinical data to standardized terminologies.
   • Developed pipelines for transforming raw clinical data into standardized formats for research use.
   • Automated user acceptance processes with Python scripts, reducing manual effort.
   • Validated data integrity across multiple drops and supported data curation.
   • Facilitated data portal interactions, optimizing access for research purposes.
2. 02

   Equity Quotient

   Data Analyst

   September 2022 - April 2023

   • Created SQL views in Snowflake for dashboard integration.
   • Performed ETL on census data, transforming it for analysis.
   • Investigated data across healthcare, demographics, and income to derive insights.
   • Extracted, loaded, and explored HMDA data, leading to widget creation for visualization.
3. 03

   RARE-X

   Data Standards Intern

   June 2021 - February 2022

   • Ensured alignment of data with standardized health data sources.
   • Transformed data dictionaries and created JSON code for the Data Collection Platform.
   • Developed e-Consent documents to meet legal and functional standards.
4. 04

   Across Healthcare

   Software Quality Assurance Intern

   May 2021 - February 2022

   • Created survey code for data collection, contributing to a comprehensive survey library.
   • Assisted with integrating survey data into new structures.
   • Automated QA tasks using Selenium, improving software testing workflows.
   • Created and maintained data dictionaries to ensure compliance with health data standards.

Projects

1. 01

   2022 SAIPE Estimates Analysis

   Analyzed and visualized Small Area Income and Poverty Estimates (SAIPE) data to uncover insights on poverty rates and median income.

   Tools: Python, Pandas, Matplotlib, Seaborn

   Repository: Census SAIPE Analysis

2. 02

   State-by-State Analysis of Chronic Condition Drug Utilization and Costs

   Analyzed drug utilization patterns and costs across U.S. states, providing policy implications for healthcare strategies.

   Tools: Python, Pandas, SQLite, Matplotlib, Seaborn

   Repository: State-by-State Analysis of Chronic Condition Drug Utilization and Costs

Education