Data Analyst — State of Utah, Division of Oil, Gas & Mining
Apr 2025 – Present · Salt Lake City, UT (Hybrid)
Python
SQL Server
Power BI
ArcGIS
Automation
- Built an automated Python system to extract and process data from thousands of PDFs, reducing a weekly 10-hour manual task to near-instant execution.
- Designed and deployed 40+ automated processes across the division, eliminating redundant data entry and freeing 11 employees to focus on higher-priority work.
- Developed SQL views and Python scripts to auto-populate regulatory notices (NOVs), saving approximately 125 hours annually across an estimated 500 notices per year.
- Created a workload demand vs. capacity report with a 5-year forecast using SQL aggregation and Python visualization, built for DNR upper management decision-making.
- Built SQL reporting pipelines on datasets of millions of records to ensure accurate regulatory compliance reporting.
- Developed interactive Power BI and ArcGIS dashboards for cross-departmental stakeholders, translating complex data into accessible visual insights.
- Trained colleagues on automated tools and dashboards, fostering a data-driven culture and technical upskilling within the team.
817 hrsSaved through automation
40+Processes automated
125 hrs/yrNOV generation saved