WPM Analyst or Senior Analyst

Tucson Electric Power•Tucson, AZ

13d

About The Position

The WPM Analyst or Senior Analyst is a member of the Wholesale Power Marketing team, supporting the Wholesale Marketing Department, SPP Markets+ and the Energy Imbalance Market (WEIM). The role uses data analytics to support operational excellence and market efficiency and is part of the Market’s Strategy and Analytics Team. It performs quantitative analysis of market results, dispatch, forecasts and settlements, and maintains data, models and reporting for SPP Markets+ optimization and system modeling. The role analyzes complex datasets, develops data-driven solutions, supports data management and ETL operations, and creates documentation for reporting and recurring analyses. The position supports wholesale market performance analysis, market strategy development, optimization model validation, data pipelines, automated reporting, and analytical tools. It works with business clients, technical teams, system administrators, and technology providers to troubleshoot systems, implement solutions, improve business processes, and support project requirements, testing and training. The Senior Analyst also performs the additional requirements-gathering, process-mapping, testing leadership, reporting, and project responsibilities described in the posting.

Requirements

Analyst minimum qualification: Bachelor’s degree, four years of experience in a related business area, or an equivalent combination of education and experience.
Effective verbal and written communication skills and proficiency in conducting productive meetings.
Effective critical listening, analysis and problem-solving skills.
Ability to articulate ideas and facilitate communication between business and technical personnel.
Effective time management and ability to multitask priorities and deliver assignments on schedule.
Strong analytical and conceptual skills.
Ability to work independently and participate effectively in a team project to achieve required functionality within budget and timeframe.
Ability to establish and maintain customer trust and confidence.
Ability to adapt effectively to rapidly changing technology and business conditions.
Strong knowledge of applicable PC programs and O365 tools, including Excel, Word and PowerPoint.
Ability to handle individual projects under the oversight of a more senior analyst.
Ability to assist with business process initiatives and continuous improvement efforts.
General understanding of one or more business areas and the technology used in those areas; ability to serve as a point of contact for several business areas.
Senior Analyst minimum qualifications include the Analyst minimum qualifications plus superior analytical, relationship-management, facilitation, project-management and problem-solving skills.
Senior Analyst ability to develop management-style reporting and presentations, such as PowerPoint and Excel.
Senior Analyst demonstrated ability to work with all levels of management and workforce.
Senior Analyst project-management skills, including multitasking, prioritizing, setting and meeting deadlines, working independently, and maintaining accuracy and attention to detail.
Senior Analyst deep understanding of at least a few business areas and the technology used in those areas.
Senior Analyst ability to successfully engage in multiple initiatives simultaneously.

Nice To Haves

Knowledge of SPP Markets+, the Energy Imbalance Market (WEIM), or other ISO/RTO operations.
Proficiency with advanced Excel concepts, including VBA, Power Query, PivotTables, VLOOKUP and INDEX/MATCH.
Microsoft Power BI data visualization, report design, DAX functions and measures.
Python and basic data-analysis packages, including Pandas, NumPy, Matplotlib, Seaborn and scikit-learn.
Knowledge of database technologies and data manipulation, including SQL, table structures, data types and stored procedures.
Experience maintaining complex generation and market data models or data pipelines.
Knowledge of quantitative methods, including statistics, forecasting, regression and optimization concepts such as linear or mixed-integer programming.
Knowledge of utility-scale and renewable generation and power-market modeling.
For Senior Analyst: Five years of utility experience in a related business area.
For Senior Analyst: Working experience in SPP Markets+, the WEIM or other ISO/RTO operations, including analysis of market results, dispatch and settlements.
For Senior Analyst: Advanced proficiency in Python and SQL, with experience building and maintaining automated data pipelines, data models and reporting such as Power BI.
For Senior Analyst: Hands-on experience with the PCI front office suite (GenTrader, Insights, Forecaster), OATI or similar energy-market systems.
For Senior Analyst: Applied experience with quantitative methods, including forecasting, regression, forecast-to-actual variance analysis, and validation of optimization model inputs and outputs.

Responsibilities

Perform quantitative and statistical analysis of market, dispatch, settlement and forecast data, including forecast-to-actual variance analysis, and communicate findings to WPM personnel and management.
Monitor and analyze wholesale market performance and trends in SPP Markets+ and the WEIM, and provide analytical support for market working group and protocol reviews.
Develop wholesale market strategies, including LMP and price-spread analysis, bidding strategy evaluation, and assessment of market opportunities and risks.
Validate optimization model inputs and outputs, including unit commitment, dispatch constraints, cost curves and transmission limits, against market rules and settlement results.
Build and maintain data pipelines, data models and automated reporting that feed market analysis, forecasting and optimization tools.
Develop analytical tools and scripts, including Python and SQL, to automate recurring analyses and support troubleshooting of market systems.
Work with clients to develop and maintain current business process maps and documentation.
Support WPM metrics efforts through data collection and validation, presentation, and evaluation of results.
Facilitate interactions between clients and internal and external technology providers to implement and maintain reliable solutions.
Work with technical resources and System Administrators to troubleshoot problems, investigate enhancements and determine solutions.
Document problem-analysis findings and corrective measures for ongoing support and audit purposes.
Participate on project teams, assist with requirements definition and process design, and ensure testing and training align with defined requirements and processes.
Identify opportunities to use information technology to simplify, integrate and improve organizational business and workflow processes.
Develop creative solutions and help business areas challenge assumptions about executing their plans.
Serve as a point of contact for business area relationships and establish trusted, credible and reliable client relationships.
For Senior Analyst: Gather requirements for moderate-to-complex enhancements and translate them into functional designs for technical resources.
For Senior Analyst: Analyze, document and map As-Is business processes; prepare To-Be process maps, fit/gap analysis, change impact analysis and related documentation.
For Senior Analyst: Develop system, integration and regression test plans; lead testing activities, including validation of data feeds and optimization model outputs.
For Senior Analyst: Develop and run ad hoc query reports to troubleshoot problems, fulfill audit requests and support other client requests.
For Senior Analyst: Evaluate application functions and features against business processes to support current and evolving business practices.
For Senior Analyst: Manage assigned tasks on large projects under a Project Manager or Business Lead, and lead small projects with required delivery documentation.
For Senior Analyst: Analyze market outcomes in detail and recommend improvements to models, forecasts and reporting.
Perform other job-related duties as assigned by management.