Job Information
PPL Corporation Senior Data Engineer in Louisville, Kentucky
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. PPL’s 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.
PPL Corporation
-
- PPL Corporation Jobs