DeveloperJobs.io
← Back to all jobs
Exelon

Sr Data Engineer 1 – Enterprise IT Data Analytics

Oakbrook Terrace, IL $105k - $157k/yr Full time Posted 10d ago

Job Description

Exelon’s Enterprise IT Data Analytics team supports the design and lifecycle management of data analytics solutions that enable business partners. This role performs support activities across the analytics landscape, including building and maintaining solutions under guidance, with the option to coordinate work for others.

Key Responsibilities

  • Perform, document, and assist in planning work activities related to projects, sub-projects, or processes.
  • For smaller projects, analyze requirements, design, build, and test IT software solutions in accordance with IT project management standards.
  • For operations and application maintenance, enhance, maintain, or support existing IT products and processes aligned to the defined service level agreement (45%).
  • Support the creation of documentation for products and services.
  • Apply best practices to improve products and services for business unit partners and monitor adherence to standards within the Management Model (15%).
  • Maintain and strengthen engagement with business and IT partners and other stakeholders (15%).
  • Help establish a positive team environment by assisting and training less experienced personnel (15%).
  • Proactively develop technical knowledge and business acumen within the relevant discipline or function (10%).

Additional responsibilities include solving complex problems in coordination with vendors and other IT professionals, assisting with workplan development with limited review, identifying unexpected issues and resolving them with limited assistance, and delivering the service in support of Exelon Utility Analytics. The role also designs, implements, and enforces security policies and controls to protect systems and data from unauthorized access, performs analyses of data security systems for management updates and reporting, and makes informed decisions on monitoring settings such as sample size, level of criticality, and potential self-healing opportunities. The position drives innovation by regularly evaluating outcomes and applying lessons learned to improve future implementations, and works under limited supervision.

Required Qualifications

  • Bachelor’s degree in computer science or a related discipline, plus 4–7 years of relevant experience in data warehouse design, business intelligence reporting, and ETL/TLT processing; or 6–9 years of an equivalent combination of education and work experience.
  • In-depth knowledge of Big Data technologies and their impact on the company’s systems infrastructure.
  • Experience implementing enterprise-wide data standards, including business definitions and naming standards.
  • Experience participating in user interviews as part of a systems development team to gather information for analysis or technical work.
  • Ability to use PowerShell, Ansible, or another appropriate scripting tool to automate common tasks, create reports, and troubleshoot issues in existing scripts.
  • Strong understanding of how the System Development Life Cycle phase fits into the overall development lifecycle.
  • High proficiency in disseminating information to users, management, customers, and others with limited knowledge of the subject.
  • Thorough understanding of effective use of a variety of tools in complex applications.
  • Solid understanding of the capabilities of standard monitoring tools.

Technologies

  • Big Data
  • PowerShell
  • Ansible
  • ETL/TLT
  • Databricks
  • SQL

Preferred Qualifications

  • Insight into how the work contributes to the bottom line.
  • Experience with Databricks, including production support work and/or migration of an Enterprise Data Analytics platform from legacy architecture to Databricks.
  • Ability to build and maintain knowledge of new technologies and assist in developing analyses of technology use for business and/or IT clients.
  • Detailed knowledge of data architecture supporting more than one core business area.
  • Proficiency in demonstrating data management and data interpretation in practical applications of moderate difficulty.
  • Ability to leverage alternative perspectives and emerging technologies to deliver creative solutions, including contributing to writing white papers.
  • Demonstrated ability to build and maintain relationships with a high degree of competency to synthesize what a business partner is asking for.

Compensation and Benefits

  • Annual salary range: $104,800.00–$157,200.00 per year (note: additional posting language specifies $104,800.00–$144,100.00 for annual salary).
  • 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, bonding/primary caregiver leave, and 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

Note: Exelon-sponsored compensation and benefit programs may vary or may 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.

Role Logistics

  • Location: Oakbrook Terrace, IL (onsite)
  • Minimum experience: 4 years
  • Education: Bachelor’s degree in computer science or related discipline

Similar Jobs