Senior Business Analyst – Energy Services Business

Duke Energy Corporation; Charlotte (NC); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Duke Energy Corporation seeks a hands-on Business Analyst and Data Engineer to join the Energy Services Business Support Team. You will translate business needs into robust data models, ETL pipelines, Power BI reports, and workflow solutions supporting sales, marketing and operations.

The role partners with stakeholders and IT teams to deliver practical, governable solutions, maintain data quality, automate processes, and document solutions for adoption and continuity.

Qualifications

• Bachelor's degree or GED with relevant work experience.
• 3+ years of business analysis or data engineering experience.
• Experience translating business needs into data models, ETL pipelines, and reporting solutions.

Responsibilities

• Provide business analysis and PM support for process improvements.
• Build and maintain data models and ETL pipelines across Power BI, Salesforce, Power Platform, and Excel.
• Design and maintain Power Apps and Power Automate solutions to automate workflows.
• Analyze data with Python/SQL/DAX and develop executive Power BI reports.
• Tell the data story with accurate health/trend insights for leadership.
• Collaborate with IT and business SMEs to gather requirements and produce design specs.
• Identify optimization opportunities and drive best practices.
• Monitor AI innovations to improve team efficiency.
• Manage technology projects and business cases from initiation to adoption.
• Lead meetings to align objectives and track progress.
• Support annual strategic plans and budgeting processes.

Skills

Analytical skills

Problem solving

Project management

Written and oral communication

Change management

Collaboration

Education

Bachelor's degree

GED/HS and 7+ years experience

Master's degree

Tools

Power BI

Power Platform (Power Apps, Power Automate, Dataverse)

Python

SQL

DAX

Salesforce CRM

Pardot / Marketing Automation

Excel

ArcGIS / Google Earth

Copilot / Codex / Claude Code

Job description

Job Summary

This position serves as a hands-on business analyst and data engineer for the Energy Services Business Support Team. The role translates business needs into reliable data integrations, Power BI reporting, and workflow solutions that support sales, marketing, and operations. Responsibilities include developing and maintaining data models and reporting solutions, improving data quality, automating recurring processes, troubleshooting existing tools, and documenting solutions to support continuity and adoption. The position partners with business stakeholders and enterprise technology teams to deliver practical, maintainable solutions within established governance standards.

Responsibilities

Data Analysis, Reporting, Project Management and Change Initiatives

• Provides business analysis and project management support for analyzing, designing, developing, testing, and implementing business process improvement initiatives.
• Builds and maintains authoritative data models and ETL pipelines across Power BI, Salesforce, Power Platform, and Microsoft Excel
• Designs, develops, and maintains Power Apps and Power Automate solutions to streamline business processes, automate workflows, and enhance productivity.
• Tracks business metrics and performs data analysis/engineering with Python, SQL, and DAX
• Builds & maintains executive reports in Power BI that deliver accurate views on business health and trends to inform business decisions. (Tell the story)
• Collaborates extensively with IT business partners and operations subject matter experts to capture comprehensive business requirements that ensure thorough development of technical design specifications.
• Identifies best practices or process improvement opportunities.
• Monitors technology and AI innovations to identify frontier capabilities to make the team more efficient and effective.
• Serves as project manager for technology projects, business cases, and proactive improvements.
• Facilitates sessions across the organization to achieve project objectives.
• Maintains knowledge and executes fundamental project management disciplines to implement key business initiatives.
• Supports team in the development and the execution of annual strategic business plans that align with fiscal and capital budgets.
• Engages and communicates effectively with fellow employees and key stakeholders in identifying opportunities that positively impact company financials by leveraging resources, processes, and technologies.

Communicates Effectively and Manages Change

• Provides input for strategies and goals as requested by the leadership team, communicating sound vision and perspective
• Collaborates with stakeholders to ensure their expectations are achieved and issues are resolved in a timely manner
• Maintains effective communications and working relationships with other groups and departments to support successful project design, implementation and adoption of new processes and initiatives

Maintain a Safe and Productive Work Environment

• Contributes to a positive work environment where fellow employees work safely and efficiently
• Maintains productivity and focus, keeping management well informed of project deliverables and emerging issues/opportunities as required
• Adopts and models the safety guiding principles
• Supports a consulting culture, mindset, and results‑oriented environment within the organization that drives teamwork
• Maintains strong project management, effective change management, process reengineering, and superior business case development skills

Basic/Required Qualifications

• Bachelor's degree and 3 plus years work related experience OR
• GED/HS and 7 plus years work related experience in lieu of a bachelor's degree.

Desired Qualifications

• Master's degree
• Advanced proficiency with Microsoft Power Platform – Power BI, Power Query, Power Apps, Power Automate and Dataverse
• Advanced proficiency with Python, SQL, DAX, or similar scripting languages.
• Demonstrated experience with geospatial tools like ArcGIS, Google Earth, etc.
• Proficient in Salesforce CRM, Salesforce Pardot (Marketing Automation), MS Office products - Word, Excel, PowerPoint, SharePoint, Teams etc...
• Demonstrated experience with AI tools like Copilot, Codex, or Claude Code
• Demonstrated analytical skills
• Demonstrated problem solving skills
• Demonstrated experience in project management
• Demonstrated process management experience
• Demonstrated solid written and oral communication skills, including small and larger group presentations
• Excellent communication, facilitation, motivational and interpersonal skills
• Demonstrated ability to drive change in the organization at both strategic and operational levels
• Strong financial acumen
• Candidate must be totally committed to corporate values and strategic objectives

Working Conditions

• Hybrid Mobility Classification – Work will be performed from both remote and onsite locations after the onboarding period. However, hybrid employees must live within a reasonable commute to their designated Duke Energy facility, not greater than 50 miles one way. Employees are expected to report to their assigned Duke Energy facility as required and directed by their manager, on average 3 full workdays per regular workweek.
• Prolonged sitting and Daily video calls

Travel Requirements

5-15%

Relocation Assistance Provided (as applicable)

No

Represented/Union Position

No

Visa Sponsored Position

No. This is not a Visa Sponsored Position. This role requires the ability to work lawfully in the U.S. without employment-based immigration sponsorship, now or in the future.

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