Lea Chapman
Data & Business Analyst | Research & Data Evaluation
Hire this person
Send a job offer directly to this candidate
About
Data analyst with a research and program-evaluation background who turns complex healthcare, financial, and operational data into accurate reporting, automation, and decisions. Lead analyst on a statewide health data-exchange initiative and owner of state regulatory reporting, EDI submission pipelines, and FHIR interoperability mapping. Combines technical depth in SQL, Python, and EHR with training in research design, survey analysis, and behavioral science to gather requirements, validate data, and communicate findings clearly to clinical, finance, and leadership stakeholders.
Experience
Data Analyst - CMHC - Remote
(2025-12)
- Lead analyst for CMHC on BHX Connect, Colorado’s statewide behavioral health data-exchange initiative, mapping EHR data elements to FHIR and USCDI+ specifications and validating each field against the production database and LOINC codes for standardized outcome measures (PHQ-9, GAD-7, C-SSRS).
- Build and maintain 837P EDI encounter-submission pipelines (SQL and C#/.NET) to the state behavioral health authority and regional administrative services organization, implementing program-code crosswalks and funding-source payer logic and resolving claim-structure and envelope rejections.
- Built a compliance-tracking dashboard backed by SQL views and a stored procedure that monitors client assessment aging against state deadlines, using tiered clinician-attribution logic so leadership can see overdue and at-risk records by provider.
- Wrote Python scripts against the NextGen EHR to detect and correct mismatched client record numbers, restoring data integrity across billing, state reporting, and downstream extracts.
- Automated a weekly patient-experience survey extract for an external vendor, coordinating file layouts and survey-type specifications and building logic to distinguish telehealth from in-person visits.
- Own state behavioral health reporting for client assessments, substance-use treatment, and evidence-based practice programs, replacing legacy Crystal Reports with version-controlled T-SQL extracts, views, and stored procedures documented in Confluence; currently scoping a migration of legacy EHR data to Microsoft Azure.
Behavioral & AI Analyst - Remote
(2024-01)
- Applied psychological and behavioral science frameworks to identify and label behavioral traits in AI model outputs, such as tone, empathy, consistency, and safety-relevant tendencies, producing annotated data used to train and refine model behavior.
- Evaluated and scored AI responses against structured rubrics for accuracy, safety, and alignment, identifying recurring failure patterns and writing feedback that improved training data.
- As a Registered Behavior Technician (RBT), collected ABA session data using frequency, duration, latency, interval, and ABC (antecedent-behavior-consequence) recording methods under BCBA supervision.
- Graphed and analyzed client progress data to identify trends in skill acquisition and behavior reduction, supporting BCBA decisions to adjust treatment plans.
- Supported data reliability through interobserver agreement (IOA) checks and treatment-fidelity documentation, ensuring clinical decisions were based on accurate data.
Data Management Specialist (Contract) - U.S. Air Force Academy - CO
(2024-12 - 2025-09)
- Conducted on-site inspections of facilities across the Academy campus, documenting facility condition and contractor progress and verifying field observations against facility records.
- Audited outside contractor performance by comparing completed work, schedules, and invoiced costs against contract scope, documenting discrepancies and escalating findings to government leadership.
- Analyzed facility sustainment, restoration, and modernization (FSRM) and construction project data to support cost estimates, budget requests, and prioritization of maintenance and repair work.
- Maintained and reconciled facility, project, and financial records, keeping data accurate and audit-ready in line with DoD financial and recordkeeping requirements.
- Built trend reports and visual summaries of project status, spending, and budget needs, and worked with engineers and project managers to clarify data requirements and present findings to civil engineering, finance, and leadership teams.
Patient Care Manager - Grand Forks AFB, ND
(2022-06 - 2024-12)
- Built dashboards and trackers that let clinic leadership monitor patient volume, appointment demand, and service trends.
- During COVID-19, designed a tracker comparing patients booked under COVID-19 with those booked under their underlying symptoms, and presented the findings to leadership to clarify true clinic demand and guide scheduling and staffing.
- Verified patient insurance eligibility and coverage (TRICARE and other health insurance) before appointments, preventing billing issues and care delays.
- Served as a phone point of contact for patients, answering questions about their medical records, appointments, and referrals while protecting PHI under HIPAA.
- Coordinated care with multidisciplinary teams to resolve workflow bottlenecks and keep services compliant with Air Force medical protocols.
Education
M.S. - Program Evaluation and Data Analytics - Arizona State University
M.S. - Psychology - Arizona State University
B.A. - Psychology - Florida International University
A.A. - Psychology - Gulf Coast State College
