Distribution Modeling & Analysis Engineer-Senior

AEP Service Corporation; United States; On-site; USD 88,000 - 129,000; Full time

Benefits offered by this job

Benefits package

Job summary

AEP Service Corporation is seeking a data governance and reporting specialist to lead data quality initiatives for distribution system and DER data. You will develop SQL queries, dashboards, and reports to support internal and external stakeholders.

The role requires proficiency in SQL, Python, SAS, Power BI, Collibra, and a solid understanding of data governance within the electric utility sector.

Qualifications

• Bachelor’s degree in engineering or related field preferred.
• Experience in data governance, data quality, and the electric utility industry encouraged.
• Strong understanding of programming concepts and database structures.

Responsibilities

• Lead data governance and reporting activities for distribution system and DER data.
• Develop, maintain, and optimize SQL queries, scripts, dashboards, and reports.
• Collaborate with business units to identify and resolve data quality issues.

Skills

SQL proficiency

Python

SAS

Power BI

Collibra

Data governance

Data quality

Electric utility industry

Education

Bachelor’s degree in engineering

Tools

Power BI

Python

SAS

Collibra

Job description

Job Summary

Responsible to the assigned supervisor for performing intermediate level engineering work activities and projects requiring the application of engineering knowledge in a safe, effective, efficient and economic accomplishment of assigned objectives.

Job Description

What you’ll do: The Distribution Modeling and Analysis department is seeking a motivated team member to lead data governance and reporting activities related to distribution system and distributed energy resource (DER) data. As distribution planning criteria continue to evolve and DER penetration increases, this role will help meet the growing demand for accurate, reliable, and effective data reporting. Candidates with experience in data governance, data quality, and the electric utility industry are encouraged to apply. Success in this role requires a strong understanding of programming concepts and database structures, including intermediate to advanced proficiency in writing SQL queries to research, analyze, and validate data. Experience with Python, SAS, Collibra, and Power BI is highly desirable and will enhance the candidate's ability to support evolving data governance and reporting needs.

Key responsibilities

• Develop, implement, and continuously improve data governance frameworks, standards, and processes to support evolving business and regulatory requirements.
• Establish and maintain an understanding of distribution system and distributed energy resource (DER) data sources, associated systems, and the interactions between those systems.
• Develop and maintain SQL queries, scripts, dashboards, and reports to support data analysis, reporting requirements, and internal and external stakeholder requests.
• Partner with business units and subject matter experts to identify, investigate, and resolve distribution system and DER data quality issues.
• Lead initiatives to enhance, automate, and scale data quality monitoring, data governance, and reporting capabilities.
• Develop and deliver training, documentation, and knowledge‑sharing resources that promote the effective use of data analytics and reporting tools across the organization.
• Collaborate with Distribution Planning, Transmission Planning, Distribution Operations, Operating Company, and Information Technology teams to support data governance, reporting, and data quality initiatives.

Technical Expertise

Possesses intermediate level knowledge and performs varied assignments with proficiency in the application of theory and analytical techniques to solve diverse problems and complete extensive analysis. Demonstrates competency in analytical techniques necessary to handle assignments of moderate complexity. Demonstrates ability to understand interrelationship between systems and component equipment. Demonstrate ability to analyze and recommend enhancements to business processes.

Leadership & Guidance

Coordinates work activities of others within the work group, department, or other corporate entity as necessary to complete routine activities. Performs routine engineering activity with minimum direction from higher-level employees. Follows policies, practices, standards and rules of the company and those regulations and procedures required by external agencies.

Planning & Organization Ability

Coordinates the development of input necessary to prioritize deliverables and forecast needs for the routine projects, improvements requisitions, etc. Uses scheduling techniques (CPM, PERT, flow charts, etc.) for planning activities. Initiates corrective action when project objectives are not being met.

Problem Solving & Initiative

Resolves and initiates solutions to routine problems which usually require additional definition/clarification before analysis can begin. Demonstrates ability to identify problems that are beyond the normal routine. Demonstrates ability and desire to seek out opportunities and embrace new ideas and approaches.

Communication

Develops, reviews, or presents technical reports such as improvement requisitions, studies, and analyses in as clear, concise and effective fashion.

Interpersonal Skills

Is an active team member. Networks with peers inside and outside the AEP system. Identifies key stakeholders. Uses informal network to get things done. Resolves conflict, builds consensus.

Decision Making

Makes decisions subject to review within established policies and procedures. Makes decisions that affect the work of the team. Aware of risks. Demonstrates the ability to extrapolate beyond known facts to reach logical conclusions.

Business Awareness & Characteristics

Understands AEP’s organizational structure and the specific role and responsibility of their individual organizational unit. Is proficient in the application and use of analysis techniques in problem solving. Develops an understanding of utility regulation.

What we’re looking for

This is a single vacancy posted in a range. Please note that Education and/or relevant Experience will be used to determine the appropriate salary and salary grade. General Electrical, computer or system engineering degree or related field preferred. Candidates with experience in data governance, data quality, and the electric utility industry are encouraged to apply. Strong understanding of programming concepts and database structures, including intermediate to advanced proficiency in writing SQL queries to research, analyze, and validate data required. Experience with Python, SAS, Collibra, and Power BI is highly desirable.

Engineer SG7 Education/Experience

Has typically acquired a Bachelor’s degree in engineering in a program accredited by ABET* along with two or more years of related engineering experience. Individuals with a Master’s degree in engineering from an engineering program accredited by ABET* may be considered for entry into the organization at this level. Individuals with a Bachelor’s degree in Engineering Technology can satisfy this degree requirement, if they obtain a certified Professional Engineering (PE) license. Acceptable alternative: Bachelor's degree in engineering (non-ABET) plus a Master’s degree or PhD in engineering from a university with an ABET accredited Bachelor’s program. Has typically acquired 2 or more years of related engineering experience along with a bachelor’s degree in engineering in a program accredited by ABET*.

Engineer Senior SG8

Has typically acquired 4 or more years of related engineering experience along with a bachelor’s degree in engineering in a program accredited by ABET*. Or 2 years of related engineering experience along with a master’s degree or PhD in engineering from a program accredited by ABET*. Registration as a Professional Engineer (PE) in any U.S. state or Puerto Rico is encouraged and preferred. Confirmation is required to ensure the PE obtained in Puerto Rico aligns with NCEES standards. Acceptable alternative is: Bachelor's degree in engineering (non-ABET) plus a master’s degree or PhD in engineering from a university with an ABET accredited bachelor's program.

Benefits

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.

Company culture

Where Putting the Customer First Powers Everything We Do At AEP, we’re more than just an energy company — we’re a team of dedicated professionals committed to delivering safe, reliable, and innovative energy solutions. Guided by our mission to put the customer first, we strive to exceed expectations by listening, responding, and continuously improving the way we serve our communities. If you're passionate about making a meaningful impact and being part of a forward-thinking organization, this is the company for you!

Compensation

Compensation Grade: SP20-007
Compensation Range: $87,633.00 - $128,688.00

Physical Demand Level

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 Opportunity Statement

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 Statement

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. It’s 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.