Sr Data Engineer 1 - P&CM Project Management Office (PMO)

Who We Are Exelon is leading the energy transformation. We are a Fortune 200 company with 20,000 colleagues serving more than 10.7 million customers across six energy companies. We value purpose‑driven people who are inclusive, creative and committed to safety, innovation, integrity and community service. We are committed to an environment where every person can thrive, supporting purposeful careers, growth opportunities, community impact, and support to thrive. Primary Purpose Perform activities related 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. Position may require extended hours for coverage during storms or other energy delivery emergencies. Primary Duties Plan, document, and assist in work activities for 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 a 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 Solves complex problems, inclusive of partner with vendors and other IT professionals to do so. Assists in developing work plans 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 unauthorized access. 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 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 Big Data technology and its impact on 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 gather information for analysis or technical work. Ability to use PowerShell, Ansible, or another scripting tool to automate common tasks, create reports, and troubleshoot existing scripts. Strong understanding of how the System Development Life Cycle fits into the overall development lifecycle. High proficiency for disseminating information to users, management, customers and others with limited knowledge of the subject. 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 Demonstrates insight on how work contributes to the bottom line. Ability to build and maintain knowledge of new technologies or technology opportunities and assist in developing analyses of their use for business and/or IT clients. Detailed knowledge of the data architecture of systems supporting 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 contribute to writing white papers. Demonstrated ability to build and maintain relationships with a high level 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 Well‑being 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. #J-18808-Ljbffr