Casper McKay
Jefferson City,MO
Summary
Detail-oriented and methodical Data Analyst with over a year of experience supporting the Quarterly Census of Employment and Wages (QCEW) team at the Missouri Department of Higher Education and Workforce Development, working in collaboration with the Bureau of Labor Statistics (BLS). Skilled in data collection, validation, and analysis to ensure accurate reporting of employment and wage data. Adept at interpreting labor market trends, managing large datasets, and utilizing statistical tools to generate meaningful insights that support economical research and policy decisions. Strong attention ot detail, problem-solving abilities, and a commitment ot data integrity in compliance with federal and state regulations.
Overview
1
1
year of professional experience
Work History
Senior Associate Research/Data Analyst
MO Dept. of Higher Education/Workforce Development
01.2024 - Current
- Analyzed and maintained employment and wage data for the Quarterly Census of Employment and Wages (QCEW) program, ensuring compliance with Bureau of Labor Statistics (BLS).
- Developed and optimized SQL queries to extract, transform, and analyze large datasets, improving data accuracy and processing efficiency.
- Investigated and resolved data discrepancies, identifying and implementing solutions to enhance reporting accuracy before submission to federal agencies.
- Worked as the QCEW liaison to the Department of Economic Development, providing data insights.
- Assisted in creating quarterly and annual reports to used by multiple federal programs.
Education
Bachelor of Science - History
Drury University
Springfield, MO12-2021
Skills
- SQL Proficiency
- Excel Macro Proficiency
- Data Analysis & Interpretation
- Data Validation
- Statistical & Economic Reporting
- Data Visulization
- Automation & Process Optimization
- Problem Solving & Critical Thinking
- Collaboration
- Data Extraction
Timeline
Senior Associate Research/Data Analyst
MO Dept. of Higher Education/Workforce Development
01.2024 - Current
Bachelor of Science - History
Drury University
Similar Profiles
A. Johanna SandovalA. Johanna Sandoval
Research Analyst at State Of New Mexico-Higher Education Dept.Research Analyst at State Of New Mexico-Higher Education Dept.
CHUCHAY STARKCHUCHAY STARK
Program Coordinator at Saratoga County Dept of Workforce DevelopmentProgram Coordinator at Saratoga County Dept of Workforce Development
Jessica SchroederJessica Schroeder
ITSC Services Senior at State Of Wisconsin Dept Of Workforce DevelopmentITSC Services Senior at State Of Wisconsin Dept Of Workforce Development