FP&A Analyst - Budgeting and Automation
$75,000–$110,000 year
HybridCentennial, Colorado, United States
Job Summary
FP&A Analyst focused on budgeting and automation will own expense forecasting, monthly close support, and cross-functional partnership with Accounting, AP, and Treasury. Responsibilities include building/maintaining variance analyses and management commentary, developing and automating data pipelines from ERP/data warehouse sources into finance models, and designing workflow architecture to streamline planning cycles. The role emphasizes delivering an operating plan and rolling forecast, producing management reporting packages, and driving process improvements through automation. Requires a Bachelor’s in a quantitative field, 3–6 years in FP&A, strong Excel skills, ERP experience (D365 preferred), Power BI or other BI tools, and the ability to work in Centennial, CO on a Tue-Thu in-office schedule.
Required Qualifications
- Bachelor's degree in Finance, Accounting, Economics, or related quantitative field
- 3 to 6 years of FP&A, corporate finance, or closely related experience
- Demonstrated ownership of a budget or planning cycle
- Ability and interest to work in office Tuesday through Thursday in Centennial, CO
- Advanced Excel skills including financial modeling, dynamic scenarios, and structured workbook design
- Experience with ERP systems; Microsoft Dynamics 365 (D365) strongly preferred
- Demonstrated ability to manage priorities, hit deadlines, and operate with limited direction in a fast-moving environment
- Strong written and verbal communicator with the ability to translate financial data into operational insight
- Hands-on experience with at least one data visualization or BI platform (Power BI preferred)
- Practical experience with data prep, Power Query, Power Automate, or similar workflow automation tooling, not just awareness
- Ability to connect data sources (ERP, data warehouse) into downstream finance models with minimal manual intervention
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.