Required Skills & Experience
Must-haves
- 12+ years in FP&A and finance transformation, with deep consulting experience: has led multiple client engagements from diagnostic through roadmap.
- Deep understanding of finance data and systems: can map how information flows between Excel, Anaplan, Oracle Hyperion and SAP, down to hierarchies, interfaces, KPIs and reports.
- Functional and technical in equal measure: credible with finance leaders on planning process, and able to read a planning model, an interface specification or a data extract.
- Pharmaceutical or life sciences commercial finance experience: brand and indication-level planning, launch cost planning, and cost allocations, including alliance or co-commercialization arrangements.
- Comfortable presenting to and challenging senior commercial and finance leaders. Required skills
- Strong command of budgeting, forecasting, long-range planning, opex and cost-center planning, variance analysis and management reporting.
- Functional depth in Oracle Hyperion / Oracle EPM and Anaplan, deep in at least one: dimensions, hierarchies, model structure, allocations and reporting.
- Solid understanding of SAP finance data (GL, cost centers, actuals) and how it feeds planning platforms.
- Data fluency: source-to-report lineage, KPI definition, reconciliation between systems, and working directly with data extracts. SQL is a plus.
- Working knowledge of workforce and headcount planning and its reconciliation with HR systems such as Workday.
- Experience with hierarchy and mapping governance across finance systems.
- Skilled at structured interviews, process and data-flow mapping, requirements definition and workshop facilitation.
- Clear executive-level writing and presentation skills.
- Bachelor's degree in finance, accounting, information systems or a related field.
Nice to Have Skills & Experience
Preferred qualifications
- Big Four or specialist finance-transformation consulting background.
- Time in an in-house pharma FP&A team in addition to consulting.
- Experience in oncology or other multi-indication, launch-heavy portfolios.
- Exposure to SAP FI/CO, SAP S/4HANA Finance or SAP BW.
- Experience with Hyperion Planning, Essbase or Oracle EPM Cloud; Anaplan certification.
- Experience connecting planning tools through a shared data platform or semantic layer.
- Exposure to AI-assisted planning and analytics tools.
- MBA, CPA or CMA.
Job Description
About PCGI PCGI (Parab Consulting Group, Inc.) is a boutique consulting firm specializing in Life Sciences. We combine management consulting with deep data and technology capability to help pharmaceutical organizations get value from large and complex datasets. The role We are hiring a senior FP&A transformation consultant to lead our finance planning work. You will work directly with commercial and finance teams to diagnose how cost planning, budgeting and headcount planning run today, define the target state, and build the roadmap to reach it. This is not a pure FP&A operations role. You are a consultant who is functional and technical enough to do both halves of the job: hold a room of finance leaders on planning process, then trace a number from a spreadsheet through Anaplan, Hyperion and SAP to the report it lands in. PCGI's data and engineering teams build what you design. What you will do Discovery and diagnostic
- Lead working sessions and one-on-one interviews with commercial and finance teams, headcount planners, IT system owners and budget owners.
- Map process and information flow end to end across Excel, Anaplan, Oracle Hyperion and SAP: data elements, hierarchies, mappings, allocation rules, interfaces, reconciliation points and manual hand-offs.
- Inventory the KPIs and reports in use, and document where each number comes from and how it is calculated.
- Trace real changes through the process (an allocation change, a launch delay, a new hire) to show where they break.
- Assess planning capability maturity and quantify the effort tied up in manual work. Target state and roadmap
- Translate leadership objectives into detailed functional and data requirements and a prioritized, phased roadmap.
- Define requirements for allocation rule governance, scenario planning, launch cost planning, and brand and indication-level reporting.
- Evaluate target options with IT across Oracle Hyperion, Anaplan, SAP and workforce planning tools, and recommend a path.
- Write and present the findings, business case and roadmap to finance and IT leadership. Delivery leadership
- Act as functional lead for the phases that follow: guide solution design, own functional sign-off, and oversee user acceptance and adoption.
- Work with PCGI data engineering and analytics teams so that financial data flows correctly between source systems and planning platforms.
- Lead change management for a large community of budget owners.