Katie Spencer

About Katie Spencer

MBA (Data Analytics) – Northeastern State University, 2022 | BSBA Marketing & Management – Oklahoma State University | Lean Six Sigma Green BeltEnergy industry professional with 13+ years of experience in electric and gas operations across multiple U.S. states and Canada. Expertise includes natural gas utility rate design, rate case procedures, and competitive market analysis, with a proven record of driving operational efficiency and regulatory compliance.Skilled in data analysis, reporting, and process automation, including support for RPA and digital initiatives to implement cost-saving strategies. Strong experience with Python, SQL, Access, Excel, Salesforce, Power BI, and digital tools for reporting, analysis, and process optimization.Experienced in cross-functional collaboration, training, and stakeholder management, with a strong ability to translate complex regulatory and operational requirements into actionable solutions.Background in digital marketing and eCommerce, including managing campaigns across social media channels, Shopify platforms, A/B testing, and video content creation using iMovie, providing a comprehensive understanding of both technical and consumer-focused business operations.Core Competencies: • Natural Gas Utility Rate Design & Regulatory Filings • Competitive Market Analysis & Benchmarking • RPA & Digital Process Implementation • Data Analytics, Reporting & Visualization (Power BI, Excel, SQL) • Cross-Functional Collaboration & Team Training • Digital Marketing & eCommerce Management

Experience

1. Senior Analyst

   Con Edison

   Oct 2023 — Present · Manhattan, NY, US

   Prepared embedded and marginal cost-of-service studies, including development of unbundled cost components for competitive services within the Cost-of-Service group in the Rate Engineering Department at Con Edison.• Researched and benchmarked other utilities’ embedded and marginal cost methodologies to inform internal cost allocation frameworks and regulatory strategy.• Developed allocated cost-of-service studies supporting standby rate design and implementation.• Interpreted regulatory commission orders and evaluated impacts on the Company’s cost allocation and marginal cost methodologies.• Prepared testimony, exhibits, and workpapers for regulatory proceedings; analyzed opposing testimony and supported rebuttal development and cross-examination preparation.• Collaborated with internal departments and external utilities to exchange technical and regulatory information supporting cost studies and rate development.• Responded to internal and external inquiries regarding electric, gas, and steam embedded, marginal, and allocated cost studies.• Designed and utilized analytical tools and systems to support data analysis, cost modeling, and regulatory reporting; maintained organized documentation and audit-ready workpapers.• Supported staff training and coordination of section work assignments while maintaining expertise in the Company’s AMI and financial systems.• Directed governance of the natural gas tariff framework, ensuring consistent interpretation and enterprise-wide operational alignment.• Served as the primary subject matter expert on tariff policy, advising regulatory, legal, billing, and operational teams.• Led cross-functional implementation of tariff revisions across billing systems, customer programs, and operational processes while ensuring regulatory compliance.• Supported regulatory filings and strategic initiatives by analyzing tariff impacts on rates, billing structures, and customer programs.

Education

• New Mexico State University

  REGULATORY TRAINING FOR NATURAL GAS LOCAL DISTIBUTION (“LDC”)

• Tulsa Community College

  Bachelor of Business Administration (B.B.A.)/ Digital Media, Business Administration

  2013 — 2016

• Oklahoma State University

  Bachelor's degree, DBL Major: Marketing and Management Minor: International Business

  2016 — 2018

• Northeastern State University

  Master of Business Administration - MBA, Business Analytics

  2021