Data Engineer III - IT Enterprise Analytics & Integrations - Greensburg Corporate Center

FirstEnergy - Akron, OH

Full-time - Mid Level

Akron, OH

Utilities

About the position

The Data Engineer position at FirstEnergy involves working within the Data Management team of the Information Technology group. The role focuses on the design, development, and enhancement of Data Warehousing and Analytics applications. The Data Engineer will collaborate with business resources to make technological choices and architect the necessary applications, requiring a deep understanding of data architecture, engineering, analysis, and reporting.

Responsibilities

• Conduct requirements analysis with business teams to gather functional and non-functional requirements.
• Maintain data warehousing platforms and components including MemSQL/SingleStore, Teradata, and legacy Oracle Data Marts.
• 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 for Data Lakes and Data Warehousing.
• Identify source systems and data elements, and build extraction functions for change data capture.
• Document data transformations and ensure maintainability, security, and performance in designs.
• Create physical data models and implement data extraction functions and transformation logic.
• Develop prototypes and support complex logic development for business goals.
• Communicate design and logic to business users, explaining data models and ETL processes.
• Foster a culture of sharing, re-use, and operational efficiency in data solutions.

Requirements

• Bachelor's degree in a quantitative discipline such as Computer Science or related field.
• 5 years of related experience in data engineering or a similar role.
• Working knowledge of Agile/Scrum methodologies, RDBMS, and ETL processes.
• Experience with development and tuning on RDBMS technology including Teradata, SingleStore, Oracle, or SQL Server.
• Knowledge of ETL process development and tuning using tools like PowerCenter or Informatica Data Replication.
• Experience in creating and documenting ER and Dimensional models, preferably with ERWIN.
• Familiarity with the Kimball methodology for designing Enterprise Data Warehouses and Data Marts.
• Ability to prioritize, plan activities, multitask, and meet deadlines.
• Willingness to mentor less experienced personnel and support team members.

Nice-to-haves

• Experience with data science techniques and workflows.
• Ability to work flexible hours and participate in on-call rotation.

Benefits

• Competitive pay plus incentive compensation.
• Company-sponsored pension plan.
• 401(k) savings plan with matching employer contribution.
• Choice of medical, prescription drug, dental, vision, and life insurance programs.
• Skills development training with tuition reimbursement.