Cody Hilyard
Data Analyst
Ogden,UT
Summary
Collaborative, innovative, and passionate Analyst with 5+ years experience identifying trends through dashboards and visualizations. Advanced experience with SQL, R, Tableau, and Alteryx. Drives significant business impact and team efficiency through automation and data driven insights. Professionally trained in managing products from ideation to creation by using multiple prototypes.
Overview
2025
2025
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
Analyst III
Chick-fil-A Corporate Support Center
11.2022 - Current
- Led the prioritization of monthly reporting cycle work
- Identified trends and uncovered data-driven insights related to KPI performance by creating 2 Tableau dashboards with carefully curated visualizations
- Improved internal processes and client-facing data by partnering with 2 upstream teams monthly, and by using SQL to identify and resolve problematic patterns
- Strategically used data by leveraging SQL to share monthly inventory-related issues with upstream team, enabling them to research and resolve issues prior to publication of reports for both teams
- Created automation tool that manages complex data governance processes for trade secret data, by leveraging SQL and Alteryx to identify specific data users and determine which users need additional verification to use the sensitive data
- Created automation tool that refreshes data for 2 Tableau dashboards during reporting cycle
- Partnered with stakeholders and development team to enhance reporting system, improving team KPI by 16% in 2023 and 46% in 2024
- Adopted and specialized in programs specific to the office, such as Alteryx, Confluence, Jira, and Miro
Data Analyst - Technical - Staff
Castell
1 2022 - 11.2022
- Created an ETL process from multiple sources to create and maintain a data table containing hospital locations, enabling data scientists to generate new data driven insights
- Partnered with cross-functional teams to identify monthly trends in Population Health for upper management
- Automated part of monthly trends analysis by creating a dashboard, saving ~100 hours annually
- Uncovered data driven insights and opportunities through monthly ad hoc analyses for upper management
- Served as a subject matter expert for extracting data related to utilization of resources per member per month and per thousand members
- Worked closely with subject matter experts to implement standard queries, increasing the accuracy for all analysts' queries
- Facilitated weekly meetings and created questions to help 9 apprentices and FTEs master SQL concepts
- Mentored 2 apprentices and offered 1:1 guidance
- Adopted and specialized in programs specific to the office, such as Microsoft SQL Server and Python
Programmer/Analyst I
Utah State University Scholarship Office
05.2020 - 12.2021
- Highlighted monthly and yearly trends for scholarship utilization across all colleges at the university, by designing and maintaining dynamic year-end report
- Delivered year-end report to upper management with director
- Automated complex processes by creating dashboards that used SQL to extract and transform data, reducing 150+ hours of manual labor
- Coordinated collaboration with 7 offices and 22 staff members to complete projects with accuracy
- Leveraged innovative processes to create 20 dash- boards and optimized 26 more to support users
- Ensured integrity and accuracy of data by creating exception reports that identified incorrect data
- Adopted and specialized in programs specific to the office, such as Argos, Oracle, and WinSCP
Business Analyst Intern
Utah State University Human Resources
7 2019 - 4 2020
- Partnered with 53 employees from 13 business units to gather data regarding their hiring processes
- Created visualizations that illustrated trends and details among all business units' hiring processes
- Ensured integrity and accuracy of data by creating exception reports that identified incorrect data
- Increased office productivity by designing dashboards that extract and clean data
Education
Bachelor of Science - Statistics
Utah State University
Logan, UT 08.2015 - 05.2020
Skills
Trends Analysis
SQL, R
Process Improvement
Tableau, Alteryx
Excel/Google Sheets
PowerPoint/Google Slides
Report Production
Communication
Documentation
Statistical Analysis
Certification
Product Manager Certification (PMC), Product School
International Leadership & Service
Data Analyst Volunteer
Student Nutrition Access Center, Logan, UT
- Oct 2021 - present
- Each month, delivers an automated 10 page report that illustrates the organization's impact over 5 years
Data Analyst Volunteer
International Association of Statistical Computing
- May 2020 - May 2021
- Collaborated with 4 others under the direction of then acting President of the International Association of Statistical Computing
- Determined if increasing the organization’s international presence in various regions would be valuable
Mandarin-Speaking Volunteer
Non-profit religious organization, Brisbane, AUS
- Jun 2013 - Jun 2015
- Served as a leader for 30+ volunteers for 8 months by training and overseeing volunteer efforts
- Underwent intensive language training in Mandarin Chinese for 8 weeks. Continued studying Chinese on a daily basis for 2 years
Timeline
Product Manager Certification (PMC), Product School
11-2023
Analyst III
Chick-fil-A Corporate Support Center
11.2022 - Current
Programmer/Analyst I
Utah State University Scholarship Office
05.2020 - 12.2021
Bachelor of Science - Statistics
Utah State University
08.2015 - 05.2020
Data Analyst - Technical - Staff
Castell
1 2022 - 11.2022
Business Analyst Intern
Utah State University Human Resources
7 2019 - 4 2020
Similar Profiles
Michael LozanoMichael Lozano
Executive Director of Operations at Chick-fil-A RestaurantsExecutive Director of Operations at Chick-fil-A Restaurants
Jessica EdwardsJessica Edwards
Staff Selection Advisor at Chick-fil-A Support CenterStaff Selection Advisor at Chick-fil-A Support Center
April JettApril Jett
HR Generalist II at Chick-fil-A Support CenterHR Generalist II at Chick-fil-A Support Center