Senior Analytics and Visualization Consultant - Digital & Marketing Analytics

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, May 25, 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:

The Marketing & Digital Analytics team requires a skilled Business Intelligence Engineer/ Data Engineer to enhance our analytics capabilities and data infrastructure. This role is critical for developing robust Power BI solutions that drive marketing insights and decision-making and maintaining and improving our Python-based data extraction processes, ensuring data quality.

We are seeking a Business Intelligence Engineer/ Data Engineer to join our Marketing Analytics team. This position will focus on optimizing existing Python data pipelines, implementing best practices for code documentation and version control, and developing comprehensive Power BI data models to support marketing analytics initiatives.

They assess complex data systems and programs in support of ad-hoc and standing management or customer requests. Creates programs, methodologies, and files for analyzing and presenting data. Examines data quality, applications, and functions. Produces output and sustains operation. Researches new data sources and analytical tools. Contributes to new product development and improvement in product delivery and presentation. Develops awareness of and familiarity with issues and events affecting organization, department, and/or customer. Uses and supports database applications and analytical tools. Uses timely and appropriate participation of users/customers in data collection and query systems. 10+ years of experience. If you have had any responsibility for or participation in judicial, administrative, regulatory or other oversight proceedings involving Duke Energy or any of its affiliates, please identify the agency or department, the dates of your employment, and the nature of your responsibilities, including a list of any proceedings involving Duke Energy or any of its affiliates. NOTE: Only answer this question if you have worked with the government or other agency involved with Duke Energy oversight.

Key Responsibilities

Business Intelligence & Analytics

• Design and architect scalable marketing data infrastructure that supports current and future analytical needs.

• Design and develop Power BI data models tailored for marketing analytics

• Create interactive dashboards and reports that provide actionable marketing insights

• Collaborate with marketing stakeholders to understand analytical requirements

• Build and automate marketing dashboards using Microsoft Power BI

• Design PBI dashboard templates to achieve goals each line of business (LOB)

• Optimize data models for performance and scalability

• Ensure data accuracy and consistency across all BI solutions

• Use Python to perform advanced data analysis, modeling and automation

• Develop scripts to streamline marketing reporting, anomaly detection and audience segmentation

• Develop audience segmentation and clustering models to identify high-value customer groups and optimize campaign targeting

Data Engineering & Pipeline Management

• Develop data pipelines and ETL processes to integrate GA4 with other marketing platforms and data products.

• Maintain and optimize existing Python scripts for data extraction and file transfer processes

• Debug and troubleshoot data pipeline issues to ensure reliable data flow

• Implement comprehensive error reporting and monitoring systems

• Ensure all code adheres to security protocols and compliance requirements

• Document all code and processes in GitHub with clear, maintainable documentation

Code Management & Best Practices

• Create technical documentation and data governance frameworks to ensure data quality and consistency.

• Clean up and refactor existing codebase for improved maintainability

• Implement version control best practices using GitHub

• Establish coding standards and documentation protocols

• Conduct code reviews and ensure quality assurance processes

Key Success Metrics

• Successful documentation and cleanup of existing Python codebase within first 90 days

• Implementation of robust error reporting system

• Development of comprehensive Power BI data models for marketing analytics

• Reduction in data pipeline errors and improved system reliability

• Enhanced marketing insights through improved BI solutions

Required/Basic Qualifications

• Bachelor's degree

• In addition to required degree, five (5) years minimum of related work experience

Desired Qualifications

• Bachelor's Degree in Computer Science, Data Science, Engineering or Other Related Field

• 5+ years of experience in data engineering or business intelligence roles

• Strong proficiency in Python programming and data manipulation libraries

• Extensive experience with Power BI development and data modeling, mastering complex SQL & DAX

• Solid understanding of marketing analytics concepts and KPIs

• Experience with GitHub and version control systems

• Knowledge of data security protocols and compliance requirements

• Strong problem-solving and debugging skills

• Excellent documentation and communication skills

• Command of Google Analytics / Google BigQuery (GBQ)

• Experience with cloud platforms (AWS)

• Experience with marketing automation platforms and CRM systems (Sales Cloud)

• Command of SQL and database management systems

• Familiarity with data visualization best practices

• Understanding of statistical analysis and data science concepts

• Certification in Power BI or related BI tools

Additional Preferred Qualifications

• Command of Google Analytics / Google BigQuery (GBQ)

• Experience with cloud platforms (AWS)

• Experience with marketing automation platforms and CRM systems (Sales Cloud)

• Command of SQL and database management systems

• Familiarity with data visualization best practices

• Understanding of statistical analysis and data science concepts

• Certification in Power BI or related BI tools

Working Conditions

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

Specific Requirements

• Minimum of 5 years work experience OR 4 years work experience with a Masters degree

Travel Requirements

Relocation Assistance Provided (as applicable)

No

Represented/Union Position

No

Visa Sponsored Position

No

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