Sr. Data Engineer

$100,000 - $150,000/Yr

Exelon - Newark, DE

Full-time - Mid Level

Hybrid - Newark, DE

10,001+ employees

Utilities

About the position

Join Exelon's Work and Asset Management team to help set direction for the Enterprise Asset Management (EAM) Platform as part of the Solution Delivery Team. The EAM Transformation program is a multi-year program intended to transform Exelon's Work, Asset and Supply business capabilities and deliver the Enterprise Asset Management solution. The Sr. Data Engineer will be responsible for leading the effort to capture the data requirements and design in support of the implementation of EAM products to meet the intended business objectives. The role will lead a team of data engineers and collaborate closely with business stakeholders and project team members to document the data requirements needed for data migration, integrations, and reporting and analytics to support the EAM transformation project. This is a hybrid position (in-office with remote flexibility). Employees are required to be in office at least three days per week (Tuesday, Wednesday, and Thursday).

Responsibilities

• Lead data requirements gathering sessions to document requirements needed for the EAM products and platform.
• Lead a small group of IT data engineers who provide expertise in documentation of data requirements and design.
• Collaborate with business stakeholders and project team members to understand business outcomes and alignment to data requirements.
• Partner with technical architects, EU analytics team and other IT and business teams to implement the optimal solutions.
• Perform, manage and appropriately document work activities relating to projects, sub-projects, or processes.
• Plan, design, and build high quality IT software solutions in accordance with IT project management standards.
• Assist others in planning and prioritizing work and work schedule.
• Create documentation for products and services.
• Use best practices to improve products and services provided to business unit partners.
• Maintain and enhance engagement with business and IT partners and other stakeholders.
• Establish positive team environment by proactively assisting and training less experienced personnel.
• Provide performance and development feedback as required.
• Maintain technical knowledge and business acumen within own discipline or function.

Requirements

• Bachelor's degree in Computer Science or related discipline and 4-7 years' experience or in lieu of degree, 7+ years equivalent combination of education and work experience.
• Appropriate technical skills and experience with tools used for data modelling, process modelling, documenting functional and technical requirements.
• Strong knowledge of business practices, processes, data and applications.
• Experience leading small IT projects or sub-teams and knowledge of IT project management.
• Strong problem solving and analysis ability.
• Excellent communications skills (written and verbal).
• Strong facilitation/negotiation skills.
• Strong presentation skills.
• Ability to work with remote project teams.

Nice-to-haves

• Experience writing technical design specifications for data integrations and data transformations with structured and unstructured data.
• Experience with Scrum development methodology.
• Experience with writing business cases.
• Experience in capturing, analyzing and translating business needs into functional IT requirements.
• Experience developing data integrations and data transformations with structured and unstructured data.
• SQL (DML, DCL, DDL) expertise with Oracle 11g through 12c and Microsoft SQL Server 2008r2 through 2016.
• Experience with the setup and configuration of Automic UC4 scheduler on RHEL, Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB), Oracle Business Intelligence (OBI), Oracle Enterprise Manager (OEM), Oracle HTTP Server (OHS), WebLogic, Informatica, Business Objects, SAS software for data analytics, Kafka, Nifi, UC4, Red Hat Enterprise Linux, Application re-engineering, data modeling and performance tuning.
• Architecture and design for application disaster recovery and high availability, HP ALM, Microsoft Azure DevOps.
• Customer Information Systems (for example: CIMs, CC&B, SAP CRM&B).
• AMI Meter Data Management Systems (for example: Oracle Utilities MDM, Itron IEE).
• Geographic Information Systems (for example: GE Smallworld).
• Outage Management Systems, Itron/SSN UtilityIQ, Xylem/Sensus AMI, OSI Soft PI Historian.
• Experience managing IT projects using Agile/Scrum and waterfall methodologies.

Benefits

• Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors: USD $100,000.00/Yr. - USD $150,000.00/Yr.
• Annual Bonus for eligible positions: 15%
• 401(k) match and annual company contribution
• Medical, Dental and Vision Insurance
• Life and disability insurance
• Generous paid time off options, including vacation, sick time, floating and fixed holidays, maternity leave and bonding/primary caregiver leave or parental leave (based on position)
• Long Term Incentive Plan for eligible positions
• Wellbeing programs such as tuition reimbursement, adoption assistance and fitness reimbursement
• Referral bonus program
• And much more