Business Analyst with AAA Central Penn

AAA Central Penn•Harrisburg, PA

2d•Hybrid

About The Position

The Business Analyst partners with Finance and business leaders to turn financial and operational data into insights that support strategy, performance, and results. The role involves understanding business operations, developing useful metrics and analysis, and communicating findings to stakeholders in clear, practical terms. The analyst supports financial reporting, budgeting, and forecasting; builds and maintains Excel-based models, dashboards, KPI scorecards, and reporting templates; and prepares presentations and executive summaries. The role also handles ad hoc analysis, including project cost tracking, ROI and payback analysis, and special initiatives. The position works in a hybrid environment.

Requirements

Bachelor’s degree in Finance, Accounting, Business, Economics, or a related field, or equivalent experience.
2–4 years of experience in financial analysis, FP&A, or business analysis.
Strong analytical and problem-solving skills, including the ability to explore data and interpret financial results.
Ability to explain complex analysis in clear, practical terms for non-financial audiences.
Advanced Excel skills and strong working knowledge of Microsoft 365, including Outlook, Word, PowerPoint, SharePoint, Teams, and Copilot.
Attention to detail and commitment to accuracy and quality.
Strong organization and time-management skills, with the ability to manage priorities and meet deadlines in a hybrid environment.
Ability to turn business questions into metrics, dashboards, and meaningful visuals.

Nice To Haves

Power BI experience.
Experience automating reporting templates or processes.

Responsibilities

Partner with teams across the organization to understand business operations and translate questions into metrics, analysis, and insights.
Collect, validate, and analyze financial and operational data to identify trends, risks, variances, and opportunities.
Support monthly, quarterly, and annual reporting with clear variance explanations for stakeholders.
Support budgeting and forecasting through financial modeling, scenario planning, and thoughtful assumptions.
Compare actual results with budgets and forecasts, investigate variances, and recommend data-backed actions.
Build and maintain Excel-based models, dashboards, KPI scorecards, and reporting templates, including opportunities for automation.
Create presentations and executive summaries that communicate data insights effectively.
Perform ad hoc analysis, including project cost tracking, ROI and payback analysis, and special initiatives.