FP&A Analyst

Frederick Fox LLC; Rockford (IL); On-site; USD 70,000 - 95,000; Full time

Job summary

Frederick Fox LLC seeks an FP&A Analyst to support planning, budgeting, forecasting, and performance analysis. The role focuses on translating complex financial data into actionable insights, building models, and delivering clear reporting for leadership.

The ideal candidate combines strong financial knowledge with advanced Excel and Power BI skills and possesses effective communication for both finance and non-finance stakeholders.

Qualifications

• Bachelor's degree in Finance, Accounting, or related field or equivalent experience.
• Experience in FP&A including budgeting, forecasting, modeling, and reporting.
• Strong ability to interpret financial data and present insights clearly.
• Advanced Excel skills with complex formulas and modeling capabilities.
• Experience creating dashboards with Power BI.

Responsibilities

• Develop, maintain, and update financial models, budgets, and forecasts.
• Analyze actual results against budgets to identify trends and risks.
• Build and enhance dashboards to improve visibility of financial metrics.
• Perform data analysis and support planning initiatives.
• Prepare data-driven analyses and reports for leaders and stakeholders.
• Collaborate with FP&A, Accounting, Data, and Tech teams to support decisions.
• Identify opportunities to streamline budgeting, forecasting, and reporting processes.
• Ensure data integrity and documentation for financial reports.
• Explore new technologies to improve reporting and efficiency.
• Conduct ad hoc analyses to support business objectives.

Skills

Financial modeling

Budgeting and forecasting

Data analysis

Communication

Cross-functional collaboration

Education

Bachelor's degree in Finance

Tools

Excel

Power BI

ERP systems

SQL

Workday Adaptive Planning

Job description

Financial Planning & Analysis (FP&A) Analyst

Position Overview

We are seeking a detail-oriented and analytical Financial Planning & Analysis (FP&A) Analyst to support financial planning, budgeting, forecasting, and business performance analysis. This individual will play an important role in transforming complex financial data into actionable insights that support strategic decision-making across the organization.

The FP&A Analyst will develop and maintain financial models, analyze financial performance, create reporting dashboards, and collaborate with cross-functional teams to improve financial visibility and planning processes. The ideal candidate combines strong financial knowledge with advanced technical skills, particularly in Excel and Power BI, and can communicate financial insights effectively to both finance and non-finance stakeholders.

Key Responsibilities

• Financial Planning and Forecasting: Develop, maintain, and update financial models, budgets, and forecasts covering headcount, income statements, balance sheets, cash flow, and capital planning.
• Financial Performance Analysis: Analyze actual financial results against budgets, forecasts, and historical performance to identify trends, variances, key business drivers, risks, and opportunities.
• Reporting and Dashboards: Build, maintain, and enhance financial dashboards and reports using Microsoft Power BI to improve visibility into organizational performance and key financial metrics.
• Financial Modeling and Data Analysis: Use advanced Microsoft Excel capabilities to analyze large and complex datasets, develop financial models, and support business planning initiatives.
• Management Reporting: Prepare clear, accurate, and data-driven financial analyses, presentations, and reports for department leaders, executives, committees, and board-level stakeholders.
• Cross-Functional Collaboration: Partner with FP&A, Accounting, Data, Technology, and other business functions to support financial planning, reporting, and operational decision-making.
• Process Improvement and Automation: Identify opportunities to streamline and automate budgeting, forecasting, financial reporting, and analytical processes to improve efficiency and accuracy.
• Data Integrity and Documentation: Maintain accurate, consistent, and well-documented financial reports, models, data sources, and reporting methodologies.
• Technology and Innovation: Explore and evaluate emerging technologies, including artificial intelligence (AI), to improve financial processes, reporting capabilities, and analytical efficiency.
• Ad Hoc Analysis: Perform special financial analyses and support business initiatives as needed to provide insights into financial performance and organizational objectives.

Qualifications

• Bachelor's degree in Finance, Accounting, Business Administration, Economics, or a related field, or an equivalent combination of education and relevant professional experience.
• Professional experience in Financial Planning & Analysis (FP&A), including budgeting, forecasting, financial modeling, and financial reporting.
• Strong financial and analytical skills, with the ability to interpret complex financial information, identify trends, and communicate meaningful insights.
• Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, data analysis, and financial modeling.
• Hands-on experience developing financial reports and dashboards using Microsoft Power BI.
• Strong analytical, problem-solving, and critical-thinking skills with excellent attention to detail.
• Effective written and verbal communication skills, including the ability to present financial findings to non-finance audiences.
• Strong interpersonal and collaboration skills with the ability to work across different departments and organizational levels.
• Ability to work independently, manage multiple priorities, and meet deadlines in a fast-paced environment.

Preferred Qualifications

• Experience in wealth management, asset management, banking, investments, or the broader financial services industry.
• Familiarity with FP&A and financial planning platforms such as Workday Adaptive Planning.
• Experience working with ERP, accounting, or financial management systems.
• Exposure to SQL, Python, or other data analysis and programming tools.
• Experience improving or automating financial reporting, budgeting, forecasting, or analytical processes.
• Interest in leveraging emerging technologies and AI tools to enhance financial analysis and business operations.