Senior Data Engineer

Company Summary Statement

As one of the largest investor-owned utility companies in the United States, PPL Corporation (NYSE: PPL), is committed to creating long-term, sustainable value for our 3.5 million customers, our shareowners and the communities we serve. Our high-performing regulated utilities PPL Electric Utilities, Louisville Gas and Electric, Kentucky Utilities and Rhode Island Energy provide an outstanding experience for our customers, consistently ranking among the best utilities in the nation. PPLs companies are also addressing challenges head-on by investing in new infrastructure and technology that is creating a smarter, more reliable and resilient energy grid. We are committed to doing our part to advance a cleaner energy future and drive innovation that enables us to achieve net-zero carbon emissions by 2050 while maintaining energy reliability and affordability for the customers and communities we serve. PPL is a positive force in the cities and towns where we do business, providing support for programs and organizations that empower the success of future generations by helping to build and maintain strong, diverse communities today.

Overview

Data Analysis: The Data Engineer designs and implements processes and layouts for complex, large-scale data sets used for modeling, data mining, and research purposes. This person is expected to maintain a data knowledgebase (e.g., data dictionary).

Business Insights: The Data Engineer empowers business partners to turn information into action by building tools, developing protocols, and defining metrics for forward-looking data collection and analysis. The Senior level performs assigned tasks under minimal guidance from supervisor.

This position is hybrid on-site only with working locations in Louisville, KY; Allentown, PA ; Providence, RI.

Responsibilities

Performs a variety of complex assignments (may lead some projects) and analyzes and solves complex problems in the below areas.

Data Design

Assist data architect in translating business requirements into design specifications

Create source mappings, business definitions, measures, dimensions, visualization designs, test plans, and test cases

Conduct data studies and data discovery around new data sources or new uses for existing data sources

Interpret and analyze data and generate reports as needed to understand flow of data

Apply quantitative methods to derive actionable insights and outcomes from data

Data Management:

Conduct data studies and data discovery around new data sources or new uses for existing data sources

Assist in documenting meta data information including data types, lengths, and conversion functions

Assist in analyzing and researching new and existing products, procedures, and/or workflows for data management

Execute activities pertaining to end-to-end data set identification, development, and implementation according to the guidance from Data Scientists

Support data collection, integration and retention requirements based on the input collected with the business

Gather and process data from the Transmission, Distribution, Customer Service, and EU Service functions, and transform them into data products

Implement statistical data quality procedures around new data sources

Data Integration:

Develop and modify functions, programs, routines, and stored procedures to export, transform, and load data

Resolve integration and data mapping issues and discrepancies as objectives change

Assist in resolving data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies collaborating with subject matter experts (SMEs)

Master Data Management:

Execute on all aspects of MDM architecture (MDM data model, SAP MDM, MDM tools, MDM data integration, master data quality, MDM operations, master data security, )

Maintain data warehouse performance by identifying and resolving data conflicts

Adhere to data / information quality practices

Conduct data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker access

Ensures quality of master data in key systems, as well as development and documentation of processes with other functional data owners to support ongoing maintenance and data integrity

Data Governance:

Adhere to data strategy, policies, controls, and programs to ensure the enterprise data is accurate, complete, secure, and reliable

May be assigned an Electric Utilities emergency and storm role. This is a special assignment that comes into play during storms and other emergencies when the company needs to restore power or respond to other issues affecting customer service. This role may necessitate the need to work after hours, outside of your normal schedule.

The company reserves the right to determine if this position will be assigned to work on-site remotely or a combination of both. Assigned Work location may change. In the case of remote work, physical presence in the office/on-site may be required to engage in face-to-face interaction and coordination of work among direct reports and co-workers.

Qualifications

Bachelor's degree and 5 years of related work experience OR 8 years of related work experience

Awareness of industry leading data quality and data protection management practices

Awareness of data governance practices, business and technology issues related to management of enterprise information assets and approaches related to data protection

Awareness of data related government regulatory requirements and emerging trends and issues

Proven ability to prioritize and execute tasks

Highly self-motivated and directed with attention to detail

Easily adapts to changing circumstances

Understands business goals and strategic priorities

Preferred Qualifications:

Experience supporting fast-changing business organizations

Bachelor's degree and 5 years of related work experience OR 8 years of related work experience

Awareness of industry leading data quality and data protection management practices

Awareness of data governance practices, business and technology issues related to management of enterprise information assets and approaches related to data protection

Awareness of data related government regulatory requirements and emerging trends and issues

Proven ability to prioritize and execute tasks

Highly self-motivated and directed with attention to detail

Easily adapts to changing circumstances

Understands business goals and strategic priorities

Preferred Qualifications:

Experience supporting fast-changing business organizations

Performs a variety of complex assignments (may lead some projects) and analyzes and solves complex problems in the below areas.

Data Design

Assist data architect in translating business requirements into design specifications

Create source mappings, business definitions, measures, dimensions, visualization designs, test plans, and test cases

Conduct data studies and data discovery around new data sources or new uses for existing data sources

Interpret and analyze data and generate reports as needed to understand flow of data

Apply quantitative methods to derive actionable insights and outcomes from data

Data Management:

Conduct data studies and data discovery around new data sources or new uses for existing data sources

Assist in documenting meta data information including data types, lengths, and conversion functions

Assist in analyzing and researching new and existing products, procedures, and/or workflows for data management

Execute activities pertaining to end-to-end data set identification, development, and implementation according to the guidance from Data Scientists

Support data collection, integration and retention requirements based on the input collected with the business

Gather and process data from the Transmission, Distribution, Customer Service, and EU Service functions, and transform them into data products

Implement statistical data quality procedures around new data sources

Data Integration:

Develop and modify functions, programs, routines, and stored procedures to export, transform, and load data

Resolve integration and data mapping issues and discrepancies as objectives change

Assist in resolving data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies collaborating with subject matter experts (SMEs)

Master Data Management:

Execute on all aspects of MDM architecture (MDM data model, SAP MDM, MDM tools, MDM data integration, master data quality, MDM operations, master data security, )

Maintain data warehouse performance by identifying and resolving data conflicts

Adhere to data / information quality practices

Conduct data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker access

Ensures quality of master data in key systems, as well as development and documentation of processes with other functional data owners to support ongoing maintenance and data integrity

Data Governance:

Adhere to data strategy, policies, controls, and programs to ensure the enterprise data is accurate, complete, secure, and reliable

May be assigned an Electric Utilities emergency and storm role. This is a special assignment that comes into play during storms and other emergencies when the company needs to restore power or respond to other issues affecting customer service. This role may necessitate the need to work after hours, outside of your normal schedule.

The company reserves the right to determine if this position will be assigned to work on-site remotely or a combination of both. Assigned Work location may change. In the case of remote work, physical presence in the office/on-site may be required to engage in face-to-face interaction and coordination of work among direct reports and co-workers.

Remote Work

The company reserves the right to determine if this position will be assigned to work on-site, remotely, or a combination of both. Assigned work location may change. In the case of remote work, physical presence in the office/on-site may be required to engage in face-to-face interaction and coordination of work among direct reports and co-workers.

Equal Employment Opportunity

Our company is an equal opportunity, affirmative action employer dedicated to diversity and the strength it brings to the workplace. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, national origin, protected veteran status, sexual orientation, gender identify, genetic information, disability status, or any other protected characteristic.