Who We Are: 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, 19,000 colleagues strong serving more than 10 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).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: PRIMARY PURPOSE OF POSITIONLead activities relating to designing, building, testing, implementing, and maintaining solutions, products, and processes under the guidance of a Principal Data Engineer or Manager. Coach and/or mentor less experienced team members. Primary Duties: PRIMARY DUTIES AND ACCOUNTABILITIESPlan all tasks within a SDLC phase including estimating, scope definition and work plan development. Coordinates planning, design and production of deliverables for the training phase. Sought by others for advice. Assists in reviewing deliverables of the SDLC phase. Develops accurate budgets and schedules tasks/staffing. Participates in the integration of this phase to others. Reviews all tasks within a phase to ensure overall quality and accuracy. (System Development Life Cycle) (40%)Maintain and enhance engagement with business and IT partners and other stakeholders (20%)Create 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%)Establish positive team environment by assisting and training less experienced personnel. (15%)Proactively build and develop others' technical knowledge and business acumen (10%) Job Scope: JOB SCOPESolves moderate to highly complex problems, inclusive of partner with vendors and other IT professionals to do so. (Critical Thinking & Problem Solving) Can function as a liaison with database administration to communicate data requirements that must be implemented in a DBMS. Has knowledge of at least one DBMS. Able to code and implement extensions to a data dictionary or repository. (Data Warehouse) Develops security policies and guidelines for users and management. Guides the development of business rules of use as they relate to data security. Creates procedures for data access, protection, and backup. Works closely with cyber threat intelligence analysts, cyber forensics analysts and incident response teams to understand how their challenges can be addressed with data analysis and data science efforts. (Data Security) Independently makes informed decisions on monitoring settings such as sample size, level of criticality, and self-healing opportunities. (Troubleshooting & Monitoring) Contributes to strategic planning in areas which require expert Big Data knowledge and experience. Participates in advanced technology efforts for the company, evaluating and testing new products to determine their value and applicability to the organization. Often takes a lead role in critical situations where there is a need to apply knowledge of Big Data technological trends, emerging technology and/or new tools and products. Successfully selects and implements Big Data technology to meet requirements of state-of-the-art systems and projects. (Big Data Technologies) Drives innovation process with regular evaluation and consistent application of lessons learned while implementing innovative improvements for future tasks. (Innovation) Works under limited supervision. Minimum Qualifications: MINIMUM QUALIFICATIONSBachelor'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 high levels of knowledge in new and emerging Big Data technologies. (Big Data Technologies)Understands how work contributes to the bottom line. (business acumen)Maintain advanced knowledge of new technologies or technology opportunities and analysis of their use for business and/or IT clients. Develops white papers, conducting presentations as needed. (Cloud Technologies)Detailed knowledge of the data architecture of the systems which support more than one core business area. (Data Architecture)Mastery of Data Interpretation in practical applications of a difficult nature. (Data Interpretation)Demonstrates a thorough understanding of industry data security standards including trends and advancements. (Data Security)Has designed and implemented enterprise-wide standards, including business definitions and naming standards. (Data Warehouse)Demonstrates successful collaborative negotiation skills. Capable of building trust and gaining commitment in volatile environments to achieve results. Able to take a firm bargaining position while maintaining harmony with others. (Negotiation Skills & Relationship Management & Consulting)Experience performing as a team leader contributing to the effectiveness of the interview team with stakeholders to identify business needs and opportunities. (Requirements Gathering)Proficient in PowerShell, Ansible, or other appropriate scripting tool and able to independently create, modify, and troubleshoot scripts for automation, reporting, and monitoring tasks. (Scripting/Automation)Demonstrates a high proficiency for disseminating information to users, management, customers and others who have limited knowledge of the subject. (system documentation)Demonstrates expertise in resolving challenging problems involving usage of a variety of tools. (Technical Tools and Products)Demonstration of advanced capabilities to apply monitoring tools. (Troubleshooting & Monitoring) Preferred Qualifications: PREFERRED QUALIFICATIONSPossess expertise in cloud technologiesProficient in the Azure cloud platform and its applicationsExperience in Databricks technologies with Databricks warehouse expertiseExperience in ODI, IDMC, ADF, Synapse o Familiarity on Oracle Golden Gate, cosmos DB, Hyperscale DBProficient with big data technologies such as SparkExperienced in data cleaning, preprocessing, and transforming data into readable formats for analysisComprehensive understanding of ETL and data warehouse conceptsCapable of managing multiple ongoing projects and ensuring timely deliveryOptimizing techniques for different data Format (SCD1,2, Parquet, GIS, Timeseries)Experience writing technical design specifications for data integrations and data transformations with structured and unstructured data.Experience with Scrum development methodologyExperience with writing business cases. Experience in capturing, analyzing and translating business needs into functional IT requirementsExperience developing data integrations and data transformations with structured and unstructured data. SQL (DML, DCL, DDL) expertise with Oracle 11g through 12c and Microsoft SQL Server 2008r2 through 2016Experience with the setup and configuration of Automic UC4 scheduler on RHEL, Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB), Oracle Business Intelligence (OBI), Oracle Enterprise Manager (OEM), Oracle HTTP Server (OHS), WebLogic, Informatica, Business Objects, SAS software for data analytics, Kafka, Nifi, UC4, Red Hat Enterprise Linux.Application re-engineering, data modeling and performance tuning. Architecture and design for application disaster recovery and high availability: HP ALM, Microsoft Azure DevOps, Customer Information Systems (for example: CIMs, CC&B, SAP CRM&B),AMI Meter Data Management Systems (for example: Oracle Utilities MDM, Itron IEE), Geographic Information Systems (for example: GE Smallworld), Outage Management Systems, Itron/SSN UtilityIQ, Xylem/Sensus AMI, OSI Soft PI HistorianExperience managing IT projects using Agile/Scrum and waterfall methodologies Benefits: BenefitsAnnual salary will vary based on a candidate’s skills, qualifications, experience, and other factors: $109,600.00/Yr. – $150,700.00/Yr. Annual Bonus for eligible positions: % 401(k) match and annual company contributionMedical, dental and vision insuranceLife and disability insuranceGenerous 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 supportWellbeing programs such as tuition reimbursement, adoption and surrogacy assistance and fitness reimbursementReferral bonus programAnd much moreNote: 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.