Data Engineer IV - IT Enterprise Analytics & Integrations

Jersey Central Power & Light - Morristown, NJ

Full-time - Mid Level

Morristown, NJ

Utilities

About the position

FirstEnergy is a forward-thinking electric utility dedicated to safety, reliability, and operational excellence. The Data Engineer IV position within the IT Enterprise Analytics & Integrations team is crucial for the design, development, and enhancement of Data Warehousing and Analytics applications. This role requires a deep understanding of data architecture, engineering, and analysis, as well as a basic understanding of data science techniques and workflows. The Data Engineer will work closely with Business Systems or Business resources to make appropriate technological choices and architect the required applications. The responsibilities of the Data Engineer include conducting requirements analysis, maintaining data warehousing platforms, and architecting applications by decomposing them into various components. The role also involves defining and documenting logical and physical data models, creating Data Lake and Data Warehousing models for reporting or analytics, and identifying source systems and data elements. The Data Engineer will implement data extraction functions, transformation logic, and document all design specifications. Additionally, the position requires effective communication with business users to explain data models and the ETL process, fostering a culture of sharing and design for scale stability. This position offers the opportunity to work remotely within the United States, depending on business needs, although certain states are excluded from this option. The ideal candidate will be a skilled data and software engineer with experience in creating data products that support analytic solutions, contributing to the overall success of FirstEnergy's mission to enhance customer experiences and strengthen communities.

Responsibilities

• Conduct requirements analysis with Business Systems team or independently to collect, document, and review functional and non-functional requirements.
• Maintain data warehousing platforms and components including MemSQL/SingleStore, Teradata, and legacy Oracle Data Marts, Azure Synapse Notebooks/Pipelines.
• Architect applications by decomposing them into components and making technological choices considering availability, recovery, security, performance, and governance.
• Define and document logical and physical data models, and create Data Lake and Data Warehousing models for reporting or analytics.
• Identify contributing source systems and data elements, and help define and build extraction functions for change data capture.
• Define and document data transformations required during the data processing.
• Create physical data models and implement data extraction functions and transformation logic.
• Document all design specifications and metadata information, and develop early prototypes as necessary.
• Support the development of complex logic or functions to help achieve business goals.
• Communicate design and logic to business users, explaining data models and the ETL process.

Requirements

• Deep understanding of data architecture and data engineering principles.
• Experience in data analysis and reporting.
• Basic understanding of data science techniques and workflows.
• Proficiency in creating data products that support analytic solutions.
• Experience with data warehousing platforms such as MemSQL/SingleStore, Teradata, and Oracle Data Marts.
• Familiarity with Azure Synapse Notebooks/Pipelines.

Nice-to-haves

• Experience with cloud-based data solutions.
• Knowledge of data governance and security best practices.
• Familiarity with agile development methodologies.

Benefits

• Health insurance coverage
• 401k retirement savings plan
• Paid holidays
• Flexible scheduling options
• Professional development opportunities