William Balsells
Data Analyst
Hire this person
Send a job offer directly to this candidate
About
Leverage Oracle SQL, Microsoft Access, and Microsoft Excel to query, extract, and join large-scale insurer datasets, performing complex data validation to identify discrepancies in reported information. Developed a VBA Data Validation Macro that optimized the data review lifecycle, reducing manual processing time by 30% (21 days). Lead data projects and participate in the design, testing, and installation of automated data collection systems to improve workflow efficiency.
Experience
RESEARCH DATA ANALYST II at CALIFORNIA DEPARTMENT OF INSURANCE (2023-01 – Present)
- Leverage Oracle SQL, Microsoft Access, and Microsoft Excel to query, extract, and join large-scale insurer datasets, performing complex data validation to identify discrepancies in reported information.
- Developed a VBA Data Validation Macro that optimized the data review lifecycle, reducing manual processing time by 30% (21 days).
- Lead data projects and participate in the design, testing, and installation of automated data collection systems to improve workflow efficiency.
- Apply statistical methods to produce comprehensive reports and tables, ensuring data integrity for management needs and research projects.
- Act as a technical liaison to communicate validation findings and project status to insurers and internal stakeholders, maintaining detailed documentation of all technical specifications.
SPECIAL PROJECTS ADMINISTRATOR at AMERICOR (2021-01 – 2023-12)
- Extensively utilized Excel to manage, sort, and distribute high-volume datasets to management and external organizations.
- Designed and maintained Google Data Studio/Google Sheet dashboards to monitor daily departmental operations and key performance indicators (KPIs).
- Managed and updated creditor and settlement data within the CRM system, ensuring data accuracy and high-fidelity documentation for the negotiations team.
- Translated complex project statuses and development issues between technical teams and creditors to ensure seamless implementation of new data protocols.
Education
Masters of Science in Computer Science – GEORGIA INSTITUTE OF TECHNOLOGY (2027-01)
Bachelor of Science in Applied Mathematics & Statistics – CALIFORNIA STATE POLYTECHNIC UNIVERSITY, POMONA (2017-01 – 2021-12)
