Supply Chain Business Analyst

AEP Service Corporation; Columbus (OH); On-site; USD 75,000 - 93,000; Full time

Job summary

AEP Service Corporation is seeking a data analytics professional to design and optimize queries across multiple data marts, build robust warehouse tables, and automate data workflows with Python. You will develop executive-ready Power BI dashboards by connecting diverse data sources and partnering with stakeholders to translate business questions into actionable insights.

The role emphasizes collaboration, rigorous data validation, and adherence to established controls, while supporting internal

Qualifications

• Bachelor's degree in Supply Chain, Finance, Accounting or related field.
• Alternative credentials accepted with years of relevant experience.
• Strong data analysis, problem solving, and communication skills.

Responsibilities

• Design, write, and optimize complex queries across data marts.
• Build warehouse tables for reliable downstream reporting.
• Apply Python to automate data transformations and workflows.
• Develop executive-ready Power BI dashboards with sources integrated.
• Collaborate with stakeholders to translate questions into data models.

Skills

Analytical thinking

Communication

Education

Bachelor's degree in related field

Associate’s Degree + 5+ yrs experience

High School Diploma + 7+ yrs experience

Tools

SQL

Python

Power BI

Job description

Job Posting End DatePlease note the job posting will close on the day before the posting end date.Job SummaryWork 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.Job DescriptionESSENTIAL 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 SedentaryUnderstand 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 DataCompensation Grade:SP20-006Compensation Range:$74,551.00 - $93,188.50The 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.Hear about it first! Get job alerts by email. Log in to your Candidate Home Account today! If you don't have an account, you can create one.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.