Senior Data Analyst-Emergency Preparedness

Collect, cleanse, analyze and visualize data relating to Emergency Preparedness (EP) from a variety of internal and external sources. Foster close collaboration with internal stakeholders, management, leadership roles and cross-functional groups to transform data into actionable insights that drive decision making. Gain thorough understanding of business needs, identify process gaps and uncover opportunities for improvement. Leverage technology, software and modern frameworks to drive process improvement and automation. Provide and receive regular feedback and ensure the proper transfer of developed solutions. Validate findings with the business by sharing analysis outputs in a way that can be understood by business stakeholders. Share knowledge with team members, and business stakeholders, and IT partners. Position may be required to work extended hours, including 24 x 7 coverage during storms or other energy delivery emergencies.

1. (15%) Gather, integrate, and manage data from internal and external sources (e.g., relational databases, APIs) and analyze complex datasets to identify trends, patterns, correlations, and actionable insights using analytics frameworks/tools, including – but not limited to – SQL, Python, Excel.
2. (15%) Create interactive dashboards, charts, and reports to effectively communicate findings to stakeholders using tools like Power BI, Tableau, Excel, or Python-based libraries. Translate data insights into clear, business-friendly recommendations, tailored to non-technical audiences.
3. (20%) Works with stakeholders and subject matter experts to understand business needs, goals and objectives. Identify gaps and inefficiencies in existing workflows and processes and recommend data-driven solutions. Explore opportunities for automation using technologies such as scripting (Python, R, SQL) and workflow automation tools (Power Automate).
4. (20%) Understand, document, and maintain existing tools, systems, and processes to ensure business continuity. Proactively monitor and troubleshoot issues, identifying root causes and implementing solutions to minimize disruptions. Continually assess and enhance the performance of existing systems by researching potential improvements and staying abreast of industry best practices.
5. (10%) Document processes, methodologies, and solutions to ensure knowledge transfer among team members and stakeholders. Provide support and training as needed.
6. (20%) Participate in Emergency Preparedness activities and projects: Emergency Response Drills, Emergency Load Conservation, Summer/Winter Readiness Plans, Emergency Generator and Transformer Deployment Process, Work Stoppage Planning, Black Start Planning. Participate in and coach personnel during emergency events. Monitor emergency events for process adherence and improvement opportunities. Conduct post-event lessons learned meetings, track completion of resulting action items, and file required regulatory report for the event. Coordinate emergency planning with municipal, state, federal agencies, and other industry groups.

• This individual will report directly to the IT Manager, Internal Audit Services. In addition to being a self-starter, this individual will work independently and with the IAS management team to accomplish objectives. This individual will periodically interface with all levels of Exelon management and external auditors.
• Level and depth of supervisory duties - Some
• Budget accountability, impact on asset management, and organization revenue - Some
• Number of direct reports (Span of Control). None
• Level of independence, decision-making authority or strategic planning accountability - Some
• Internal and external contact relationships - Contractors

• Five to eight years' experience in compiling and analyzing data, including experience with ACL software.
• Strong oral and written communication skills
• Strong project management and administration skills
• Strong technical skills, including but not limited to understanding how databases operate, how to use and set up ODBC connections, general server and mainframe knowledge, and a general understanding of file types for data extrapolation.
• Ability and willingness to travel (20-25%)

1. Education: Bachelor's, Master’s, or PhD in a Quantitative discipline. Ex: Computer Science, Engineering, Applied Mathematics, Finance, Ops Research, Physics, Statistics, or related field.
2. 4-7 years of relevant experience applying advanced analytic techniques to large, complex datasets and extracting actionable insights.
3. High proficiency in SQL and Python for effective data extraction, manipulation and analysis as well as script/automation development. Expertise in Microsoft ecosystem (Office Suite including Access, Power Platform, SharePoint, VBA, etc.).
4. Hands-on experience with machine learning techniques and predictive modeling, with practical application to large-scale datasets. Familiarity with frameworks such as Scikit-learn, TensorFlow or PyTorch is a plus.
5. Proficiency in cloud computing platforms (e.g. Azure, AWS, GCP) and experience integrating analytics workflows within scalable, cloud-based architectures is a plus.
6. Experience working with GIS tools and methods, such as ArcGIS, QGIS, or Python-based geospatial libraries (e.g., GeoPandas, Shapely) is a plus.
7. Solid foundation in data science and computer science principles, including advanced statistics, probability, data structures, algorithms, linear algebra, and optimization techniques. Ability to apply these concepts to solve complex analytical problems effectively.
8. Experience in the electric utilities or broader energy sector and prior exposure to data structures pertaining to Outage Management Systems (OMS), Enterprise Asset Management (EAM) systems, smart-meters, billing, etc.

• 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

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?