Hailey Allen
Linköping,ÖS
Summary
Results-driven Senior Data Analyst with expertise in SQL querying and data visualization at California Mental Health Services Authority. Proven track record in developing impactful dashboards and reports that enhance decision-making. Strong collaborator with a commitment to data integrity and a passion for transforming complex data into actionable insights.
Overview
4
4
Languages
1
1
Certification
4
4
years of post-secondary education
14
14
years of professional experience
Work History
Senior Data Analyst
California Mental Health Services Authority
Sacramento
09.2024 - 08.2026
- Analyzed patient data to identify trends in mental health services.
- Developed reports to support program evaluation and decision-making.
- Collaborated with teams to ensure data accuracy and integrity.
- Maintained databases to support ongoing research initiatives.
- Developed complex SQL queries to analyze large datasets for trends and insights.
- Developed dashboards in PowerBI to provide real-time business intelligence insights.
Data Engineer
Artic Slope Regional Corporation
Denver, CO
11.2021 - 05.2024
- Designed data pipelines to streamline data flow across various systems.
- Collaborated with teams to gather requirements for data integration projects.
- Developed and maintained ETL processes for efficient data transformation.
- Utilized cloud-based tools for scalable data storage and management solutions.
Data Analyst
Colorado Department of Public Health and The Environment
Denver, Co
09.2020 - 11.2021
- Analyzed public health data to identify trends and inform decision-making.
- Created visual reports using Tableau to present findings to stakeholders.
- Collaborated with team members to develop data collection methodologies.
- Covid First Responder
Data Analyst
Ellipse Analytics
Denver , CO
05.2019 - 09.2020
- Designed and automated reports to deliver timely insights for decision-making with Python
- Managed ETL processes to ensure consistent data flow between systems
- Streamlined SQL database refresh processes to enhance operational efficiency.
Substitute Teacher, K-12
Charter Substitute Teacher's Network
Denver, CO
03.2019 - 06.2019
- Delivered engaging instruction across diverse K-12 subjects.
- Adapted lesson plans to meet varying student needs and learning styles.
- Fostered relationships with students to encourage participation and engagement.
English Teacher
Freelance
Dalian, China
09.2012 - 06.2013
- Facilitated interactive discussions that encouraged critical thinking, leading to deeper understanding of language concepts.
- Designed engaging lesson plans that catered to diverse learning styles and enhanced student engagement.
- Developed creative activities that inspired a love for language, contributing to increased student participation.
- Designed interactive games aimed at boosting student self-esteem in learning activities.
Education
Bachelor of Arts -
Colorado College
Colorado Springs, CO 08.2013 - 05.2017
Skills
- SQL querying
- Data transformation
- Data visualization
- Dashboard development
- Power BI
- Tableau software
- R programming
- Advanced Excel
- Documentation
Languages
English
First Language
Chinese (Mandarin)
Upper Intermediate (B2)
B2
Russian
Advanced (C1)
C1
Swedish
Beginner (A1)
A1
Certification
- TEFL 2017
Accomplishments
- Women's Education Society
Affiliations
- Musician, Painter, Poet, Singer
Timeline
Senior Data Analyst
California Mental Health Services Authority
09.2024 - 08.2026
Data Engineer
Artic Slope Regional Corporation
11.2021 - 05.2024
Data Analyst
Colorado Department of Public Health and The Environment
09.2020 - 11.2021
Data Analyst
Ellipse Analytics
05.2019 - 09.2020
Substitute Teacher, K-12
Charter Substitute Teacher's Network
03.2019 - 06.2019
Bachelor of Arts -
Colorado College
08.2013 - 05.2017
English Teacher
Freelance
09.2012 - 06.2013