All Resumes

Dillon Shearer

Data Analyst

dillshearer@outlook.comlinkedin.com/in/dillonshearergithub.com/dillon-shearerdatawithdillon.comNewnan, Georgia

Data analyst with 4+ years translating complex healthcare datasets into actionable insights for researchers and executives. Built dashboards and reporting systems used by 470+ stakeholders, validated clinical data across 9 source systems, and delivered analyses that shaped research priorities and operational decisions. Skilled in SQL, Python, and modern BI tools with deep experience in data quality, metric definition, and clear communication of findings.

Technical Skills

SQLPythonTableauPower BIPandasLookerExcelData Validation

Experience

Data Scientist

Answer ALS - Remote

Feb 2022 - Present

  • Built real-time DUA tracking dashboard providing visibility into 470+ researcher agreements, surfacing renewal deadlines and approval status that reduced compliance gaps by 40%.
  • Deliver monthly board-level metrics on data access trends, request volumes, and platform utilization, directly informing resource allocation and strategic priorities.
  • Validate clinical data integrity across each release cycle, identifying and coordinating corrections for discrepancies before research distribution.
  • Curate master participant index from 9 sources, maintaining the single filterable document that enables researchers to identify cohorts across 1,200+ participants.
  • Standardized external dataset specifications through Looker intermediate tables, enabling consistent joins and reducing ad-hoc data prep time by 60%.

Data Analyst

Equity Quotient - Remote

Sep 2022 - Apr 2023

  • Sourced, cleaned, and modeled 12 datasets to power client reporting, delivering 7 dashboards and 30 KPI widgets tracking demographic and economic equity metrics.
  • Delivered ad-hoc analyses slicing data by geography, race, income, and industry, providing narrative insights that shaped client strategy and public messaging.
  • Partnered with product team to validate widget logic changes, documenting baseline-vs-updated comparisons and quantifying impact on client-facing metrics.
  • Investigated intersections across healthcare, demographic, and economic datasets, surfacing actionable insights that informed stakeholder decision-making.

Data Standards Intern

RARE-X - Remote

Jun 2021 - Feb 2022

  • Aligned internal data structures with external health data standards, enabling cross-dataset analysis and accelerating researcher time-to-insight.
  • Developed e-Consent documentation meeting legal and regulatory standards, supporting compliant patient data collection across multiple rare disease studies.

Software Quality Assurance Intern

Across Healthcare - Atlanta, GA

May 2021 - Feb 2022

  • Maintained data dictionaries ensuring platform compliance with healthcare data standards, serving as reference documentation for clinical data workflows.
  • Validated survey data collection processes, identifying gaps in data quality and recommending improvements adopted by the development team.

Key Projects

DUA Tracking System

Automation platform managing 470+ data use agreements for research compliance. Handles user lifecycle tracking, generates committee reports, monitors renewal deadlines, and maintains audit trails. Saves 15+ hours weekly of manual administrative work.

PythonPandasAzure Blob StorageXlsxWriter

Fitness Analytics Dashboard

View Demo

Interactive fitness tracking application with data entry, trend visualization, and AI-powered workout insights. Features real-time charting, progress analytics, and conversational interface for exploring training data.

ReactNext.jsPostgreSQLRechartsOpenAI API

Education

Bachelor of Business Administration, Management Information Systems

University of West Georgia

2022

Certifications

Protecting Human Research Participants

PHRP Online Training, Inc. | ID: 3004648

Apr 2025