Data Engineer IV - IT Enterprise Analytics & Integrations

FirstEnergy - 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 Management team within FirstEnergy's Information Technology group is responsible for the design, development, and enhancement of Data Warehousing and Analytics applications. We are seeking a Data Engineer IV who will play a crucial role in the development of Data Lake and Data Warehouse solutions. This position requires a deep understanding of data architecture, data engineering, data analysis, reporting, and a basic understanding of data science techniques and workflows. The ideal candidate will be a skilled data and software engineer with experience in creating data products that support analytic solutions. As a Data Engineer at FirstEnergy, you will engage in various activities throughout the application development process. This includes conducting requirements analysis in collaboration with Business Systems Analysts, maintaining data warehousing platforms, and architecting applications by making appropriate technological choices. You will define and document logical and physical data models, create Data Lake and Data Warehousing models for reporting or analytics, and help define and build extraction functions to obtain source data. Additionally, you will be responsible for implementing data extraction functions and transformation logic, documenting all design specifications, and developing prototypes as necessary. Effective communication is key in this role, as you will need to explain complex data models and ETL processes to business users. You will foster a culture of sharing, re-use, and operational efficiency of data and analytical solutions. This position offers the opportunity to work remotely within the United States, with certain state restrictions, and requires a commitment to safety and operational excellence.

Responsibilities

• Conduct requirements analysis with Business Systems Analysts to gather functional and non-functional requirements.
• Maintain data warehousing platforms 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.
• Implement data extraction functions and transformation logic, documenting all design and specifications.
• Develop early prototypes for applications as necessary and support complex logic development for business goals.
• Communicate design and logic to business users, explaining data models and ETL processes.

Requirements

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

Nice-to-haves

• Experience with cloud technologies and data integration tools.
• Familiarity with data science techniques and workflows.
• Knowledge of data governance and security best practices.

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.
• Commitment to workforce diversity and inclusion.