Sr Business Analyst - Finance (Hybrid)
for each heading. Only include sections when posting has real specific content. We need to extract content.
The posting includes: "Who We Are" (company description) maybe not needed as a heading? The instruction: Use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we should map content to these headings. The posting includes "Primary Purpose", "Primary Duties", "Job Scope", "Minimum Qualifications", "Preferred Qualifications", "Benefits". Also there is salary range (Pay). No explicit schedule. There's mention of extended hours, shift work, etc. Could be schedule info. We can include Schedule if there is content: "Position may be required to work extended hours for coverage during storms or other energy delivery emergencies." Also "May require working extended hours and/or shift work to support business operations." That's schedule info.
We need to avoid repeating job title as heading. No Job ID.
We need to remove boilerplate: cookie/navigation/legal/EEO etc. Not present.
We need to preserve all substantive info.
We'll create sections:
- About the role: maybe combine "Who We Are" and "Primary Purpose"? Actually "About the role" could be description of role: Primary Purpose. We'll put Primary Purpose content under About the role.
- Responsibilities: Primary Duties.
- Requirements: Minimum Qualifications? Could be Requirements. We'll put Minimum Qualifications under Requirements.
- Qualifications: Preferred Qualifications.
- Skills: maybe combine skills from qualifications? Could extract skills like analytical, modeling, etc. But we can also put skills under Qualifications? The instruction says we can have Skills section. We could create a Skills section summarizing skill requirements from Minimum and Preferred. But we must not invent or summarize away detail. We could list skills as bullet points from the qualifications text. That's preserving detail. So we can extract skill statements: "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." etc. That's a lot. Might be better to keep Qualifications and Skills separate: Qualifications = education/experience; Skills = specific abilities. We'll parse.
Minimum Qualifications includes: 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; Comprehensive understanding of applicable standards, methods, processes and practices, business fundamentals, and performance metrics; Advanced proficiency in standard software applications (list); 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 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).
We can create Skills section that lists specific skills: analytical, modeling, forecasting, variance analysis, business case development, etc. But we need to avoid duplication. Might be okay to have Skills as a subsection of Qualifications? But instruction says we can have Skills section. We'll include it.
Benefits: list as given.
Pay: salary range $80,000-$110,000 per year, Annual Bonus 15% (maybe part of Pay). We'll include Pay.
Schedule: mention extended hours, shift work.
We must not include filler like "commensurate with experience". Not present.
We need to output only HTML fragment, no /. Use headings, - for lists,
for prose.
We need to preserve all substantive info. So we need to include the company description? Possibly under About the role? The "Who We Are" is about company, not role. Might be considered "About the role"? But we could also include a section "About the company"? Not in allowed headings. The instruction says use headings e.g. About the role, Responsibilities, etc. It doesn't forbid other headings? It says use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Likely they expect only those headings. So we should map content to those. The "Who We Are" could be considered part of About the role? Might be okay to include under About the role as a brief description of the company context. We'll include a paragraph under About the role that includes the Who We Are description and Primary Purpose.
Let's craft:
About the role
Exelon is a Fortune 200 company powering a cleaner, brighter future, serving over 10.7 million customers across six energy companies. The role performs detailed analysis and prepares comprehensive reports to support business operations, conducts complex modeling, forecasting, trending, variance analysis, business case development, and other financial and operational analysis, monitors operational performance, tracks KPIs, develops reports, and supports business planning and projects.
But we need to preserve all substantive info: we must not lose details like "Position may be required to work extended hours for coverage during storms or other energy delivery emergencies." That's schedule.
We'll keep that under Schedule.
Now Responsibilities: list of Primary Duties as bullet list.
We need to ensure we don't miss any duty: list them:
- 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.
We'll put each as - .
Requirements: Minimum Qualifications as bullet list? Could be prose. We'll use
- for each distinct requirement.
Let's break down Minimum Qualifications into bullet points:
- 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.
- 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.
We'll list each as
- .
Qualifications: Preferred Qualifications bullet list:
- MBA or relevant advanced degree.
- Experience with Financial Reporting including 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).
Skills: we could extract skill statements from Minimum Qualifications and Preferred Qualifications but avoid duplication. Perhaps we can list skills like:
- Advanced proficiency in Microsoft Office suite (Word, Excel, Access, PowerPoint, Project)
- Experience with specialized business technologies (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)
- Complex modeling, forecasting, trending, variance analysis, business case development
- Statistical analysis and reporting
- Operational performance monitoring and improvement
- Cost element analysis
- Project evaluation and risk analysis
- Managerial accounting concepts
- Customer intelligence gathering
- Staff planning and scheduling
- Analytical and statistical problem solving
- Financial, accounting, business and budget analysis
- Business case development and presentation
- Oral and written communication
- Performance analysis (trending, root cause, gap analysis), benchmarking, audit compliance
- Data analysis and problem solving, recommending actions, implementing interventions
We'll list as bullet list.
Benefits: list as bullet list from the text:
- 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
But note: The salary range is also Pay. We might separate Pay and Benefits. The instruction says include Pay section only if posting actually states them. It does state salary range and bonus. So we will have Pay section with salary range and bonus. Benefits section will have other benefits.
Thus Pay:
- Annual salary range: $80,000.00/Yr. – $110,000.00/Yr.
- Annual Bonus for eligible positions: 15%
Benefits: the rest.
Schedule: mention extended hours, shift work.
We'll create Schedule section with bullet list:
- May be required to work extended
headings, - for lists,
for prose.
We need to preserve all substantive info. So we need to include the company description? Possibly under About the role? The "Who We Are" is about company, not role. Might be considered "About the role"? But we could also include a section "About the company"? Not in allowed headings. The instruction says use headings e.g. About the role, Responsibilities, etc. It doesn't forbid other headings? It says use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Likely they expect only those headings. So we should map content to those. The "Who We Are" could be considered part of About the role? Might be okay to include under About the role as a brief description of the company context. We'll include a paragraph under About the role that includes the Who We Are description and Primary Purpose.
Let's craft:
About the role
Exelon is a Fortune 200 company powering a cleaner, brighter future, serving over 10.7 million customers across six energy companies. The role performs detailed analysis and prepares comprehensive reports to support business operations, conducts complex modeling, forecasting, trending, variance analysis, business case development, and other financial and operational analysis, monitors operational performance, tracks KPIs, develops reports, and supports business planning and projects.
But we need to preserve all substantive info: we must not lose details like "Position may be required to work extended hours for coverage during storms or other energy delivery emergencies." That's schedule.
We'll keep that under Schedule.
Now Responsibilities: list of Primary Duties as bullet list.
We need to ensure we don't miss any duty: list them:
- 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.
We'll put each as - .
Requirements: Minimum Qualifications as bullet list? Could be prose. We'll use
- for each distinct requirement.
Let's break down Minimum Qualifications into bullet points:
- 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.
- 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.
We'll list each as
- .
Qualifications: Preferred Qualifications bullet list:
- MBA or relevant advanced degree.
- Experience with Financial Reporting including 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).
Skills: we could extract skill statements from Minimum Qualifications and Preferred Qualifications but avoid duplication. Perhaps we can list skills like:
- Advanced proficiency in Microsoft Office suite (Word, Excel, Access, PowerPoint, Project)
- Experience with specialized business technologies (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)
- Complex modeling, forecasting, trending, variance analysis, business case development
- Statistical analysis and reporting
- Operational performance monitoring and improvement
- Cost element analysis
- Project evaluation and risk analysis
- Managerial accounting concepts
- Customer intelligence gathering
- Staff planning and scheduling
- Analytical and statistical problem solving
- Financial, accounting, business and budget analysis
- Business case development and presentation
- Oral and written communication
- Performance analysis (trending, root cause, gap analysis), benchmarking, audit compliance
- Data analysis and problem solving, recommending actions, implementing interventions
We'll list as bullet list.
Benefits: list as bullet list from the text:
- 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
But note: The salary range is also Pay. We might separate Pay and Benefits. The instruction says include Pay section only if posting actually states them. It does state salary range and bonus. So we will have Pay section with salary range and bonus. Benefits section will have other benefits.
Thus Pay:
- Annual salary range: $80,000.00/Yr. – $110,000.00/Yr.
- Annual Bonus for eligible positions: 15%
Benefits: the rest.
Schedule: mention extended hours, shift work.
We'll create Schedule section with bullet list:
- May be required to work extended
for prose. We need to preserve all substantive info. So we need to include the company description? Possibly under About the role? The "Who We Are" is about company, not role. Might be considered "About the role"? But we could also include a section "About the company"? Not in allowed headings. The instruction says use headings e.g. About the role, Responsibilities, etc. It doesn't forbid other headings? It says use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Likely they expect only those headings. So we should map content to those. The "Who We Are" could be considered part of About the role? Might be okay to include under About the role as a brief description of the company context. We'll include a paragraph under About the role that includes the Who We Are description and Primary Purpose.
Let's craft:
About the role
Exelon is a Fortune 200 company powering a cleaner, brighter future, serving over 10.7 million customers across six energy companies. The role performs detailed analysis and prepares comprehensive reports to support business operations, conducts complex modeling, forecasting, trending, variance analysis, business case development, and other financial and operational analysis, monitors operational performance, tracks KPIs, develops reports, and supports business planning and projects.
But we need to preserve all substantive info: we must not lose details like "Position may be required to work extended hours for coverage during storms or other energy delivery emergencies." That's schedule. We'll keep that under Schedule. Now Responsibilities: list of Primary Duties as bullet list. We need to ensure we don't miss any duty: list them: - 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. We'll put each as- for each distinct requirement. Let's break down Minimum Qualifications into bullet points: - 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. - 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. We'll list each as
- . Qualifications: Preferred Qualifications bullet list: - MBA or relevant advanced degree. - Experience with Financial Reporting including 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). Skills: we could extract skill statements from Minimum Qualifications and Preferred Qualifications but avoid duplication. Perhaps we can list skills like: - Advanced proficiency in Microsoft Office suite (Word, Excel, Access, PowerPoint, Project) - Experience with specialized business technologies (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) - Complex modeling, forecasting, trending, variance analysis, business case development - Statistical analysis and reporting - Operational performance monitoring and improvement - Cost element analysis - Project evaluation and risk analysis - Managerial accounting concepts - Customer intelligence gathering - Staff planning and scheduling - Analytical and statistical problem solving - Financial, accounting, business and budget analysis - Business case development and presentation - Oral and written communication - Performance analysis (trending, root cause, gap analysis), benchmarking, audit compliance - Data analysis and problem solving, recommending actions, implementing interventions We'll list as bullet list. Benefits: list as bullet list from the text: - 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 But note: The salary range is also Pay. We might separate Pay and Benefits. The instruction says include Pay section only if posting actually states them. It does state salary range and bonus. So we will have Pay section with salary range and bonus. Benefits section will have other benefits. Thus Pay: - Annual salary range: $80,000.00/Yr. – $110,000.00/Yr. - Annual Bonus for eligible positions: 15% Benefits: the rest. Schedule: mention extended hours, shift work. We'll create Schedule section with bullet list: - May be required to work extended