Senior Analytics and Visualization Consultant

Duke Energy; Charlotte (NC); Remote; USD 90,000 - 120,000; Full time

Job summary

Join a leading energy company as a Senior Analytics & Visualization Consultant, where you will leverage your expertise in Microsoft Power Platform to develop data-driven solutions. This role offers a chance to work independently on complex projects while collaborating with various stakeholders. You will be responsible for creating dynamic dashboards and providing insights that enhance operational performance and customer satisfaction. This position allows for remote work after onboarding, offering flexibility and a supportive work environment.

Qualifications

• Minimum of five years of related work experience.
• Expertise in DAX and SQL required.

Responsibilities

• Develop and maintain Power BI dashboards for performance metrics.
• Collaborate with stakeholders to deliver high-quality analytics solutions.
• Translate data visualizations into actionable insights.

Skills

DAX

SQL

Communication

Data Integrity

Education

Bachelor's Degree

Master's Degree

Tools

Power BI

Power Automate

Power Apps

Python

R

SAS

Job description

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 is the career/senior level of the Operational Visualization job hierarchy. Employees at this level manage work in areas of specialization, with minimal supervision. Incumbents are expected to develop advanced skills and to have the ability to work independently, with guidance limited to unusual or complex projects or issues. They are fully competent in all elements of Microsoft Power Platform (Power BI, Power Automate, Power Apps) and advanced analytics concepts. They identify problems, develop solutions and take actions to resolve. Senior Analytics & Visualization Consultant represents a level at which career may stabilize for many years.

Responsibilities:

1. Have a strong understanding of end-to-end performance as it relates to customer experiences (Start Service, Billing and Payments, Outage, Repair, Transfer, Stop Service, etc.) and contact center operations.
2. Maintain historical and build next-generation Power BI reporting dashboards that capture key performance metrics for business partners, especially after the launch of new cloud-based contact center platforms like Genesys / Elevate 360. Responsible for data analytics and tracking.
3. Collaborate with stakeholders, business partners, colleagues, developers, and analysts to understand requirements and deliver user-friendly, dynamic dashboards and reports that provide high-quality analytics solutions.
4. Ensure accuracy and integrity of datasets to uphold user trust in reporting and ad hoc information, through exploration, validation, and correction.
5. Translate data visualizations, models, and findings into strategic insights, providing actionable recommendations to improve operational performance and customer satisfaction.
6. Present work effectively to users and business leaders, highlighting trends, outliers, and data discoveries. Address stakeholder pain points with tailored data visualization solutions.
7. Demo, install, test, and set up Power BI workspaces, datasets, dataflows, dashboards, reports, APIs, and subscriptions.
8. Develop and maintain applications using Microsoft Power Apps.
9. Automate business processes and workflows with Microsoft Power Automate.
10. Ensure solutions are scalable, maintainable, and secure.
11. Provide technical support and training to users.
12. Stay updated with the latest features in the Microsoft Power Platform.
13. Lead or contribute to special projects as a team member.
14. Use SQL for data wrangling and transformation to prepare data for Power BI.
15. Develop statistical models and perform regression analyses to evaluate operational performance, customer sentiment, and economic impacts of various actions.
16. Document work and processes for knowledge transfer to junior developers.

Required/Basic Qualifications:

• Bachelor's Degree
• Minimum of five (5) years of related work experience, in addition to the degree

Desired Qualifications:

• Expertise in DAX and SQL
• Proficiency in Microsoft Power Platform (Power BI, Power Automate, Power Apps)
• 6+ years designing, developing, and testing Power BI solutions with emphasis on data modeling and dashboards
• Excellent communication skills, capable of bridging data science and business management
• Strong organizational skills and attention to detail
• Focus on data integrity and accuracy

Additional Preferred Qualifications:

• Bachelor's Degree in Statistics, Mathematics, Physics, Engineering, Computer Science, or MIS
• Master's Degree
• Knowledge of statistics, programming, and predictive modeling
• Experience with data mining or NLP
• Familiarity with scripting languages like SQL or Hive
• Knowledge of analytics tools such as Python, R, SAS, or Power BI
• Strong interpersonal skills and business acumen
• Project management principles
• Experience in the utility and contact center industries
• Customer-specific experience

Working Conditions:

• Remote work after onboarding, within reasonable commute to a Duke Energy facility, with occasional in-person meetings as needed.

Specific Requirements:

• Minimum of 6 years of work experience or 4 years with a Master's degree

Travel Requirements: Not required

Relocation Assistance: No

Union Position: No

Visa Sponsorship: No

Posting Expiration Date:

Sunday, May 18, 2025

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