Mitch Erekson
Springville
Summary
Analytics manager with over 5 years of experience in transforming complex datasets into actionable insights and strategic recommendations. Adept at leveraging advanced statistical and analytical techniques to extract valuable information and drive data-informed decision-making.
Overview
7
7
years of professional experience
Work History
Director of Analytics
Blue Raven Solar
10.2024 - Current
- In September of 2024, Complete Solar acquired Blue Raven and Sunpower’s New Homes division. Shortly after the acquisition, I was promoted to oversee analytics for all three companies. Duties include: material cost reporting, pricing analytics, invoice approval, and contract management.
- Led initiative to combine all three companies' cost reporting and builder payments. We utilized Snowflake, Excel, and Power Bi for reporting needs.
- Developed data roadmap for pricing analytics around installation partner payments and builder invoicing across cross functional groups including: Finance, Software Development, and Operations.
- Presented data roadmaps to the executive team identifying cost savings of ~$20,000 a quarter.
- Developed builder onboarding program partnering with marketing and sales teams to identify key milestones to collect revenue.
Senior Manager of Supply Chain Analytics
Blue Raven Solar
06.2023 - 10.2024
- Lead team of supply chain analysts.
- Focused on minimizing costs around BOM and crew materials while launching new battery products.
- Stood up reporting for material purchases, credit tracking, and battery operations using python, SQL, and Power Bi.
- Managed the relationship between Blue Raven and suppliers to ensure best pricing on materials and accurate invoicing.
- Ran and analyzed RFP for new racking butyl attachment. Identified 2 key areas how the customer experience would improve:
- Decreased cost from $0.11 a watt to $0.095 a watt resulting in savings of ~$50,000 a month.
- Reduced roof leaks from ~3% to ~0.7%
- Developed process to analyze wire costs. Identified gap in supplier pricing allowing the company to save ~$0.10 a foot on 48% of wire purchases.
- Implemented a credit requesting process and credit tracking dashboard that saved the company ~$40,000 per month.
- Promoted to oversee Fleet team in April 2024, increasing direct reports from 2 analysts to 1 manager, 2 analysts, and 4 coordinators.
Data Center Logistics Analyst
Meta
11.2022 - 04.2023
- Managed and optimized the logistical operations, including inventory management, supply chain coordination, and vendor management, to ensure smooth and efficient operations. Created reporting around operations using SQL, python, and Facebook designed visualization tool.
- Decreased aging move orders from 110+ to under 10 consistently, via a historical report that compared our site to the rest of the fleet.
- Stood up site wide health dashboard for all cross functional partners. Later expanded to all sites in our fleet.
Senior Data Analyst
Summit Capital
04.2022 - 11.2022
- Created and presented monthly, quarterly, and year end reports to leadership. Ran payroll each week and created ad hoc reports. Worked with managers to improve processes.
- Create SQL Server database. Including design, ETL and maintenance. Centralized over 780 spreadsheets into a database for enhanced data analysis.
- Tracked, analyzed, and provided suggestions centered on equipment usage. Resulted in a 28% decrease in loadout cost.
- Automated month end accounting reports using Python, saving over 40 hours of work per month.
Senior Supply Chain Analyst
Overstock
11.2020 - 04.2022
- Stood up the reporting around delivery messaging analytics. Delivered quarterly reports to the COO to report to the board. Regularly integrated with multiple teams requiring excellent communication to company leadership.
- Reduced click to delivery from 4.1 to 3.5 by developing a dashboard on warehouse and fulfillment performance.
- Managed OKRs for 10 Product Managers. Built dashboards and ad hoc reports related to those OKRs.
- Provided reporting for a new streamlined Machine Learning model to better predict delivery messaging.
Data Operations Analyst
MotivHealth
09.2020 - 11.2020
- Supported operations for plan and HSA adoption. Utilized SQL with stored procedures, report creation, and ad hoc queries.
- Led project to organize department responsibilities centered around client management. Created several tables and populated department data.
- Validated information in the database by writing queries around questionable data and working with partner services to get issues resolved.
Data QA Analyst
1800 Contacts
11.2018 - 09.2020
- Hybrid role between QA analyst and a data analyst. Supporting the logistics team with SQL and dashboarding support and QA for development of distribution center applications.
- Delivered a new dashboard that the distribution center uses for forecasting and staffing.
- Validated reports for Purchasing, Shipping, and Inventory while making suggestions to improve the readability of the reports.
- Write SQL queries and analyze stored procedures to dig deep into problems to develop a solution.
- Outbound Operations Supervisor Jul 2015 - Nov 2018
- Lead team of up to 25 associates, ensuring that all orders were accurate and shipped in a timely manner.
- Created multiple stats based dashboards using Excel. Utilized pivot tables and visualizations.
- Communicate between multiple departments to finish Distribution Center wide process improvements.
Education
Bachelor of Science - Information Systems
Utah Valley University
Orem, Utah05.2020
Skills
- SQL
- Power Bi
- Big Query
- SQL Server
- Python
- Excel
- Project Management
- Tableau
- Data Analysis
- Teradata
- Microstrategy
Timeline
Director of Analytics
Blue Raven Solar
10.2024 - Current
Senior Manager of Supply Chain Analytics
Blue Raven Solar
06.2023 - 10.2024
Data Center Logistics Analyst
Meta
11.2022 - 04.2023
Senior Data Analyst
Summit Capital
04.2022 - 11.2022
Senior Supply Chain Analyst
Overstock
11.2020 - 04.2022
Data Operations Analyst
MotivHealth
09.2020 - 11.2020
Data QA Analyst
1800 Contacts
11.2018 - 09.2020
Bachelor of Science - Information Systems
Utah Valley University
Similar Profiles
Zachary LukerZachary Luker
Salesperson at Blue Raven SolarSalesperson at Blue Raven Solar
Jakob MillerJakob Miller
Regional Installation Manager at Blue Raven SolarRegional Installation Manager at Blue Raven Solar
Austin ArringtonAustin Arrington
Installation Closeout Specialist at Blue Raven SolarInstallation Closeout Specialist at Blue Raven Solar
Soane SiasauSoane Siasau
Quality Control Inspector at Mc Wane DuctileQuality Control Inspector at Mc Wane Ductile
Kyle OttesenKyle Ottesen
Technical Support Manager at QolsysTechnical Support Manager at Qolsys