Sr Data Engineer 1

Exelon•Oakbrook Terrace, IL

10h

About The Position

We're powering a cleaner, brighter future. Exelon is leading the energy transformation, and we're calling all problem solvers, innovators, community builders and change makers. Work with us to deliver solutions that make our diverse cities and communities stronger, healthier and more resilient. We're powered by purpose-driven people like you who believe in being inclusive and creative, and value safety, innovation, integrity and community service. We are a Fortune 200 company, 20,000 colleagues strong serving more than 10.7 million customers at six energy companies -- 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). We're committed to creating an environment where every person can thrive. Our employee experience is grounded in four tenets that guide how we support our people: purposeful careers, growth opportunities, community impact, and support to thrive. In our relentless pursuit of excellence, we elevate diverse voices, fresh perspectives and bold thinking. And since we know transforming the future of energy is hard work, we provide competitive compensation, incentives, excellent benefits and the opportunity to build a rewarding career. Are you in? Primary Purpose 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. This is a multiple‑location posting. The selected candidate may be based out of our Exelon Corporate Office locations in IL, DE, NJ, or PA

Requirements

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.

Nice To Haves

Proficiency in Microsoft PowerBI, Microsoft Fabric, Microsoft Azure, Databricks, and Database management
Technical landscape cost optimization experience (Environment management, resource utilization vs allocation, etc)
SQL
Ability to write, optimize & refine queries to analyze problems
Strong Organizational and Project Management Skills
Experience in IT project management and SDLC -Self-motivated and able to prioritize and manage workload and meet critical project milestones and deadlines
Experience & proficiency with ENP ServiceNow with foundational knowledge on enhancement change incident requests tickets and each associated process.
Strong debugging and problem-solving skills with ability to identify trends to quickly resolve or prevent future incidents.
Ability to lead and provide strategic direction to technical teams
Ability to work with strategic partners and business end users to identify gaps in production environments as -well as ability to identify areas of growth and improvement across analytics platform.
Excellent interpersonal, communication, negotiation, and collaboration skills
Knowledge on outage management and Data Governance experience a plus
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.

Responsibilities

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%)

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