Data Engineer IV - IT Enterprise Analytics & Integrations

$96,000 - $178,000/Yr

FirstEnergy - Williamsport, MD

Full-time - Mid Level

Williamsport, MD

Utilities

About the position

FirstEnergy is a forward-thinking electric utility dedicated to safety, reliability, and operational excellence. The Data Engineer IV position is part of the Data Management team within FirstEnergy's Information Technology group, which is responsible for the design, development, and enhancement of Data Warehousing and Analytics applications. The selected candidate will play a crucial role in Data Lake and Data Warehouse development, working closely with Business Systems or Business resources to make appropriate technological choices and architect the required applications. This role 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 is a skilled data and software engineer with experience in creating data products that support analytic solutions. The Data Engineer will engage in various activities during the application development process, including requirements analysis, solutions maintenance, architecture design, analysis and design of data models, building and testing applications, and communicating design and logic to business users. Responsibilities include maintaining data warehousing platforms, decomposing applications into components, defining and documenting logical and physical data models, creating data extraction functions, and developing prototypes as necessary. The role also involves fostering a culture of sharing, re-use, and operational efficiency of data and analytical solutions.

Responsibilities

• Conduct requirements analysis with business teams to document 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, including Data Lake and Data Warehousing models for reporting or analytics.
• Identify source systems and data elements, and build extraction functions for change data capture.
• 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.
• 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 or a similar role.
• Knowledge of Agile/Scrum methodologies, RDBMS, and ETL processes.
• Ability to learn quickly and undertake assignments involving unfamiliar subjects.
• Strong communication skills for conveying complex ideas both verbally and in writing.
• Experience with RDBMS technology including Teradata, SingleStore, Oracle, or SQL Server.
• Knowledge and experience in ETL process development and tuning 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 effectively, 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.
• Experience in working with large datasets and big data technologies.

Benefits

• Competitive salary range of $96k - $178k per year.
• Remote work options available based on business needs (with some state restrictions).
• Opportunities for professional development and career growth.
• Comprehensive health insurance and wellness programs.