Lead Analytics & Visualization Consultant

Important Application Submission Information In order to ensure your application is successfully received before the job posting expires, please submit your application by 11:59 PM on Monday, August 24, 2026 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 serves as a technical leader within PGO Project Controls Governance, responsible for the design, development, administration, and continuous improvement of project controls systems, data architecture, and business intelligence solutions. The role partners closely with Project Controls, PMO, IT, and business stakeholders to ensure accurate, reliable, and efficient delivery of project, program, and portfolio reporting. Responsibilities include supporting enterprise project controls platforms such as EcoSys and Primavera P6, developing reporting and analytics solutions, managing data integration processes, building and maintaining reusable data tables and views within the PGO Reporting Database, and maintaining governance standards across project controls systems. The incumbent functions as a subject matter expert in project controls data management and reporting, providing technical leadership, mentoring peers, and driving continuous improvement initiatives. This position operates with a high degree of independence and is expected to solve complex business and technical challenges while supporting strategic organizational objectives. Positioning statement: This position serves as the technical backbone for Project Controls Governance data Primary Function - Project controls systems, data governance, reporting architecture, and technical support Core Systems - EcoSys, Primavera P6, Power BI, SharePoint, SQL-based data sources, and related enterprise systems Technical Emphasis - Backend data management, SQL, integrations, data quality, reporting models, automated processes, and development of reusable data tables and views within the PGO Reporting Database. Business Emphasis - Reliable project, program, and portfolio reporting aligned to Project Controls Governance standards Responsibilities Serve as a technical subject matter expert for Project Controls Governance systems, including EcoSys, Primavera P6, Power BI, SharePoint, and related enterprise applications. Design, develop, and maintain complex reporting solutions, dashboards, and business intelligence tools supporting project, program, and portfolio management. Develop and support backend data architecture, SQL queries, stored procedures, data models, reusable data tables and views in the PGO Reporting Database, and automated data integration processes used to support enterprise reporting and analytics. Translate business and reporting requirements into governed, reusable datasets by identifying source data, defining transformation and aggregation logic, optimizing query performance, documenting data lineage, and validating outputs with stakeholders. Work with large and complex datasets to ensure data quality, consistency, and governance across multiple project controls systems. Partner with business stakeholders, project controls professionals, regional administrators, and IT resources to identify reporting requirements and deliver technical solutions. Perform system configuration, testing, validation, troubleshooting, and implementa