Senior Business Support Analyst

Senior Business Support Analyst

Puget Sound Energy is looking to grow our community with top talented individuals like you! With our rapidly growing, award winning energy efficiency programs, our pathway to an exciting and innovative future is now. PSE's Planning team is looking for qualified candidates to fill an open Senior Business Support Analyst position! Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.

Job Description: Responsible for advanced evaluative, quantitative, and qualitative analysis in support of asset management electric system planning needs and requirements. This role focuses on developing analytical tools, models, and data frameworks to support capital planning, project portfolio development, and long-term transmission and distribution (T&D) physical asset lifecycle strategy. Provides technical support (troubleshooting, maintenance, and enhancement) and consultation for a variety of database systems and analytical tools. Leads development of performance metrics and reporting dashboards. Partners closely with system planners, IT software developers, data scientists, and enterprise analytics teams to build scalable solutions. Upholds the safety compliance standards inherent in PSE's operating and/or field procedures related to work responsibilities. Promotes and supports a culture of total safety. Demonstrates commitment to conduct business honestly, ethically and consistent with our core values and Code of Conduct. Ensures duties are performed in accordance with all regulatory compliance obligations.

Job Responsibilities:

• Uses advanced analytics and develops tools using Macro/VBA development for Excel and Access, to analyze asset and system data, identifying trends, root causes, metrics, and risk drivers.
• Supports capital investment decision-making through analyzing, trending, forecasting and scenario analysis.
• Designs tools to prioritize and optimize capital projects through tracking business/program performance and data statistics.
• Develops dashboards, KPIs, and performance reporting tools.
• Responsible for maintenance, enhancement and development of querying techniques used to effectively, consistently and accurately derive reports and data.
• Maintains and enhances data querying, reporting, and visualization tools.
• Communicates analytical methods, assumptions, and results with key stakeholders to allow for effective data-driven decisions in line with business goals.
• Leads or supports cross-functional initiatives and process improvements.
• Supports system maintenance, upgrades, testing, QA/QC on outputs, and training.
• Performs other duties as assigned.

Minimum Qualifications:

• Associate's degree in business, economics, finance, or related, and 5 years quantitative/qualitative analysis; or equivalent combination of education and/or work experience.
• Experience working with relational database systems (querying, analysis, reporting).
• Solid written, interpersonal, and group communication skills.
• Experience using a variety of business applications and analysis tools such as Access, Visio, PowerPoint, Excel, statistical software, SAP Business Warehouse, SAP modules, and Cognos.
• Excellent problem solving skills. Project management skills.
• Ability to understand and explain technical concepts.
• Excellent writing, communication and customer service skills.
• Strong time management and organizational skills.
• Experience in providing guidance and direction to lower staff. Ability to take initiative and work both independently and as part of a team to accomplish objectives.

Desired Qualifications:

• Advanced degree in engineering or analytics.
• Experience in electric utility system planning or T&D asset management.
• Experience in understanding business process relationship with data analysis and metrics.
• Experience with investment planning, risk modeling, or asset analytics.
• Data pipelines and dataset structuring.
• Strong data mining, conditioning, validation and QA/QC audit practices.
• Knowledge of rate-making process

Preferred Tools & Platforms:

• SAP and SAP HANA
• Power BI
• Microsoft Excel and Access (advanced functions, Power Query, VBA)
• SQL

At PSE, we value our employees and provide them with opportunities to excel. We offer a competitive and comprehensive total rewards package. To learn more about why PSE is a great place to work, see our Employee Value Proposition, which highlights our commitment to employee growth, work-life balance, and meaningful career opportunities in the energy sector. The pay range for this position is $82,000.00 - $136,300.00, and this position is eligible for annual goals based incentive bonuses. PSE offers a suite of benefits to our employees. Employees are eligible for medical, dental, vision, basic life, and short- and long-term disability insurance. There are additional voluntary options of supplemental life insurance, accidental death and dismemberment insurance, flexible spending accounts for health care and dependent daycare, and an Employee assistance program (EAP). For long term savings, PSE offers a 401(k) investment option and a cash balance retirement plan. Employees will also receive Paid Time Off (PTO) and Paid Holidays throughout the calendar year. Detailed benefit overviews can be found on our Career page - Why Work For Us (pse.com).

Families and businesses depend on PSE to provide the energy they need to pursue their dreams. Our steadfast commitment to serving Washington communities with safe, dependable and efficient energy started in 1873. Today we're building the Northwest's energy future through efforts like our award winning energy efficiency programs and our leadership in renewable energy. Puget Sound Energy is committed to providing equal employment opportunity to all qualified applicants. We do not discriminate on the basis of race, color, religion, sex, national origin, age, sexual orientation, gender identity, marital status, veteran status or presence of a disability that with or without reasonable accommodation does not prevent performance of the essential functions of the job, or any other category prohibited by local, state or federal law. Should you have a disability that requires assistance and/or reasonable accommodation with the job application process, please contact the Human Resources Staffing department at View email address on click.appcast.io or View phone number on click.appcast.io.