Supply Chain Business Analyst at American Electric Power in Columbus, OH

Job description

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

Responsibilities

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

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

Skills

Required

• SQL
• Python
• Power BI
• Data analysis
• Data transformation
• Process automation
• Data modeling
• Data visualization
• MS-Office skills (moderate level)
• Ability to identify stakeholders
• Excellent verbal and written skills

Benefits

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