Senior Business Support Analyst - Asset Management System Planning

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- Asset Management System Planning position!

Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.

Job Description

The Senior Business Support Analyst is responsible for business analysis, data management, reporting, and decision support for electric distribution and transmission asset lifecycle planning within System Planning. Works with data from SAP HANA, SAP BW, GIS, Excel, Access, and Power BI environments to develop reporting solutions, support capital planning analytics, and maintain business performance metrics. Partners with asset planners, engineers, IT, and data stakeholders to improve data quality, data governance, and reporting consistency. Develops and maintains data extraction, conditioning, validation, and reporting processes that enable reliable, data-driven planning and investment decisions. This role focuses on business analysis, reporting, data quality, and decision support and is not a software development, data engineering, or data science position.

All PSE employees are expected to uphold the safety compliance standards inherent in PSE's operating and/or field procedures related to work responsibilities and promote and support a culture of total safety. Additionally, employees need to demonstrate commitment to conduct business honestly, ethically and consistent with our core values and Code of Conduct. All duties are to be performed in accordance with all regulatory compliance obligations.

Job Responsibilities

• Uses business analysis, data management, trend analysis, forecasting, and reporting techniques to identify performance trends, asset risks, and planning opportunities.

• Responsible for maintenance, enhancement, and development of data extraction techniques using SAP HANA, SAP BW, GIS, SQL, Power BI, Excel, VBA, and Macros.

• Develops metrics, dashboards and recurring analysis, in partnership with Asset Management Planner.

• Develops and maintains data extraction, conditioning, validation, and reporting processes using SAP HANA, SAP BW, SQL, Power BI, Excel, VBA, and Macros.

• Coordinates implementation, testing, and deployment of enhanced reporting capabilities, business system improvements supporting accessibility of data used for Asset Management programs.

• Responsible for PowerBI report maintenance, enhancements, troubleshooting, and training for internal and external stakeholders, when necessary.

• Assesses current business processes, automates reporting solutions, and evaluates data management practices to develop improvements that enhance program efficiency, consistency, and data consumption.

• Supports and participates in enterprise initiatives for data quality, governance, and reporting standardization.

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 sytems (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

• Bachelor's degree in related field.

• 5-8 years utility-related experience.

• Related business-specific experience may include:

• Advanced relational database experience (MS Access, SQL, Oracle).

• Experience performing advanced statistical analyses (such as predictive analytics, regression forecasting, data visualization and/or survival analytics).

• Experience with CSEE Systems (CSY, CIS, CMS).

• Experience in Crystal Reports and Adobe Acrobat Pro.

• Programming language (Visual Basic, SQL, VB.NET, HTML).

• Knowledge of rate-making process.

• Familiarity with Fabric.

• Process documentation and improvement experience.

Additional Information

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 jobs@pse.com or 425-462-3017.

Nearest Major Market: Seattle

Nearest Secondary Market: Bellevue