Sr Data Engineer 1
Job Description
ComEd offers a role that combines hands-on engineering with collaboration across business and IT partners, supporting Exelon Utility Analytics. This onsite position in Oakbrook Terrace, IL supports the design, build, testing, implementation, and ongoing maintenance of data solutions and processes, with guidance and room to contribute improvements over time.
What you’ll do
- Perform, document, and help plan work activities for projects, sub-projects, or processes, including analyzing requirements, designing, building, and testing IT software solutions in line with IT project management standards.
- Enhance, maintain, or support existing IT products and processes to meet defined service level agreement expectations.
- Support documentation for products and services, apply best practices to improve delivery for business unit partners, and help monitor adherence to standards within the Team/Group using the Management Model.
- Maintain strong engagement with business and IT partners and other stakeholders to support ongoing delivery.
- Help establish a positive team environment by assisting and training less experienced personnel.
- Build technical knowledge and business acumen within your discipline or function.
- Design, implement, and enforce security policies and controls that protect systems and data from unauthorized access.
- Analyze data security systems to keep management informed of utilization patterns and prepare related reports.
- Make informed decisions on monitoring settings including sample size, level of criticality, and certain self-healing opportunities.
- Drive innovation by evaluating and applying lessons learned, implementing innovative improvements for future tasks.
- Solve complex problems in partnership with vendors and other IT professionals, and assist with developing workplans with limited review.
- Identify unexpected problems and resolve them with limited assistance.
- Provide this service in support of Exelon Utility Analytics.
Required qualifications
- Bachelor’s degree in computer science or a related discipline.
- 4-7 years of relevant experience in data warehouse design, business intelligence reporting, and ETL/TLT processing, or a combination of education and work experience that is equivalent (6-9 years).
- In-depth knowledge of Big Data technology and its impact on the company’s system 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 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 effectively using a variety of tools in complex applications.
- Solid understanding of capabilities of standard monitoring tools.
Technologies
- PowerShell, Ansible
- ETL, TLT
- Big Data
- System Development Life Cycle
Compensation and benefits
- Annual base salary: $104,800.00 to $144,100.00 (varies based on skills, qualifications, experience, and other factors)
- Annual bonus (eligible positions): 15%
- 401(k): match and annual company contribution
- Insurance: medical, dental, vision, life, and disability
- Paid time off: vacation, sick time, floating and fixed holidays, maternity leave and bonding/primary caregiver leave, or parental leave
- Employee Assistance Program and mental and emotional support resources
- Wellbeing programs: tuition reimbursement, adoption and surrogacy assistance, and fitness reimbursement
- Referral bonus program
- Additional benefits
Preferred qualifications
- Insight into how work contributes to the bottom line.
- Ability to build and maintain knowledge of new technologies and assist in analyzing technology opportunities 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, and contribute to writing white papers.
- Demonstrated ability to build and maintain relationships with high competency to synthesize what a business partner is asking for.