AI-Driven Financial Forecasting Analyst

Freddie Mac; McLean (VA); On-site; USD 86,000 - 128,000; Full time

Benefits offered by this job

Competitive compensation

Total rewards package

Job summary

Freddie Mac is seeking a Financial Forecasting Modeling Professional to join the Investments and Capital Markets CFO team in McLean, VA. You will support monthly/quarterly/annual forecasts, perform scenario analyses, and deliver insightful management reporting.

The role emphasizes automation, AI-assisted workflows, and building dashboards to improve finance processes while partnering with cross-functional teams and ensuring data integrity for capital markets planning and stress testing

Qualifications

• 2-4 years of experience in Financial Forecasting, FP&A, Financial Reporting and Analytics, Corporate Finance, or related finance functions.
• Bachelor’s degree in Finance, Accounting, Economics, Statistics, Data Analytics, Business Analytics, or a related field preferred.
• Knowledge of GAAP financial accounting and reporting concepts.
• Strong financial acumen, analytical capability, and attention to detail.
• Advanced proficiency in Microsoft Excel and PowerPoint.
• Experience with data visualization, BI, or dashboarding tools preferred.
• Interest in automation, AI-assisted workflows, or analytics tools that improve finance and reporting processes.
• Experience with Microsoft Copilot, Python, SQL, Power Automate, Power Apps, or similar tools is a plus.

Responsibilities

• Support monthly, quarterly, and annual financial forecasts, including Freddie Mac’s annual DFAST stress testing and related Capital Markets planning deliverables.
• Develop financial analyses and calculations to support forecast execution, scenario modeling, variance analysis, and business performance reporting.
• Analyze segment results and forecast changes, including amortization, fair value changes, net interest income, market conditions, and Capital Markets activity.
• Partner with finance and business teams to understand assumptions, validate inputs, improve forecast accuracy, and strengthen business explanations.
• Identify opportunities to improve forecasting, analysis, and reporting processes.
• Prepare recurring business analysis for Investments and Capital Markets Finance, including metrics, trends, risks, and opportunities.
• Support requirements, testing, and enhancements for forecasting applications, reporting tools, and finance processes.
• Prepare management and Board reporting on financial results, forecast changes, business performance, risks, and opportunities.
• Support presentations and executive materials for senior management, business partners, and governance forums.
• Communicate analytical results and conclusions to finance leadership, business segments, and cross-functional partners.
• Develop dashboards, reports, and analytical views that improve business monitoring and reduce manual reporting.
• Automate and scale recurring reporting, forecast support, business metrics, and data preparation processes.
• Use AI-enabled tools responsibly to support forecast narratives, variance explanations, documentation, data quality reviews, and workflow efficiency.
• Support special projects and ad hoc analyses as business priorities, products, risks, and reporting needs evolve.

Skills

Forecasting

Excel

PowerPoint

Data visualization

Python

SQL

Forecasting tools

Education

Bachelor’s degree

Tools

Power BI

Power Automate

Power Apps

Copilot

Job description

Freddie Mac is seeking a Financial Forecasting Modeling Professional to join the Investments and Capital Markets CFO team in McLean, VA. You will support monthly/quarterly/annual forecasts, perform scenario analyses, and deliver insightful management reporting.

The role emphasizes automation, AI-assisted workflows, and building dashboards to improve finance processes while partnering with cross-functional teams and ensuring data integrity for capital markets planning and stress testing