Senior Business Data Intelligence Specialist

More than a career - a chance to make a difference in people's lives.

Build an exciting, rewarding career with us – help us make a difference for millions of people every day. Consider joining the Duke Energy team, where you'll find a friendly work environment, opportunities for growth and development, recognition for your work, and competitive pay and benefits.

Position Summary

This position is responsible for the development of operational and performance analytics for the Carolinas, Florida and Midwest with a focus on reliability, safety, and operational excellence for operational groups including Distribution, Transmission, Veg Mgmt, and the States Presidents. More specifically the responsibilities are:

• Responsible for reporting and data analysis activities for reliability and work management functions.

• Ability to obtain data from various applications using Enterprise reporting tools such as Power BI, Microsoft Reporting Services, Sharepoint, etc.

• Interpret data based on understanding of business transactions/activities; and draw conclusions about data patterns and operational effectiveness.

• Write queries for data mining and synthesizing large datasets using SQL, Python, R Studio, SAS or equivalent.

• Specify, design, and prepare reports in support of PGO activities. Provide technical and functional knowledge of business processes and systems to ensure efficient design, development, implementation, and support of data management applications and reports related to PGO operational functions.

• This position’s primary responsibility is to serve as data owners for the PGO Safety and Reliability functions with emphasis on design, analysis, and report development. Duties of this position also include the consultation with users to specify/design/develop new reports, measures data, and data structures to support PGO functions. Prepare dashboard reports PGO. This position provides direction and approval of data management structures, tables, and universes to the technology application and architecture support team(s).

• Responsible for ensuring the timely and accurate delivery of data needed to support the business

• Experience in the utility sector specifically in the areas of Outage Management and key reliability measures like CAIDI, SAIFI, and SAIDI.

Responsibilities

• Extract key observations and insights from internal and external data sources to support decision-making

• Create ad-hoc reports to support end-user business requirements

• Data exploration, cleansing, validation and testing in order to optimize processes and discover value

• Collaborate with stakeholders, business partners, colleagues, developers, and business analysts to deliver high quality value-adding analytics solutions

• Performs opportunity analysis on PGO data to identify potential planning, forecasting, productivity and efficiency improvements

• Support in the development and maintenance of automated applications, tools and processes

Required/Basic Qualifications

• Bachelors degree in Computer Science, Physics, Information Technology or Business Administration AND three (3 years related work experience

Desired Qualifications

• Bachelors degree in Mathematics and Computer Science

• In addition to desired degree, 5 years related work experience

• Microsoft Power BI Desktop and/or Microsoft Excel - Advanced

Additional Preferred Qualifications

• Demonstrated understanding of business functions and ability to discern impact of request/problem on the business

• Ability to build and maintain effective working relationships with all levels of organization

• Advanced query writing skills for data mining and synthesizing large datasets using SQL, Python, R Studio, SAS, or equivalent.

• Demonstrated strong analytical skills and a strong intellectual curiosity for numbers.

• Demonstrated problem solving, decision making and attention to detail skills

• Strong understanding of and ability to use programming languages (e.g. SQL, Python, SAS, R, etc.)

• Experience using data visualization tools such as Power Bi

• Supply Chain experience preferred:

• Experience with data management / warehouse applications

• Previous experience in supply chain strategy and/or analytics groups

• Previous experience in business process reengineering

• Strong knowledge of basic and advanced prediction models.

• Data min