• Job Description

  Req#: R31380

  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.

  Individuals have primary responsibility for the design, development, maintenance and governance of business intelligence solutions (Power BI, Power Apps, Power Automate, SSAS, SSRS, etc) that support decision making within the Power Grid Operations (Transmission & Distribution) organizations. Individuals should have strong technical skills (SQL, BI Tools, data analysis) along with an understanding of work and outage management systems to help internal customers get the solutions they need. They should be skilled in planning, data analysis, evaluating alternatives, and preparing and presenting recommendations.

  Responsibilities

  • Work with internal customers on the development of requirements around their BI needs

  • Development of medium to complex solutions using Power BI or any of the other BI tools (SQL Server Reporting Services, Power Automate, Power Apps, Python, etc)

  • Support creation and maintenance of models and cubes in SQL Server Analysis Services (SSAS) or Power BI

  • Develop medium to complex SQL against either Oracle or SQL Server databases

  • Interface with internal organizations such as Finance, Project Management or Reliability Governance to facilitate solution delivery

  • Coordinate with Information Technology on requests

  • Develop solutions to complex business problems in a systematic manner

  • Uses technical understanding of existing reporting warehouses, or may develop local warehouses when necessary to support the development of solutions

  • Using Project Management fundamentals to help drive projects and initiatives to successful conclusions

  • Document warehouses to support cross training of co-workers

  Additional Responsibilities

  • Provides / serves as a central contact for technical expertise and business process guidance in the identification, analysis and resolution of problems and the advancement of opportunities.

  • Implements and integrates complex business changes across multiple, cross-functional depts.

  • Resolves complex system & business process problems. Analyzes and develops plan of action to correct or eliminate future issues.

  • Designs, revises and implements solutions to meet customer and business needs. Works to integrate solutions into existing business processes. Helps to manage change and communications across multiple departments.

  • Prepares thorough and accurate technical and business management reports, effective correspondence, accurate documentation and well-maintained records.

  • Coordinates and manages subject matter experts from a variety of disciplines and support organizations to provide business and system requirements and validation for business & IT projects

  • Responsible for establishing policy and procedures for specific system security in compliance with corporate IT standards.

  • Define and develop key metrics to measure system/business performance. Lead data analysis and/or root cause investigation that are across multiple work groups or multiple systems.

  • Provide future direction to external vendors for development of products to resolve business issues.

  • Coordinate the development of the long-range and 5-year business plans, and budget for the department and assigned locations to ensure compliance with Company strategic plans.

  • Coaches and mentors business and technical consultants as needed.

  • Develops and maintains standards and best practices across multiple business units

  Basic/Required Qualifications

  • Bachelor's degree in Statistics, Mathematics, Communications, Information Technology, Business, Technical Business Administration, Business Administration or related degree

  • In addition to bachelor's degree, three (3) years minimum of related work experience

  • In lieu of bachelor's degree, high school diploma AND seven (7) years minimum of related work experience

  Desired Qualifications

  • Experience in the utility industry.

  • Experience in database design, creating table and views, or writing stored procedures

  • Very strong SQL skills

  • Seven (7) years minimum of related work experience

  • Behavioral Competencies:
    - Innovative
    - Collaborative
    - Problem Solver
    - Delivers Results

  • Good working knowledge of distribution work processes (outage management, work management)

  • Skilled in project management theories and principles, including Agile fundamentals

  • Skilled in practices of planning, data analysis, evaluating alternatives, and preparing and presenting recommendations

  • Ability to deal with a variety of individuals from various socio-economic, cultural and ethnic backgrounds.

  • Excellent written and oral communication skills.

  • Strong data warehousing fundamentals

  • Experience with advanced Excel features (pivot tables, vlookup, etc)

  • Experience developing Power Apps

  • Experience developing Power Automate flows

  Working Conditions

  • M - F

  • 2 - 3 days per week in office, days of the week flexible

  • Hybrid mobility classification - work will be performed from both remote and onsite locations after the onboarding period. However, hybrid employees should live within a reasonable commute to a Duke Energy facility.

  #LI-hybrid

  Travel Requirements

  5-15%

  Relocation Assistance Provided (as applicable)

  No

  Represented/Union Position

  No

  Visa Sponsored Position

  No

  Posting Expiration Date

  Monday, August 12, 2024

  All job postings expire at 12:01 AM on the posting expiration date.

  Please note that in order to be considered for this position, you must possess all of the basic/required qualifications.

  Privacy

  Do Not Sell My Personal Information (CA)

  Terms of Use

  Accessibility

• About the company

  Help us shape a brighter future. Discover your career options with our job search tools for Duke Energy and Piedmont Natural Gas. Find current job openings organized by location, category or keyword. If you're interested in a particular position, apply online to be considered. And come back often - we post new positions frequently.

Notice