Supply Chain Business Analyst Principal

American Electric Power; Columbus (OH); On-site; USD 100,000 - 120,000; Full time

Job summary

American Electric Power in Columbus, OH is seeking an experienced analytics leader to design data models, build Power BI dashboards, and guide cross-functional teams.

You will develop data warehouse foundations, apply Python for automation, and translate business questions into robust analyses and executive reports.

The role requires 10+ years in supply chain/finance, a relevant degree, and proven leadership in complex data projects.

Qualifications

• Bachelor’s degree in a relevant field or equivalent experience with 10+ years in supply chain, procurement, or IT.
• Alternative: Associate’s degree with 12+ years in relevant areas.
• Alternative: High School diploma with 14+ years in related fields.

Responsibilities

• Design, write, and optimize complex queries across data marts and sources.
• Build warehouse tables for accurate downstream reporting and analysis.
• Apply Python to support data transformation and automation workflows.
• Create executive Power BI dashboards and insights from multiple sources.
• Collaborate with stakeholders to model data and visualise business questions.
• Investigate data to identify trends and opportunities for improvement.

Skills

Data analysis

SQL

Power BI

Python

Education

Bachelor's Degree in Supply Chain Management, Business Finance, Accounting, or related field

Associate’s Degree in related field with 12+ years experience

High School Diploma with 14+ years experience

Tools

MS Office

Data warehousing basics

Job description

Job Posting End Date

09-13-2026

Please note the job posting will close on the day before the posting end date.

Job Summary

Work independently. Provide consultation and instruction to internal personnel regarding performance, financial reporting, benchmarking and advanced report development. Develop data models and identify optimal solutions. Develop, facilitate and lead strategic and collaborative cross-functional implementation plans. Demonstrate superior problem-solving skills and serve as the highest-level resource in that area within the organization. Provide strategic direction and subject matter expertise regarding systems, processes and initiatives and follow through from development to full implementation. Prepare and deliver executive reporting and presentations. Mentor and lead assigned work activities of others within the work group, team, or department.

Job Description

Where Putting the Customer First Powers Everything We Do!

What You'll Do:

• Design, write, and optimize complex queries spanning multiple data marts and tables to extract, join, and reconcile data from disparate source systems.
• Design and build warehouse tables that serve as accurate, well-structured foundations for downstream reporting and analysis.
• Apply Python to support data transformation, process automation, and analytical workflows.
• Leverage artificial intelligence tools and techniques to enhance the speed, quality, and depth of data analysis and reporting.
• Connect and integrate data from multiple sources to build polished, executive-ready Power BI dashboards.
• Partner with stakeholders across the organization to translate business questions into well-structured data models and visualizations.
• Proactively investigate underlying data to identify trends, anomalies, and opportunities for improvement.

What We’re Looking For:

Education/Experience: Bachelor's Degree in Supply Chain Management, Business Finance, Accounting, or related field of study such as Operations Management, Materials Management, or Information Technology. In addition, must have a minimum of 10 years of experience in Supply Chain, Procurement and Fleet or related business category such as Operations Management, Materials Management, or Information Technology.

In lieu of Bachelor’s degree must possess an Associate’s Degree in related field of study, and a minimum of 12 years’ experience in Supply Chain, Procurement and/or Fleet or related business category such as Operations Management, Materials Management, or Information Technology.

In lieu of Associate’s degree must possess a High School Diploma or equivalent, and a minimum of 14 years’ experience in Supply Chain, Procurement and/or Fleet or related business category such as Operations Management, Materials Management, or Information Technology.

Additional Expectations:

• Lead cross-functional teams, identify stakeholders, and network with internal and external organizations.
• Seek to broaden knowledge in areas of the company and industry which will complement acquired expertise.
• Project credibility and competence regarding data analysis Demonstrate excellent verbal and written skills, possess highly-developed presentation skills.
• Demonstrate the highest standards of ethical behavior and support the Company's Corporate Code of Conduct.
• Demonstrate expert level of knowledge of MS-Office skills.

Expected Salary Range:

Expected Salary Range: $100,000.00-$120,000.00/Yr (USD)

Compensation Data:

Compensation Grade: SP20-008

Compensation Range: $98,993.00 - $128,688.00

The Physical Demand Level for this job is: S – Sedentary Work: Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently. (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

In addition to a competitive compensation, AEP offers a unique comprehensive benefits package that aims to support and enhance the overall well-being of our employees.

It is hereby reaffirmed that it is the policy of American Electric Power (AEP) to provide Equal Employment Opportunity in all respects of the employer-employee relationship including recruiting, hiring, upgrading and promotion, conditions and privileges of employment, company sponsored training programs, educational assistance, social and recreational programs, compensation, benefits, transfers, discipline, layoffs and termination of employment to all employees and applicants without discrimination because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, age, veteran or military status, disability, genetic information, or any other basis prohibited by applicable law. When required by law, we might record certain information or applicants for employment may be invited to voluntarily disclose protected characteristics.