Liam Moyers
Huntington Beach
Summary
Results-driven Data Analyst with EMCOR Mesa Energy Systems, skilled in Power BI, Excel and Python. Expert in data visualization and statistical analysis, with a strong work ethic and attention to detail.
Overview
2
2
years of professional experience
Work History
Data Analyst
EMCOR Mesa Energy Systems
Irvine, CA
11.2023 - Current
- Developed and maintained a suite of Power BI dashboards supporting company-wide operations, including sales performance, accounts receivable, maintenance contracts, indirect budgets; built executive-level dashboards aggregating data across systems for service and branch managers.
- Developed and maintained data pipelines for seamless flow of information, ensuring timely availability for decision-making.
- Developed and deployed a Power Apps-based Accounts Receivable application, enabling AR staff to prioritize invoice follow-ups by value and overdue time; reduced 45+ day overdue balances from 26% to 6% in the first branch post-deployment.
- Currently developing a SARIMA-based forecasting model in Python to predict labor hours and revenue for seasonal workforce planning; aimed at improving hiring accuracy during peak summer demand in the HVAC industry.
- Automated routine data analysis tasks, freeing up time for more complex analysis.
- Led two company-wide Power BI training sessions, enhancing organizational analytics capabilities by upskilling teams on modern data visualization tools and techniques.
Education
Bachelors - Statistics And Data Science
University of California, Santa Barbara
Santa Barbara, CA07-2020
Skills
- Data visualization (Power BI)
- ETL Processes
- Excel
- Python programming
- SQL
- Data cleaning
- Statistical analysis
- Attention to detail
- Strong work ethic
Timeline
Data Analyst
EMCOR Mesa Energy Systems
11.2023 - Current
Bachelors - Statistics And Data Science
University of California, Santa Barbara