Associate Analyst, Transmission

This position facilitates development of the Transmission Capital Budget and Long-Range Plan. This includes performance measurements related to executing the plan along with reporting and analyses to provide corporate and business area leaders with the decision support information needed to drive performance improvements and meet company goals. Additionally, the analyst will support regulatory responses and a variety of performance improvement projects. The Analyst will work collaboratively with other team members and departments on routine work and special projects.

Essential Functions: 

• Works closely with Project Management and Investment Planning to understand investment schedules and in-service forecasts for active projects.
• Facilitates collaboration with System Planning Engineers, Asset Management, and other departments to understand scope, schedule, and budgets for future projects, programs, and opportunities.
• Assists with the creation of company long term forecasts.
• Assists with the creation of key regulatory filings related to the capital program.
• Facilitates the design, build and maintenance of performance reporting processes to assure up-to-date performance results are available for business use throughout the year.
• Collects performance data and information from a variety of sources and keeps all data collection tools organized and updated throughout the year.  Reviews and assures data quality on a regular basis, taking steps to correct data or processes as needed.
• Assists in the development of new tools, dashboards, lists, and metrics as needed to drive performance improvements and highlight areas of focus for transmission leadership
• Creates and maintains appropriate documentation for performance metrics (i.e., Basis Documents, etc.), all internal team processes and tools, and reporting processes to enable cross-training and business continuity.
• Prepares data, drafts of presentations, draft reports or information as needed to assist business improvement initiatives, respond to regulatory requests for information, as input to business decision making and for the goals & budget development processes.  May include repackaging existing information and/or creating new, ad hoc reports or tools.
• Proactively learns about the company, industry and in particular the business areas being support in order to understand, validate and communicate performance results and progress of business initiatives.

Technical Knowledge/Skill/Education/Licenses/Certifications:

Technical Knowledge/Skill: 

• Requires the ability to design, build, analyze and interpret data models (relational tables or databases), ability to use standard business reporting software to build and modify reports and databases and in using data from a data warehouse or other database.
• Must be able to identify and ensure data quality and accuracy. 
• Strong communications and interpersonal skills, strong mathematics capabilities, conceptual/analytics capabilities

• Candidates should demonstrate strong skills in Excel with the ability to develop advanced skills in Excel, Access, Power BI & other reporting tools
• Ability to interpret and summarize data with Excel and PowerPoint charts.
• Ability to use AI tools and chatbots to enhance aforementioned skills
• Requires self-directed work ethic and abilities, capable of taking the lead on action items or initiatives while also collaborating with others within and outside of the department.  

• Key skills are in understanding and using data to measure and explain performance, extracting and analyzing data, working with IT systems, developing analytics, collaborating with others, communicating in a business setting with all levels of management, excellent verbal and written communications, can demonstrate effectiveness in performance analysis, developing tools and models to analyze and explain results, developing executive presentation material to explain performance analyses.   
• Must be able to work independently and collaboratively within the organization and be able to recognize and work with sensitive and confidential information.

Education:    

• Bachelor’s Degree in Information Technology, Engineering, Business Administration, Finance, Accounting, Economics, or Mathematics, related discipline or equivalent experience                   

Experience:     

• Zero (0) to three (3) years related experience.  
• Prior experience in data handling and business process/performance analysis is preferred. 

Licenses & Certifications: