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