Strategic Supply Chain Analytics & Insights Analyst

AEP; Columbus, Northern (OH, KY); Hybrid; USD 75,000 - 93,000; Full time

Job summary

AEP in Columbus, OH is seeking a Supply Chain Business Analyst to analyze data, design queries, and support reporting initiatives. You will work with SQL, Python, and Power BI to transform complex data into actionable insights.

The role emphasizes collaboration across teams to identify trends and improve processes. This position partners with stakeholders to optimize systems, build scalable data models, and deliver executive dashboards while following established controls and procedures.

Qualifications

• Bachelor’s degree in Supply Chain, Finance, Accounting, IT, or related field.
• 3+ years in Supply Chain, Procurement, or IT-related roles.
• Strong SQL, Python, and data visualization skills.
• Ability to translate business questions into data models.

Responsibilities

• Design, write, and optimize complex SQL queries across data marts.
• Build warehouse tables for accurate downstream reporting.
• Apply Python for data transformation and automation.
• Develop Power BI dashboards with executive-ready visuals.
• Collaborate with stakeholders to translate questions into data models.

Skills

SQL

Python

Power BI

Data analysis

Education

Bachelor's degree in related field

Associate’s degree in related field

High School Diploma or equivalent

Tools

Power BI

SQL Server

Excel

Job description

AEP in Columbus, OH is seeking a Supply Chain Business Analyst to analyze data, design queries, and support reporting initiatives. You will work with SQL, Python, and Power BI to transform complex data into actionable insights.

The role emphasizes collaboration across teams to identify trends and improve processes. This position partners with stakeholders to optimize systems, build scalable data models, and deliver executive dashboards while following established controls and procedures.