Business Analyst with AAA Central Penn

AAA Central Penn•Harrisburg, PA

2d•Hybrid

About The Position

AAA Central Penn is seeking a Business Analyst to partner with Finance and business leaders, turning financial and operational data into insights that support strategy, performance, and results. The role involves analyzing data, building financial models, contributing to budgeting and forecasting, and communicating findings to stakeholders through reports, dashboards, and presentations. The position operates in a hybrid environment and includes ad hoc analysis for project cost tracking, ROI/payback analysis, and special initiatives.

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 translate business questions into metrics, dashboards, and meaningful visuals.

Nice To Haves

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

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 by explaining variances to 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 automation where possible.
Create presentations and executive summaries that communicate data findings clearly.
Conduct ad hoc analyses, including project cost tracking, ROI/payback analysis, and work on special initiatives.