Sr. Data Engineer

$100,000 - $150,000/Yr

Exelon - Oakbrook Terrace, IL

Full-time - Mid Level

Hybrid - Oakbrook Terrace, IL

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 initiative aimed at transforming Exelon's Work, Asset and Supply business capabilities and delivering the Enterprise Asset Management solution. The Sr. Data Engineer will lead the effort to capture data requirements and design in support of the implementation of EAM products to meet business objectives. This role involves leading a team of data engineers and collaborating 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. The position is hybrid, requiring in-office attendance 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.
• 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 optimal solutions.
• Perform, manage, and 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 schedules.
• Create documentation for products and services and improve products and services provided to business unit partners.
• Maintain and enhance engagement with business and IT partners and other stakeholders.
• Establish a positive team environment by assisting and training less experienced personnel.
• Provide performance and development feedback as required.

Requirements

• Bachelor's degree in Computer Science or related discipline and 4-7 years' experience in data warehouse design, business intelligence reporting, Customer Information Systems, Meter Data Management Systems, and/or Outage Management Systems, 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