Nolan Leavitt
Rosamond,CA
Summary
Accomplished Senior Data Analyst with expertise in Python, R, SAS and SQL, driving significant improvements in data accuracy and efficiency. Proven track record in statistical modeling and project leadership, successfully reducing data discrepancies and automating workflows, enhancing public health policy decisions through actionable insights.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
RTI International
01.2023 - 10.2024
- Led national and state-level tobacco surveillance analyses using Python, R, STATA, and SQL, directly influencing FDA and public health policy decisions.
- Reduced missing product-code data from 10,000+ records to fewer than 50 by designing a UPC validation system, dramatically improving national surveillance data accuracy.
- Automated monthly data cleaning and reporting workflows using Python, reducing labor hours by 25%.
- Performed large-scale observational analyses on Medicare claims datasets using fuzzy matching techniques to link records without shared identifiers.
- Built SQL (PostgreSQL) queries to monitor data quality, generate ad-hoc reports, and support analyst investigations.
- Developed web scraping and text-mining pipelines to identify emerging nicotine brands on social media, enhancing brand monitoring capabilities.
- Mentored junior analysts on programming best practices, enhancing code reliability and fostering a collaborative team environment.
- Designed research protocols and sampling methodologies for a $1.25M federally funded study.
Epidemiologist / Data Manager
Los Angeles County Department of Public Health
09.2020 - 01.2023
- Designed observational studies identifying hospitalization risk factors using SAS and SQL, informing public health interventions.
- Conducted regression analyses to identify predictors of hospitalization and severe outcomes.
- Created geospatial models to pinpoint high-risk populations for targeted public health interventions.
- Designed and analyzed epidemiological surveys to ensure statistically reliable data collection, enhancing study validity.
- Centralized electronic health record data into SQL Server infrastructure to enable real-time COVID monitoring and reporting.
- Built advanced SQL queries for reporting, analytics, and dashboard visualization.
- Cleaned and validated large EHR datasets, resolving duplicates and inconsistencies to maintain high-integrity data systems.
- Developed public-facing COVID dashboard delivering real-time metrics to inform policymakers and residents.
Epidemiologist
San Bernardino County Department of Public Health
07.2019 - 09.2020
- Developed logistic regression models analyzing 50,000+ cases to identify STD infection predictors.
- Generated daily COVID intelligence reports including statistics, forecasts, and visualizations for internal leadership.
- Investigated infectious disease outbreaks, including EVALI cases, and identified sources of illegal products.
- Built internal Hepatitis A dashboard using R for outbreak monitoring and response coordination.
- Automated report generation and distribution using SAS scripting, enhancing reporting speed and ensuring consistency.
- Validated and maintained electronic health record databases to ensure accuracy in reporting.
Education
Master of Public Health - Epidemiology/Biostatistics
Loma Linda University
Loma Linda, CA01.2020
Bachelor of Science - Psychology
West Virginia University
Morgantown, WV01.2016
Skills
- Statistical modeling
- Data visualization
- Python, SAS, STATA, and R programming
- SQL and database management
- Data cleaning
- Web scraping
- Problem solving and automation
- Project leadership
- Health data management
- Public health policy
Certification
- SAS Base Programming, 2021
- HIPAA Certification, 2023
- Applied Data Science with Python Specialization, University of Michigan
- Harvard CS50 Python, Harvard University
Websites
Timeline
Senior Data Analyst
RTI International
01.2023 - 10.2024
Epidemiologist / Data Manager
Los Angeles County Department of Public Health
09.2020 - 01.2023
Epidemiologist
San Bernardino County Department of Public Health
07.2019 - 09.2020
Master of Public Health - Epidemiology/Biostatistics
Loma Linda University
Bachelor of Science - Psychology
West Virginia University