Sr Data Engineer 1

Exelon; Villa Park (IL); On-site; USD 105,000 - 144,000; Full time

Benefits offered by this job

Annual salary varies by skills and etc

401(k) match and company contribution

Medical, dental and vision insurance

Life and disability insurance

Generous paid time off

Employee Assistance Program

Tuition reimbursement

Referral bonus program

Job summary

Exelon is seeking a data engineer to design, build, test, implement, and maintain data solutions under the guidance of a Principal Data Engineer. You may coordinate tasks for other team members and collaborate with IT partners to deliver reliable analytics platforms.

You will contribute to data warehouse design, ETL processing, and BI reporting while upholding SDLC standards and security controls. Join a Fortune 200 company committed to growth, innovation, and delivering value to millions of

Qualifications

• Bachelor's degree in computer science or related discipline with 4–7 years of data warehouse/BI experience.
• In-depth knowledge of Big Data technology and its impact on the company infrastructure.
• Experience implementing enterprise-wide data standards, including business definitions and naming conventions.
• Experience interviewing users as part of a systems development team to gather information for analysis or technical work.
• Ability to automate tasks/create reports and troubleshoot issues with scripting tools (PowerShell/Ansible).

Responsibilities

• Plan, document, and assist in planning work activities for projects or operations; design and test IT data solutions.
• Create documentation for products and services and monitor adherence to standards.
• Maintain engagement with business and IT partners and stakeholders.
• Establish positive team environment and mentor less experienced colleagues.
• Proactively build technical knowledge and drive improvements within own discipline.

Skills

Data warehouse design

BI reporting

ETL processing

PowerShell scripting

Ansible scripting

SDLC understanding

Stakeholder communication

Education

Bachelor's degree in computer science or related discipline

Tools

PowerShell

Ansible

Job description

Who We Are

Exelon is helping build a more affordable, reliable energy future for the communities we serve. We're looking for people who are ready to make a difference and work together to deliver the energy our customers count on every day.

As a Fortune 200 company and one of the nation's largest utility companies, we have more than 20,000 colleagues who serve nearly 11 million customers through six fully regulated utilities - 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).

Exelon is built by people who put safety first, work together to solve problems and show up every day for our customers and communities. We believe strong teams are built on trust, respect and a shared commitment to high-performance culture. And our commitment to employees includes creating an environment where people can grow, develop new skills and build thriving careers.

We know this work isn't easy. That's why we offer competitive compensation, incentives, excellent benefits and the opportunity to build a rewarding career. No matter your role, you will be part of a team that is committed to making a difference, improving how we work and delivering for the people who depend on us.

Are you on for the challenge?

Primary Purpose

PRIMARY PURPOSE OF POSITION

Perform activities relating to designing, building, testing, implementing, and maintaining solutions, products, and processes under the guidance of a Principal Data Engineer or Manager. May coordinate tasks for other team members.

Primary Duties

PRIMARY DUTIES AND ACCOUNTABILITIES

• Perform, document, and assist in planning work activities relating to projects, sub-projects, or processes. For Projects: analyze requirements, design, build, and test IT software solutions in accordance with IT project management standards. For operations/application maintenance: enhance, maintain, or support existing IT products and processes to the defined service level agreement (45%)
• Support the creation of 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%)
• Maintain and enhance engagement with business and IT partners and other stakeholders (15%)
• Establish positive team environment by assisting and training less experienced personnel. (15%)
• Proactively build technical knowledge and business acumen within own discipline or function. (10%)

Job Scope

JOB SCOPE

• Solves complex problems, inclusive of partner with vendors and other IT professionals to do so.
• Assists in developing workplans for the phase with limited review. Identifies unexpected problems and resolves with limited assistance.
• Performs this service in support of Exelon Utility Analytics.
• Designs, implements, and enforces security policies and controls that protect systems and data from access by unauthorized users. Performs analyses of data security systems to keep management informed of system utilization patterns
• prepares reports on same.
• Can make informed decisions on monitoring settings such as sample size, level of criticality, and some self-healing opportunities.
• Drives innovation process with regular evaluation and application of lessons learned while implementing innovative improvements for future tasks.
• 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 in-depth knowledge of the Big Data technology and its impact on the systems infrastructure of the company.
• Experience implementing enterprise-wide data standards, including business definitions and naming standards.
• Experience participating in interviews of users 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 with existing scripts.
• Strong understanding of how the System Development Life Cycle phase fits into the overall development lifecycle.
• Demonstrates a high proficiency for disseminating information to users, management, customers and others who have limited knowledge of the subject.
• Demonstrates a thorough understanding of the effective use of a variety of tools in complex applications.
• Solid understanding of the capabilities of standard monitoring tools.

Preferred Qualifications

PREFERRED QUALIFICATIONS

• Demonstrates an insight how work contributes to the bottom line.
• Ability to build and maintain knowledge of new technologies or technology opportunities and assists in development of analysis of their use for business and/or IT clients.
• Detailed knowledge of the data architecture of the systems which support more than one core business area.
• Proficiency to successfully demonstrate data management and data interpretation in practical applications of moderate difficulty.
• Ability to leverage alternative perspectives and emerging technologies to deliver creative solutions and able to contribute 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.

Benefits

• Annual salary will vary based on a candidate’s skills, qualifications, experience, and other factors: $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
• 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.