Data-Driven FP&A Analyst — Hybrid, Insights & Dashboards

Aaa Central Penn; Harrisburg (Dauphin County); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Paid Time Off

401k with company match

Free AAA Premier membership

Travel Discounts

Opportunities for growth

Job summary

AAA Central Penn is seeking a Business Analyst to transform data into actionable insights that drive strategic decisions in finance and operations.

You’ll partner with Finance and leaders to build models, analyze trends, and support budgeting, forecasting, and reporting. Strong Excel, Power BI, and MS 365 skills are essential, with a nimbly analytical mindset and clear communication across audiences.

Qualifications

• Bachelor’s degree in Finance, Accounting, Business, Economics, or related field.
• 2–4 years of experience in financial analysis, FP&A, or business analysis.
• Strong analytical and problem-solving skills—you’re comfortable exploring data and interpreting financial results.
• The ability to explain complex analysis in clear, practical terms for non-financial audiences.
• Advanced Excel skills and strong working knowledge of Microsoft 365 (Outlook, Word, PowerPoint, SharePoint, Teams, and Copilot).

Responsibilities

• Partner with teams across the organization to understand how the business works—and turn questions into clear metrics, analysis, and insights
• Collect, validate, and analyze financial and operational data to uncover trends, risks, variances, and opportunities
• Support monthly, quarterly, and annual reporting with clear variance explanations that actually make sense to stakeholders
• Help power budgeting and forecasting through financial modeling, scenario planning, and thoughtful assumptions
• Compare actual results to budgets and forecasts, dig into the “why,” and recommend smart, data-backed actions
• Build and maintain Excel-based models, dashboards, KPI scorecards, and reporting templates (bonus points for automation!)
• Create presentations and executive summaries that tell a compelling data story—not just a wall of numbers
• Jump into ad hoc analysis when needed, including project cost tracking, ROI/payback analysis, and special initiatives

Skills

Financial analysis

FP&A

Data storytelling

Advanced Excel

Power BI

Communication

Education

Bachelor’s degree in Finance/Accounting/Business

Tools

Excel

PowerPoint

SharePoint

Teams

Copilot

Power BI

Job description

AAA Central Penn is seeking a Business Analyst to transform data into actionable insights that drive strategic decisions in finance and operations.

You’ll partner with Finance and leaders to build models, analyze trends, and support budgeting, forecasting, and reporting. Strong Excel, Power BI, and MS 365 skills are essential, with a nimbly analytical mindset and clear communication across audiences.