Business Analyst - Data

Puget Sound Energy
life insurance, paid time off, paid holidays, 401(k), retirement plan
United States, Washington, Bothell
19900 North Creek Parkway (Show on map)
Aug 05, 2025
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'sCustomer Operationsteam is looking for qualified candidates to fill anopenBusiness Analyst - Dataposition! Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process. Job Description This Business Analyst position offers a unique opportunity for you to lead business analytics initiatives and creative problem solving that supports PSE and our customers. You will bring expertise to design, build, and maintain complex reporting solutions while driving strategic data initiatives. Leads initiatives to design and build reporting requirements, information dashboards, data generators, and other end-user information portals or resources. Brings expertise or identifies subject matter experts in support of multi-functional efforts to identify, interpret and produce recommendations based on company reporting and data needs. Demonstrates knowledge of and support for internal and external reporting; performs complex data analysis to measure performance and identify efficiency opportunities; develops and maintains business rules for functions and processes; leads collaborative teamwork efforts to improve day-to-day operations and meet SQIs as mandated by the WUTC, other department key indicators, and corporate goals. 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 Leads daily operation and troubleshooting of Enterprise Data Systems Uses advanced analytical skills following clearly defined standard operating procedures Creates complex reports and provides data solutions aligned with customer expectations and PSE's business initiatives Integrates advanced data from multiple sources to produce requested or required data elements/reports Generates complex ad-hoc reports and regular datasets or report information for end-users using system tools and database or data warehouse queries and scripts Assists internal customers with advanced data requests and works closely with them to understand business and data needs Analyzes advanced data and provides exception reporting as needed Develops advanced programs and queries to support business functions and customer requests Provides advanced data to PSE departments either on a regular and/or ad hoc basis Writes SQL queries as needed to respond to customer data requests and perform analytics Maintains reporting documentation and ensures data accuracy and timeliness Programs and maintains advanced report forms and formats, information dashboards, data generators, canned reports and other end user information portals or resources Provides assistance and guidance to support staff and entry-level professionals as needed Identifies, analyzes, and interprets trends or patterns in complex data sets Develops and implements data collection systems and other strategies that optimize statistical efficiency and data quality Assists in maintenance, upgrades and testing of Data Systems and associated applications Ensures integration of data systems with other technologies and systems Modifies or customizes analytic project templates Produces technical documents in support of business requirements Performs other duties as assigned Minimum Qualifications Bachelor's degree in business, accounting or related field, or an equivalent combination of education and/or work experience 2 years work experience as an analyst Strong problem solving and analytical skills in a complex environment, with exceptional PC skills using Word, Excel, PowerPoint, Access, SAP and CIS; Strong time management and organizational skills. Able to work independently in a fast paced environment and prioritize assignments; Strong customer service, communication, and interpersonal skills with the ability to work well in a multi-team environment; Effective written and oral communication skills. Desired Qualifications Skilled in using Business Intelligence tools, SAP Export, Business Objects, SAP HANA, AWS Athena, Microsoft Fabric SSIS and SSRS experience Advanced skills in writing SQL queries and table structures Advanced proficiency in MS Power BI Strong skills in statistical analysis Ability to extract, analyze and process medium to large data sets Knowledge of utility business practices Project management training Working knowledge of WAC rules and tariffs, WUTC rules and regulations Familiarity with relational database design and concepts Knowledge of database internal Additional Information This role is posted at two levels for one opening: Senior Business Analyst -Data (5711) & Business Analyst - Data (5712). At PSE we value and respect our employees and provide them opportunities to excel. We offer a competitive compensation and rewards package. The pay range for this position is$70,200.00-$99,800.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.