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 specificationsCreate source mappings, business definitions, measures, dimensions, visualization designs, test plans, and test casesConduct data studies and data discovery around new data sources or new uses for existing data sourcesInterpret and analyze data and generate reports as needed to understand flow of dataApply 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 sourcesAssist in documenting meta data information including data types, lengths, and conversion functionsAssist in analyzing and researching new and existing products, procedures, and/or workflows for data managementExecute activities pertaining to end-to-end data set identification, development, and implementation according to the guidance from Data ScientistsSupport data collection, integration and retention requirements based on the input collected with the businessGather and process data from the Transmission, Distribution, Customer Service, and EU Service functions, and transform them into data productsImplement statistical data quality procedures around new data sources

Data Integration:

Develop and modify functions, programs, routines, and stored procedures to export, transform, and load dataResolve integration and data mapping issues and discrepancies as objectives changeAssist 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 conflictsAdhere to data / information quality practicesConduct data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker accessEnsures 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 experienceAwareness of industry leading data quality and data protection management practicesAwareness of data governance practices, business and technology issues related to management of enterprise information assets and approaches related to data protectionAwareness of data related government regulatory requirements and emerging trends and issuesProven ability to prioritize and execute tasksHighly self-motivated and directed with attention to detailEasily adapts to changing circumstancesUnderstands business goals and strategic prioritiesPreferred Qualifications:Experience supporting fast-changing business organizations