Sr Business Analyst - Data Visualization

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, 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:

 

Role is considered to be the Career Level. Perform detailed analysis and prepare comprehensive reports to support business operations. Conduct complex modeling, forecasting, trending, variance analysis, business case development, and other general financial and operational analysis. Monitor and coordinate activities to manage operational performance (e.g., safety, reliability, service level, productivity, etc.). Research and provide statistical financial and operational information. Track, maintain, analyze and provide current information on the operation's business scorecard or key performance indicators (KPIs). Develop, organize and present performance reports for both internal and external use. Develop and conduct short-term and long-range business planning. May develop, implement, evaluate or lead projects or initiatives (e.g., business plan or process improvement initiatives). Provide broad analytical and operational support to the business unit.

 

Position may be required to work extended hours for coverage during storms or other energy delivery emergencies.

Primary Duties:

 

• Develop and conduct short-term and long-range business planning. Conduct complex modeling, forecasting, trending, variance analysis, business case development, and other financial and operational analysis (e.g., operational effectiveness, budget, resource, workload, workforce and capacity utilization, competitor, etc.).
• Provide statistical information to ensure the most effective utilization of personnel, equipment and/or materials for business operations.
• Monitor and coordinate activities to manage operational performance (e.g., safety, reliability, service level, productivity, etc.) and make recommendations for improvement.
• Track, maintain, analyze and provide current information on the operation's business scorecard or key performance indicators (KPIs).
• Perform analysis of the operation's cost elements to ensure effective and efficient operations.
• Prepare and analyze comprehensive and detailed reports.
• Develop, organize and present detailed performance reports for both internal and external use.
• May develop, implement, evaluate or lead projects or initiatives (e.g., business plan or process improvement initiatives).
• Provide broad analytical and operational support to the business unit.

Job Scope:

 

• This is an individual contributor position that works independently with only general direction, relying on knowledge skills and judgment acquired through education and relevant experience to plan and accomplish assigned tasks and goals. The position regularly mentors less experienced colleagues.
• Position requires routine interaction with key internal and external stakeholders, executives, directors, managers and staff across the organization.
• May require working extended hours and/or shift work to support business operations.

Minimum Qualifications:

 

• Bachelor's degree in Business or Engineering AND 4-7 years of related business experience, or in lieu of degree, 6-9 years of relevant business experience is required.
• Comprehensive understanding of applicable standards, methods, processes and practices, business fundamentals, and performance metrics in the specific functional area supported by this position (e.g., asset management, electric or gas operations, customer service, transmission and substation, distribution system operations, regulatory and external affairs, transmission operations and planning).
• Advanced proficiency in standard software applications (e.g., Microsoft Word, Excel, Access, PowerPoint, Project), specialized business technologies and applications (e.g., workforce management, project management, PassPort, Brio, CIS, EPS, Business Objects, SAP planning, business modeling, forecasting, voice response unit, automatic call distributors, work management, outage management) to retrieve and analyze data in support of business needs.
• Ability to provide in-depth analysis and apply managerial accounting concepts, customer intelligence gathering, forecasting, staff planning, scheduling, analytical and statistical problem solving, financial, accounting, business and budget analysis.
• Demonstrated strong analytical skills for project evaluation including analysis of complex projects with economic, financial, risk and decision analysis. Proficient in business case development and ability to effectively present business cases to business unit leadership.
• Customer driven with good oral and written communications skills and strong analytical, problem solving and project management skills.
• Comprehensive knowledge of the practices, procedures and principles of performance analysis (trending, root cause and gap analysis) benchmarking and audit compliance. Ability to analyze organizational data and complex problems, interpret and recommend alternative courses of action, and implement intervention strategies to attain performance targets.

Preferred Qualifications:

 

Data Analysis & Visualization: Collect, clean, and analyze large datasets to identify trends, patterns, and insights. Develop dashboards and reports using tools like Power BI, Tableau, or SQL, Scripting language, Python, Java, Power BI language (DAX power query).

 

 

Data-Driven Decision Making: Collaborate with stakeholders to understand business needs, provide actionable insights, and support strategic decision-making through data-driven recommendations.

 

Benefits:

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