Senior Power BI & SQL Analytics Analyst

Scott Williams

*********@*****.*** 530-***-**** linkedin.com/in/scott-williams-76bb442/

Senior Business Intelligence Analyst Power BI Developer SQL and Data Analytics Summary

Senior Business Intelligence and Analytics professional with 20+ years of experience designing and delivering Power BI and SQL-based reporting solutions that drive smarter decisions and measurable business impact. Proven expertise in building scalable data models, executive dashboards, and performance analytics across energy, gaming, financial services, healthcare, agriculture, and technology organizations. Recognized for partnering with leadership and cross- functional teams to align analytics with business strategy, improve data accuracy, streamline reporting processes, and translate complex data into clear, actionable insights. Skills

Business Intelligence: Power BI Desktop, Power BI Service, Power BI Report Builder, DAX, RDL, Power Query (M), MicroStrategy, Domo, SSRS

Data and Modeling: SQL Server, Oracle SQL, MySQL, paginated reports, semantic models, dimensional modeling, star schema, bridge tables, data quality, data validation, and data cleansing Analytics and Performance: Exploratory data analysis, KPI design, performance measurement, forecasting, predictive analytics, requirements gathering, and stakeholder management Experience

Power BI Consultant - Dominion Energy Remote March 2026 - Present

• Develop Power BI semantic models and enterprise reporting solutions for energy generation, distribution, and usage data, enabling consistent KPI analysis across operational reporting.

• Design and optimize Oracle SQL queries and data transformations supporting scalable Power BI dashboards and paginated reports built from large operational datasets.

• Create advanced DAX measures, calculated tables, and DAX queries to deliver accurate KPIs, trends, and performance insights.

• Delivered 30+ scalable Power BI dashboards and paginated reports within the first four months of the engagement, improving visibility into energy operations and business performance.

• Develop parameterized RDL reports and reusable datasets that improve reporting accuracy and consistency while reducing manual analysis.

• Collaborate with business stakeholders and technical teams to translate reporting requirements into actionable BI solutions.

Business Intelligence Analyst - Gold Country Casino Resort Oroville, CA September 2025 - March 2026

• Led development of Power BI dashboards and integrated data models enabling consolidated performance views for gaming, marketing, hotel, and executive teams.

• Built SQL and Power BI reporting for gaming, marketing, promotions, and player behavior, improving visibility into campaign ROI, theoretical revenue, redemption performance, and customer segments.

• Developed advanced DAX measures for year-over-year, month-over-month, player-value, Pareto, and customer- segmentation analysis.

• Partnered with Marketing and Player Development to refine free play and carded vs. uncarded analyses, enhancing promotional targeting accuracy.

• Managed projects with department leaders to define KPIs and consolidate disconnected reporting into executive-ready performance dashboards.

Data Analytics Consultant - Trace3 Remote October 2021 - July 2025

• Designed Power BI dashboards and dimensional data models integrating complex SQL datasets, providing leadership with timely operational and performance insights.

• Automated recurring reporting and data-preparation processes, eliminating more than 10 hours of manual work per week while improving consistency and delivery speed.

• Developed scalable dimensional data models, including star schemas and bridge tables, to support complex enterprise analytics.

• Built data quality and validation controls within SQL and Power BI pipelines to improve accuracy and reliability of enterprise reporting.

• Partnered cross-functionally to define KPIs and reporting standards for strategic initiatives and performance tracking.

Market Research Analyst - Digital Path Inc. Chico, CA April 2020 - September 2021

• Led BI transformation driving 90% leadership adoption.

• Built Power BI dashboards delivering near real-time marketing and operations insights.

• Optimized SQL queries across Oracle and MySQL environments, improving report run times by 20%. Business Intelligence Analyst - AgReserves Inc Chico, CA November 2017 - March 2020

• Delivered MicroStrategy dashboards across CA and Chile production sites.

• Built Power BI solutions improving productivity by 20%.

• Owned full BI lifecycle - including QA, UAT, and deployment, ensuring timely, error-free releases.

• Defined KPIs and optimized reporting pipelines.

• Managed SQL data pipelines by developing and maintaining queries, views, and stored procedures for enterprise reporting.

Reports Developer - American Pacific Mortgage Rocklin, CA May 2015 - November 2017

• Built Power BI, SSRS, and Domo dashboards for mortgage operations.

• Automated reporting reducing prep time by 15+ hours/month.

• Developed SQL reporting logic for pipeline analytics, enabling weekly performance reviews for operations teams.

• Designed dimensional data models and structures to support reliable, high-performance reporting. Database Design Analyst - Enloe Medical Center Chico, CA January 2012 - September 2014

• Designed clinical dashboards improving quality-of-care visibility.

• Built hospital-wide reporting systems improving data reliability.

• Designed and delivered patient care and Cancer Center performance dashboards to help clinicians identify trends and improve quality-of-care outcomes.

Marketing Analyst - Gold Country Casino Oroville, CA August 2008 - July 2012

• Analyzed campaign ROI and guest behavior trends.

• Built promotional performance evaluation frameworks.

• Delivered executive reporting on marketing outcomes.

• Translated raw marketing and gaming data into clear, actionable insights that increased stakeholder adoption and cross-department alignment.

Education

Western Governors University

Bachelor of Science, Information Technology Management Butte Community College

Associate of Arts, Liberal Arts

Contact this candidate