FP&A Data Analytics & AI Strategy, Sr. Manager (New York City)

Location: This is a hybrid remote/in-office role.

Medidata follows a hybrid office policy in which employees who are hired for an in-person position are expected to work on site a certain number of days per week following Company policy.

About our Company: Medidata is powering smarter treatments and healthier people through digital solutions to support clinical trials. Celebrating over 25 years of ground-breaking technological innovation across more than 38,000 trials and 12 million patients, Medidata offers industry-leading expertise, analytics-powered insights, and one of the largest clinical trial data sets in the industry. More than 1 million registered users across approximately 2,300 customers trust Medidata’s seamless, end-to-end platform to improve patient experiences, accelerate clinical breakthroughs, and bring therapies to market faster. A Dassault Systèmes brand (Euronext Paris: FR0014003TT8, DSY.PA), Medidata is headquartered in New York City and has been recognized as a Leader by Everest Group and IDC. Discover more at www.medidata.com. Listen to our latest podcast, from Dreamers to Disruptors, and follow us at @Medidata.

About the Team: The Senior Manager, Data Transformation will serve as the strategic and operational lead for the data, analytics, and reporting function supporting the FP&A organization. This is an individual contributor role responsible for the end-to-end data architecture, day-to-day reporting operations, and the long-term transformation roadmap that enables Finance to deliver faster, more accurate, and more insightful business partnership.

The ideal candidate is a proactive, hands-on practitioner who blends finance domain knowledge with strong data analysis, business intelligence, and process transformation capabilities. They will anticipate stakeholder needs, identify opportunities without being asked, and partner closely with FP&A, Accounting, IT, and Data Engineering teams to modernize how financial data flows, is modeled, analyzed, and consumed across the enterprise — driving a shift from manual, spreadsheet-based reporting to scalable, automated, self-service analytics.

Responsibilities: Data Strategy & Transformation Leadership

• Define and execute the multi-year data and reporting transformation roadmap for FP&A, aligned with broader Finance and enterprise data strategy.
• Lead the design and evolution of the FP&A data architecture, including data sources, integration layers, financial data models, and the semantic / reporting layer.
• Partner with IT, Data Engineering, and Enterprise Data teams to ensure FP&A requirements are represented in enterprise data platforms (e.g., data warehouse, lakehouse, master data, ERP).
• Champion a shift from manual, spreadsheet-driven processes toward automated, governed, and scalable reporting and planning solutions.
• Build the business case for transformation initiatives, including ROI, resource needs, and change management considerations.

Day-to-Day Data & Reporting Operations

• Own end-to-end delivery of recurring FP&A reporting cycles, including monthly close reporting, management reporting packages, board materials, and ad hoc executive requests.
• Ensure the accuracy, timeliness, completeness, and consistency of all financial data and reports consumed by FP&A and business stakeholders.
• Establish and maintain SLAs, controls, and reconciliation processes between source systems (e.g., ERP, CRM, HRIS) and the FP&A reporting environment.
• Serve as the escalation point for data issues, reporting discrepancies, and stakeholder requests, driving root-cause analysis and durable fixes.
• Maintain documentation, data dictionaries, and lineage for key FP&A datasets, metrics, and KPIs.
• Serve as the business owner and administrator of the FP&A forecasting / planning tool, including model maintenance, hierarchy and metadata updates, user access, integrations, and ongoing enhancements to support planning and forecasting cycles.

Process Transformation & Automation

• Identify and prioritize opportunities to streamline, standardize, and automate FP&A processes across planning, forecasting, reporting, and analytics.
• Lead the design and implementation of automated data pipelines, ETL/ELT workflows, and reporting solutions that replace manual Excel-based processes.
• Deploy modern BI and visualization tooling (e.g., Power BI, Tableau, Looker) to deliver self-service analytics for f…