Business Analyst at AAA

AAA Central Penn•Harrisburg, PA

3d•Hybrid

About The Position

AAA Central Penn is seeking a Business Analyst to work with Finance and business leaders to turn financial and operational data into insights that support strategy, performance, and business decisions. The role involves investigating data, identifying patterns, building models, explaining results, and communicating analysis to stakeholders. The Business Analyst supports reporting, budgeting, and forecasting; compares actual results with budgets and forecasts; and develops Excel-based models, dashboards, KPI scorecards, and reporting templates. The role also prepares presentations and executive summaries and performs ad hoc analysis, including project cost tracking, ROI/payback analysis, and special initiatives. The position operates 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.
Excellent organization and time-management skills, with the ability to juggle priorities and meet deadlines in a hybrid environment.
Ability to translate business questions into metrics, dashboards, and meaningful visuals.

Nice To Haves

Power BI experience.
Experience automating Excel-based models, dashboards, or reporting templates.

Responsibilities

Partner with teams across the organization to understand business operations and turn 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 explanations of variances.
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 automation where applicable.
Create presentations and executive summaries that communicate data insights effectively.
Perform ad hoc analysis, including project cost tracking, ROI/payback analysis, and analysis for special initiatives.