Data Engineer

JOB DESCRIPTION FirstEnergy FirstEnergy at a Glance We are a forward-thinking electric utility powered by a diverse team of employees committed to making customers' lives brighter, the environment better and our communities stronger. FirstEnergy (NYSE: FE) is dedicated to safety, reliability and operational excellence. Headquartered in Akron, Ohio, FirstEnergy includes one of the nation's largest investor-owned electric systems, more than 24,500 miles of transmission lines that connect the Midwest and Mid-Atlantic regions, and a regulated generating fleet with a total capacity of 3,780 megawatts. About the Opportunity This is an open position with FirstEnergy Service Co., a subsidiary of FirstEnergy Corp. [SC00] The ability to work remotely within the United States may be available based on business need. This option is not available in the states of California, Colorado, Illinois, Kentucky, Massachusetts, Montana, Nebraska, New York, Oregon or Washington at this time. The Data Management team within FirstEnergy's Information Technology group is responsible for the design, development and enhancement of Data Warehousing and Analytics applications. We seek an individual that can confidently play the role of a Data Engineer during Data Lake / Data Warehouse development. A Data Engineer at FirstEnergy works closely with Business Systems or Business resources to make appropriate technological choices; proceeds to architect and design the required application. This role requires deep understanding of data architecture, data engineering, data analysis, reporting, and a basic understanding of data science techniques and workflows. The ideal candidate is a skilled data and software engineer with experience creating data products supporting analytic solutions. Responsibilities Include: A Data Engineer at FirstEnergy typically performs the following activities during the application development process: * Requirements analysis: In conjunction with a Business Systems team Analyst or independently, work with the business to collect, document and review functional and non-functional requirements for the application. * Solutions maintenance: Responsible for maintaining the data warehousing platforms and all components of MemSQL/SingleStore, Teradata and legacy Oracle Data Marts, Azure Synapse Notebooks/Pipelines. * Architect: In conjunction with a Business Systems team Analyst or independently, decompose the application into various components and make appropriate technological choices in the implementation and integration of the components also giving due consideration to availability, recovery, security, performance, and governance requirements. * Analysis and design: Define and document the logical data model and create the physical data model in a database. Define and create Data Lake and Data Warehousing models for reporting or analytics. Identify the various contributing source systems and source data elements; help define & build the extraction functions to obtain the source data supporting change data capture. Define and document the various data transformations that must occur during this process. Incorporate maintainability, security and performance requirements into the design and specifications. * Build and test: Create physical data model. Implement data extraction functions and transformation logic. Document all design and specifications. Document metadata information. Develop early prototypes for the application, as necessary. Support the development of complex logic or functions necessary that help the organization's business achieve their goals. * Communicate design and logic to businesApply here: https://www.aplitrak.com/?adid=YmJnZW5lcmljLjQ1NDY4LjEwNTA4QGZpcnN0ZW5lcmd5Y29tcC5hcGxpdHJhay5jb20