Exelon

Sr Data Engineer II

LocationOakbrook Terrace, IL
Job TypeFull-time
Salary$109,600-$164,400

About This Job

Who We Are: We're powering a cleaner, brighter future.


Exelon is leading the energy transformation, and we're calling all problem solvers, innovators, community builders and change makers. Work with us to deliver solutions that make our diverse cities and communities stronger, healthier and more resilient.


We're powered by purpose-driven people like you who believe in being inclusive and creative, and value safety, innovation, integrity and community service. We are a Fortune 200 company, 19,000 colleagues strong serving more than 10 million customers at six energy companies - Atlantic City Electric (ACE), Baltimore Gas and Electric (BGE), Commonwealth Edison (ComEd), Delmarva Power & Light (DPL), PECO Energy Company (PECO), and Potomac Electric Power Company (Pepco).


In our relentless pursuit of excellence, we elevate diverse voices, fresh perspectives and bold thinking. And since we know transforming the future of energy is hard work, we provide competitive compensation, incentives, excellent benefits and the opportunity to build a rewarding career.


Are you in? Primary Purpose: PRIMARY PURPOSE OF POSITION Lead activities relating to designing, building, testing, implementing, and maintaining solutions, products, and processes under the guidance of a Principal Data Engineer or Manager. Coach and/or mentor less experienced team members.

Primary Duties: PRIMARY DUTIES AND ACCOUNTABILITIES* Plan all tasks within a SDLC phase including estimating, scope definition and work plan development. Coordinates planning, design and production of deliverables for the training phase. Sought by others for advice. Assists in reviewing deliverables of the SDLC phase. Develops accurate budgets and schedules tasks/staffing. Participates in the integration of this phase to others. Reviews all tasks within a phase to ensure overall quality and accuracy. (System Development Life Cycle) (40%)

Maintain and enhance engagement with business and IT partners and other stakeholders (20%)
Create documentation for products and services. Use best practices to improve products and services provided to business unit partners, and monitor adherence within Team/Group to standards as defined within the Management Model (15%)
Establish positive team environment by assisting and training less experienced personnel. (15%)
Proactively build and develop others' technical knowledge and business acumen (10%)

Job Scope: JOB SCOPE

�Solves moderate to highly complex problems, inclusive of partner with vendors and other IT professionals to do so. (Critical Thinking & Problem Solving) �Can function as a liaison with database administration to communicate data requirements that must be implemented in a DBMS. Has knowledge of at least one DBMS. Able to code and implement extensions to a data dictionary or repository. (Data Warehouse) �Develops security policies and guidelines for users and management. Guides the development of business rules of use as they relate to data security. Creates procedures for data access, protection, and backup. Works closely with cyber threat intelligence analysts, cyber forensics analysts and incident response teams to understand how their challenges can be addressed with data analysis and data science efforts. (Data Security) �Independently makes informed decisions on monitoring settings such as sample size, level of criticality, and self-healing opportunities. (Troubleshooting & Monitoring) �Contributes to strategic planning in areas which require expert Big Data knowledge and experience. Participates in advanced technology efforts for the company, evaluating and testing new products to determine their value and applicability to the organization. Often takes a lead role in critical situations where there is a need to apply knowledge of Big Data technological trends, emerging technology and/or new tools and products. Successfully selects and implements Big Data technology to meet requirements of state-of-the-art systems and projects. (Big Data Technologies) �Drives innovation process with regular evaluation and consistent application of lessons learned while implementing innovative improvements for future tasks. (Innovation) �Works under limited supervision.


Minimum Qualifications:

MINIMUM QUALIFICATIONS

Bachelor's degree in computer science or related discipline and 4-7 years' relevant experience in data warehouse design, business intelligence reporting and ETL/TLT processing or 6-9 equivalent combination of education and work experience.
Demonstrates high levels of knowledge in new and emerging Big Data technologies. (Big Data Technologies)
Understands how work contributes to the bottom line. (business acumen)
Maintain advanced knowledge of new technologies or technology opportunities and analysis of their use for business and/or IT clients. Develops white papers, conducting presentations as needed. (Cloud Technologies)
Detailed knowledge of the data architecture of the systems which support more than one core business area. (Data Architecture)
Mastery of Data Interpretation in practical applications of a difficult nature. (Data Interpretation)
Demonstrates a thorough understanding of industry data security standards including trends and advancements. (Data Security)
Has designed and implemented enterprise-wide standards, including business definitions and naming standards. (Data Warehouse)
Demonstrates successful collaborative negotiation skills. Capable of building trust and gaining commitment in volatile environments to achieve results. Able to take a firm bargaining position while maintaining harmony with others. (Negotiation Skills & Relationship Management & Consulting)
Experience performing as a team leader contributing to the effectiveness of the interview team with stakeholders to identify business needs and opportunities. (Requirements Gathering)
Proficient in PowerShell, Ansible, or other appropriate scripting tool and able to independently create, modify, and troubleshoot scripts for automation, reporting, and monitoring tasks. (Scripting/Automation)
Demonstrates a high proficiency for disseminating information to users, management, customers and others who have limited knowledge of the subject. (system documentation)
Demonstrates expertise in resolving challenging problems involving usage of a variety of tools. (Technical Tools and Products)
Demonstration of advanced capabilities to apply monitoring tools. (Troubleshooting & Monitoring)



