Sr Business Analyst - Finance (Hybrid)

Pepco; Oak Brook (IL); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Annual salary $80,000–$110,000

Annual bonus 15%

401(k) match

Medical, dental and vision insurance

Life and disability insurance

Paid time off

Employee Assistance Program

Tuition reimbursement

Job summary

Exelon is seeking a Career Level Analyst to perform detailed analysis and develop comprehensive reports supporting business operations. You will conduct complex modeling, forecasting, and variance analysis, and assist in short- and long-range planning.

Responsibilities include tracking KPIs, preparing detailed performance reports, and providing operational support across business units. Extended hours may be required during storms or outages.

Qualifications

• Bachelor's degree in Business or Engineering and 4–7 years of related business experience, or 6–9 years in lieu of degree.
• Understanding of performance metrics in the relevant functional area (asset management, operations, customer service, etc).
• Proficiency in Microsoft Office and specialized business tools for data retrieval and analysis.
• Ability to perform in-depth analysis, forecasting, budgeting and financial reporting.

Responsibilities

• Develop and conduct short-term and long-range business planning.
• Provide statistical information to optimize utilization of personnel and resources.
• Monitor and coordinate activities to manage performance (safety, reliability, service level, productivity).
• Track and analyze KPIs and provide current information on the business scorecard.

Skills

Advanced analytics

Forecasting

Variance analysis

Report development

Communication skills

Education

Bachelor's degree in Business or Engineering

Tools

Microsoft Excel

Microsoft Word

PowerPoint

Microsoft Access

Project

SAP planning

Brio

CIS

Job description

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

• MBA or relevant advanced degree.
• Experience with Financial Reporting including the following
  • Monthly Forecasting
  • Monthly Financial Book close, including accruals and correcting journal entries
  • Long Range Budgeting
• Proficiency in Microsoft Office suite (proficiency in MS Excel is required)

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.