Sr Data Engineer 1 – Enterprise IT Data Analytics
Job Description
In the Enterprise IT Data Analytics environment, you will perform support activities spanning the design, build, testing, implementation, and maintenance of data analytics solutions. Work will be completed under guidance, with opportunities to coordinate tasks for other team members.
Key Responsibilities
- Perform, document, and assist in planning work activities for projects, sub-projects, or processes.
- For small projects, analyze requirements and deliver IT software solutions through design, build, and test activities aligned to IT project management standards.
- Support operations and application maintenance by enhancing, maintaining, or supporting existing IT products and processes according to the defined service level agreement (45%).
- Support creation of documentation for products and services.
- Apply best practices to improve products and services provided to business unit partners and monitor adherence to standards defined within the Management Model (15%).
- Maintain and enhance engagement with business, IT partners, and other stakeholders (15%).
- Help establish a positive team environment by assisting and training less experienced personnel (15%).
- Proactively build technical knowledge and business acumen within the relevant discipline or function (10%).
- Solve complex problems, including collaboration with vendors and other IT professionals.
- Assist in developing workplans for the phase with limited review.
- Identify unexpected issues and resolve them with limited assistance.
- Provide this service in support of Exelon Utility Analytics.
- Design, implement, and enforce security policies and controls that protect systems and data from unauthorized access.
- Analyze data security systems and provide management with system utilization patterns through reporting.
- Make informed decisions on monitoring settings such as sample size, level of criticality, and certain self-healing opportunities.
- Drive innovation by evaluating and applying lessons learned to implement improvements for future tasks.
- Work under limited supervision.
Required Qualifications
- Bachelor’s degree in computer science or a related discipline, with 4 to 7 years of relevant experience in data warehouse design, business intelligence reporting, and ETL/TLT processing, or a combination of education and work experience totaling 6 to 9 years equivalent.
- In-depth knowledge of Big Data technologies and how they impact 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 support analysis and technical work.
- Ability to use PowerShell, Ansible, or another appropriate scripting tool to automate common tasks, create reports, and troubleshoot issues with existing scripts.
- Strong understanding of how the System Development Life Cycle phase fits into the overall development lifecycle.
- High proficiency in communicating information to users, management, customers, and others with limited subject knowledge.
- Thorough understanding of the 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 work contributes to the bottom line.
- Experience with 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 technology opportunities, supporting analysis for business and/or IT clients.
- Detailed knowledge of the data architecture supporting systems across more than one core business area.
- Proficiency to demonstrate data management and data interpretation in practical applications of moderate difficulty.
- Ability to use alternative perspectives and emerging technologies to deliver creative solutions, including contributing to writing white papers.
- Demonstrated ability to build and maintain relationships with high competency to synthesize what a business partner is requesting.
Location and Work Mode
Oakbrook Terrace, IL (onsite)
Compensation
Base Salary: USD 104,800 - 157,200 per year
Annual Bonus (eligible positions): 15%
Benefits
- 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.