Clinical Forecasting Specialist - Sponsor Dedicated

The person providing these services is involved in clinical out of pocket (OOP) planning from the concept phase through execution and closeout and is responsible for clinical out of pocket cost forecasting and supporting budget creation and management for assigned projects.

Essential Functions:
• Conduct monthly review and analysis of assigned projects, including review of revenue recognition, project performance variances, and unbilled/unearned positions.  Monitor monthly compliance reports, to ensure timely reporting of revenue and billing deliverables by Project Manager.
• Prepare monthly reporting requirements for assigned projects, including unsigned contract opportunities, backlog, and other ad-hoc financial analysis as required.
• Review and approve work movements and changes, and final remaining revenue adjustment for assigned projects.
• Ensure project journal, write-offs, and financial adjustments are properly documented, reviewed and approved.
• Monitor Unbilled, Write-off activity, Over the Limit and Contract Activation exception reports and resolve/escalate unusual activity.
• Coordinate loading of global project budgets to financial management system, including collection of non IQVIA International Pricing (QIP) supported budgets. Review / reconcile loaded project budgets to ensure accuracy against contracted values.
• Coordinate loading of payment schedule.  Review / reconcile loaded project payment schedule to ensure accuracy against contracted values and compliance to negotiated contract terms.
• Coordinate configuration of Project and Contract modules, including assignment of Rate Sets / Plans to Activities, configuration of Contract Lines and establishment of Billing / Revenue Limits.
• Monitor and action monthly compliance reports, to ensure timely reporting of revenue and billing deliverables by Project Manager.
• Review / monitor rate exception reports and coordinate resolution of rate issues in a timely manner with the Global Project Services Group.
• Ensure review and completion of Project Check-off list throughout the project lifecycle (Activation, Configuration and Close-out).
• Complete project close-out procedures and communicate Project Status Action to the Global Project Services Support Group.
• Perform project level unbilled/unearned reconciliations as required.
• Complete assigned Monthly and Quarterly Sarbanes Oxley reporting requirements.
• Train and mentor more junior support staff.
• Will be assigned responsibility for projects, customers, and/or programs.
• Perform other duties as assigned.

Qualifications:
• Bachelor's Degree
• 3 years’ experience with 2 years of experience within a drug development environment.
• Equivalent combination of education, training and experience.
• Knowledge of revenue recognition, variance analysis, unbilled/unearned and cash flow management, backlog forecasting, and clinical trial forecasting.
• Knowledge of Peoplesoft Project.
• Experience with with tools and systems such as Planisware, Cognos, Beacon, Medidata, Tableau, Advanced Excel is preferred.
• Technical accounting skills.
• Good analytical and numeracy skills.
• Ability to identify financial issues and execute mitigating actions.
• Ability to prioritize and coordinate multiple work requirements to meet deadlines.
• Ability to establish and maintain effective working relationships with co-workers, managers and clients.

Travel expectation is 5%

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at https://jobs.iqvia.com