Senior Manager FP&A
KMS Technology is seeking a strategic, systems-minded Senior Manager, FP&A — Global
Forecasting & Financial Data to act as a senior business partner to the Global Head of FP&A and
the hub for the company’s forecasting and financial data infrastructure. Based in the Americas, this
role provides critical same-hemisphere coverage for the Global Head of FP&A and owns the
integrity, structure, and accessibility of the data and models that drive KMS’s financial forecasts.
This is a build-and-own individual-contributor role, not a people-management role. The successful
candidate will make KMS’s financial data directly usable: surfacing information from source systems
and Power BI into clean, standardized “Excel databases” that anyone — from the Global Head of
FP&A to executive stakeholders — can analyze through Excel pivot tables. They will also lead the
evolution of our current spreadsheet-based forecasts into a single, cohesive, linked financial
statistics-based model, combining deep modeling expertise with strong data discipline.
Key Responsibilities
Financial Data & Excel Databases (Single Source of Truth)
• Own the design and maintenance of KMS’s standardized “Excel databases” — clean, flat,
pivot-ready tables that surface data from source systems and Power BI into Excel, so the
Global Head of FP&A and others can build answers directly through pivot tables.
• Define standardized data extracts: consistent schema, consistent formats, and fixed extraction
cut-off times, so pipe-to-revenue-to-cost data are always aligned to the same point in time.
• Partner closely with the Vietnam-based pipeline data analyst who maintains the Power BI
database to ensure system and Power BI data flow cleanly and consistently into the Excel
databases.
• Establish and enforce data governance and documentation — naming conventions, refresh
cadence, and version control — so the data is reliable, repeatable, and auditable.
• Keep the Excel databases the accessible, self-serve front end for analysis, complementing (not
replacing) Power BI used upstream.
Cohesive Financial Model — Build & Transition
• Lead the transition from today’s separate Google Sheets and Excel files — currently
consolidated manually into a single workbook on request — to a structured set of linked Excel
workbooks that operate as one cohesive financial model.
• Architect the model: define module boundaries (e.g., pipeline-to-revenue, cost of services and
gross margin, Europe, consolidation and outputs), linking logic, input/calculation/output
separation, and clear ownership for each component.
• Establish modeling standards and controls — consistent formats, documented assumptions,
error checks, and audit trails — so the integrated model is robust, transparent, and easy to
maintain.
• Partner with the Accounting team to redesign and replace the current manual consolidation
process, so the model meets executive reporting needs on demand rather than on request.
• Continuously improve the model’s structure, accuracy, and usability as the business and data
sources evolve.
Forecasting & Business Partnering
• Own the development of the consolidated forecast model, integrating pipeline/revenue,
cost/gross-margin, and Global inputs into a coherent company forecast.
• Perform weekly Funnel-to-Cash and monthly forecasts and Latest Estimate (LE) updates, and
comparative analysis (actual vs. forecast vs. budget), interpreting variances and trends to
support decision-making.
• Support the annual budgeting exercise and scenario / sensitivity modeling across business
lines and regions.
• Act as a trusted analytical partner to the Global Head of FP&A on revenue, cost, margin ,
OPEX, etc. performance.
Advanced Analytics & Forecasting Innovation
• Serve as the Global Head of FP&A’s right hand in taking financial modeling to the next level of
analytics, applying best-practice numerical methods — including regression analysis, Monte
Carlo simulation, and other statistical technique