Preferred Qualifications: PREFERRED QUALIFICATIONS

Possess expertise in cloud technologies
Proficient in the Azure cloud platform and its applications
Experience in Databricks technologies with Databricks warehouse expertise
Experience in ODI, IDMC, ADF, Synapse o Familiarity on Oracle Golden Gate, cosmos DB, Hyperscale DB
Proficient with big data technologies such as Spark
Experienced in data cleaning, preprocessing, and transforming data into readable formats for analysis
Comprehensive understanding of ETL and data warehouse concepts
Capable of managing multiple ongoing projects and ensuring timely delivery
Optimizing techniques for different data Format (SCD1,2, Parquet, GIS, Timeseries)
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: Benefits

Annual salary will vary based on a candidate’s skills, qualifications, experience, and other factors: $109,600.00/Yr. – $150,700.00/Yr.
Annual Bonus for eligible positions: %
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
Employee Assistance Program and resources for mental and emotional support
Wellbeing programs such as tuition reimbursement, adoption and surrogacy assistance and fitness reimbursement
Referral bonus program
And much more


Note: Exelon-sponsored compensation and benefit programs may vary or not apply based on length of service, job grade, job classification or represented status. Eligibility will be determined by the written plan or program documents.

Trending Jobs

company-logo

Nuclear Technical Intern - Mid Atlantic

Constellation
Job TypeInternship
 
Lusby, MD
24 days ago
company-logo

Apprentice Lineman

Brink Constructors, Inc.
Job TypeFull-time
 
Rapid City, SD
23 days ago
company-logo

Deckhand (Houston)

John W. Stone Oil Distributor, LLC
 
Houston, TX
24 days ago
company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, Pennsylvania
3 months ago
company-logo

Director, Financial Planning & Analysis - Energy (Enterprise)

Pilot Thomas Logistics
Job TypeFull-time
 
Grapevine, TX
24 days ago
company-logo

Quality Engineer

Jedco Inc.
Job TypeFull-time
 
Grand Rapids, MI
18 days ago
company-logo

Solar Electrician

MN8 Energy
Job TypeFull-time
 
California, United States
22 days ago
company-logo

Gas Foreman

Peak Utility Services Group
Job TypeFull-time
 
Lawton, OK
23 days ago
company-logo

Sr. Polymer Scientist

ExxonMobil
Job TypeFull-time
 
Baytown, TX
22 days ago
company-logo

Apprentice Lineman I

San Patricio Electric Cooperative, Inc.
Job TypeFull-time
 
Sinton, TX
8 days ago
SD

Service Manager

Supertech Diesel Truck Specialists
Job TypeFull-time
 
Langley, BC
21 days ago
company-logo

Finishing Helper Entry Level- Dayshift

Bonnell Aluminum
Salary
$41600 - $41600
Carthage, TN
18 days ago
company-logo

Apprentice Line Worker I

Tampa Electric
Job TypeFull-time
 
Ruskin, FL
30 days ago
company-logo

Meter Technician

ONEOK
Job TypeFull-time
 
Odessa, TX
24 days ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, Louisiana
about 2 months ago
company-logo

Apprentice Power Lineman

Proline Power Corp.
Job TypeFull-time, Apprenticeship
 
Red Deer, AB
28 days ago
SD

Service Manager

Supertech Diesel Truck Specialists
Job TypeFull-time
 
Nanaimo, BC
21 days ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, Texas
15 days ago
company-logo

Assembler/Production

Uptalent
Job TypeContract
Salary
$37440 - $49920
Oklahoma City, OK
17 days ago
company-logo

Senior Investigator

Dominion Energy
Job TypeFull-time
 
Norfolk, VA
24 days ago