FP&A Analyst - Revenue
$75,000–$110,000 year
HybridCentennial, Colorado, United States
Job Summary
FP&A Analyst - Revenue role responsible for building and maintaining a bottoms-up revenue and gross margin model by integrating pipeline data, booking trends, and product mix assumptions to deliver a weekly executive forecast. Collaborates with senior leadership to support the annual budget cycle and rolling forecast, develops variance analysis and management commentary, and creates reports/dashboards tracking revenue KPIs. Requires understanding of how hardware, software, and services revenue recognize and interact across cycles;leverages Salesforce pipeline data; seeks opportunities for process automation and workflow improvements; and communicates insights to cross-functional teams. Ideal candidate has built revenue models, can distinguish pipeline-coverage vs bottom-up bookings approaches, and can challenge assumptions with quantitative trend data. Strong Excel modeling, ERP experience (D365 preferred), CRM familiarity, and experience with BI tools like Power BI are valued; CPA/CFA candidate or progress toward certification is a plus.
Required Qualifications
- Bachelor's degree in Finance, Accounting, Economics, or a related quantitative field
- 4 to 7 years of FP&A or finance experience with direct exposure to revenue forecasting, commercial planning, or sales finance
- Ability and interest to work in office Tuesday through Thursday in Centennial, CO
- Familiarity with CRM data (Salesforce preferred) and how pipeline data translates to financial forecasts
- Experience modeling a multi-stream revenue environment with mixed recognition treatments across hardware, software, and services strongly preferred
- Advanced Excel skills including financial modeling, dynamic scenarios, and structured workbook design
- Experience with ERP systems; Microsoft Dynamics 365 (D365) strongly preferred
- Strong written and verbal communicator with the ability to translate financial data into operational insight
- Demonstrated ability to manage priorities, hit deadlines, and operate with limited direction in a fast-moving environment
- Power BI or comparable BI/visualization platform experience
- SQL or data querying exposure
- Experience with planning tools such as Adaptive Insights, Anaplan, Vena, Planful, or equivalent
- Experience with Power Automate, Power Query, or similar workflow automation tooling
- Public company or multi-entity reporting environment
- CPA, CFA candidate, or progress toward certification
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.