Supply Chain Business Analyst

AEP Service Corporation; United States; On-site; USD 75,000 - 93,000; Full time

Job summary

American Electric Power is seeking a data analyst with strong SQL, Python, and Power BI skills to support market research, benchmarking, and financial reporting. The role involves building data models, dashboards, and automated workflows, with cross-functional collaboration across the organization.

The position emphasizes collaborative problem-solving, adherence to controls, and providing insights for executive presentations. Strong analytical ability and effective communication are essential.

Qualifications

• Bachelor's degree in Supply Chain Management, Business Finance, Accounting, or related field.
• Minimum 3 years of experience in Supply Chain, Procurement and Fleet or related area.
• In lieu of degree, 5 years of relevant experience accepted.
• In lieu of Associate's degree, 7+ years of related experience accepted.

Responsibilities

• Design, write, and optimize complex queries across data marts and tables.
• Design and build warehouse tables for reporting and analysis.
• Apply Python to transform data and automate processes.
• Use AI tools to enhance data analysis and reporting.
• Create executive-ready Power BI dashboards from multiple sources.
• Collaborate with stakeholders to translate business questions into data models.

Skills

Analytical thinking

SQL

Python

Power BI

Data visualization

Stakeholder communication

Education

Bachelor's degree in related field

Associate's Degree (in lieu of Bachelor's)

High School Diploma (in lieu of Associate)

Tools

SQL databases

Power BI (tool)

Job description

Job Posting End Date Please note the job posting will close on the day before the posting end date.

Job Summary

Work under some supervision. Assist with market research studies and analysis including benchmarking, financial reporting, and surveys. Apply advanced analytical and technical skills (such as SQL, Python, Power BI) for comparing basic, complex and differing specifications and solutions. Assist in maintaining planning documentation. Identify issues and take responsibility for resolution; demonstrate the ability to encourage others in collaborative problem-solving. Support systems and processes in accordance with established procedures and controls with minimum direction. Provide information and assistance in the development of presentations. Understand the components of the organization and its stakeholders and act as a primary point of contact and knowledge for issues.

ESSENTIAL JOB FUNCTIONS

• 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.

MINIMUM REQUIREMENTS

• 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 3 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 5 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 7 years' experience in Supply Chain, Procurement and/or Fleet or related business category such as Operations Management, Materials Management, or Information Technology.

OTHER REQUIREMENTS

• Physical demand level is Sedentary.


• Understand the components of the organization and its stakeholders.


• Possess teamworking skills such as collaboration, commitment, active listening and acknowledgement; have the ability to identify stakeholders.


• Seek to broaden knowledge in areas of the company and industry which will complement acquired expertise.


• Demonstrate excellent verbal and written skills.


• Demonstrate the highest standards of ethical behavior and support the Company's Corporate Code of Conduct.


• Demonstrate moderate level of knowledge of MS-Office skills.

Compensation Data

Compensation Grade: SP20-006

Compensation Range: $74,551.00 - $93,188.50

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.

Equal Employment Opportunity

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.

Company Profile

At American Electric Power, we provide more than electricity to our millions of customers - we energize possibilities. We're redefining the future of energy by reducing our carbon footprint, empowering the communities we serve and building an engaged, talented workforce. All while delivering the reliable service our customers expect. Its an exciting time in the energy industry. Are you ready to be part of it? We’re looking for team members to help create the grid of the future. Learn more about our commitment to creating a supportive, inclusive work culture that values different experiences.