Sr Data Engineer 1 – Enterprise IT Data Analytics
Job Description
Exelon is looking for a senior data engineer to support Enterprise IT Data Analytics solutions in an onsite role in Oakbrook Terrace, IL.
Responsibilities
- Perform, document, and assist with planning work activities for projects, sub-projects, or processes.
- For small projects: analyze requirements and design, build, and test IT software solutions in line with IT project management standards.
- For operations and application maintenance: enhance, maintain, or support existing IT products and processes to defined service level agreement targets (45%).
- Support creation of documentation for products and services.
- Apply best practices to improve offerings for business unit partners and help monitor adherence to standards defined in the Management Model (15%).
- Maintain and enhance engagement with business and IT partners and other stakeholders (15%).
- Assist and train less experienced personnel to support a positive team environment (15%).
- Proactively build technical knowledge and business acumen within the data engineering discipline or function (10%).
- Solve complex problems in collaboration with vendors and other IT professionals.
- Assist in developing workplans for a project phase with limited review.
- Identify unexpected problems and resolve them with limited assistance.
- Provide this service in support of Exelon Utility Analytics.
- Design, implement, and enforce security policies and controls to protect systems and data from unauthorized access.
- Analyze data security systems to inform management of system utilization patterns and prepare reports.
- Make informed decisions for monitoring settings, including sample size, criticality level, and some self-healing opportunities.
- Drive innovation by evaluating and applying lessons learned to implement innovative improvements for future tasks.
- Work under limited supervision.
Requirements
- 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.
- Alternative: 6-9 years of equivalent combination of education and work experience.
- In-depth knowledge of Big Data technology and its impact on the company 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 disseminating information to users, management, customers, and others with limited subject knowledge.
- Thorough understanding of effective use of a variety of tools in complex applications.
- Solid understanding of standard monitoring tool capabilities.
Technologies
- Big Data
- PowerShell
- Ansible
- ETL/TLT
- Databricks
- SQL
Benefits
- Annual salary: $104,800.00/Yr. – $144,100.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
- 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 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.
Preferred Qualifications
- Insight into how the work contributes to the bottom line.
- Experience in Databricks, including production support and/or migration of an Enterprise Data Analytics platform from legacy to Databricks architecture.
- Ability to build and maintain knowledge of new technologies and assist in analysis of their use for business and/or IT clients.
- Detailed knowledge of data architecture supporting more than one core business area.
- Proficiency to demonstrate 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 requesting.