Jobs · Information Technology · New York

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

Medidata Solutions · New York, United States · 4 wk ago
HybridInformation Technology$135k–$180k/yrFull-time

About the role

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.

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 finance and business partners.
    • Evaluate and implement EPM / planning platforms (e.g., Anaplan, Pigment, Workday Adaptive, OneStream) and integrations as part of the transformation roadmap.
    • Apply continuous improvement and agile delivery practices to drive measurable cycle-time, accuracy, and productivity gains.
  • Data Architecture & Governance
    • Lead the design and ongoing stewardship of the FP&A data architecture, including financial data marts, dimensional models, hierarchies, and master data (e.g., chart of accounts, cost centers, legal entities, products).
    • Establish data governance, quality, and controls frameworks specific to FP&A, in partnership with enterprise data governance functions.
    • Define standards for metric definitions, source-of-truth datasets, and certified reports to drive consistency across the organization.
    • Ensure FP&A data solutions adhere to security, privacy, SOX, and audit requirements.
  • Stakeholder Partnership & Influence
    • Act as a trusted advisor to FP&A leadership and business partners, translating business questions into data and reporting solutions.
    • Proactively identify gaps, risks, and opportunities in the data and reporting environment — surface them, recommend solutions, and drive them to resolution without waiting to be asked.
    • Partner cross-functionally with IT, Data Engineering, and external vendors to deliver on transformation initiatives, including requirements definition, solution design, and implementation oversight.
    • Drive change management and enablement, including training, documentation, and adoption tracking for new tools and processes.
    • Influence outcomes through expertise and collaboration rather than direct people management.

Qualifications

  • Bachelor's degree in a relevant field (minimum requirement; advanced degrees are not required).
  • 8+ years of progressive, hands-on experience that combines a strong understanding of financials with a data transformation background, including business intelligence, data analysis, and process transformation experience.
  • Solid understanding of financial concepts and FP&A processes (budgeting, forecasting, long-range planning, management reporting, and variance analysis) — enough to partner credibly with finance stakeholders and translate their needs into data solutions.
  • Strong data analysis skills — ability to independently explore, validate, and interpret large financial datasets, surface trends and anomalies, and turn raw data into clear, decision-ready insights.
  • Proven track record delivering business intelligence solutions and modernizing reporting environments (e.g., Power BI, Tableau, Looker), including advanced Excel.
  • Process transformation experience — identifying inefficiencies, redesigning workflows, and implementing automation to drive measurable improvements in cycle time, accuracy, and scalability.
  • Hands-on expertise with modern data platforms and tools such as SQL, data warehouses (e.g., Snowflake, BigQuery, Redshift, Databricks), and ETL/ELT tools (e.g., dbt, Fivetran, Airflow).
  • Hands-on experience owning or administering an EPM / forecasting / planning tool (e.g., Anaplan, Pigment, Workday Adaptive, OneStream, Hyperion), including model design, integrations, and end-user support.
  • Working knowledge of ERP systems (e.g., Oracle, SAP, NetSuite, Workday).
  • Track record of partnering with IT and Data Engineering on data architecture, integration, and governance.
  • Excellent communication skills, with the ability to translate complex data concepts for finance and executive audiences.

Preferred Qualifications

  • Experience in a public company or scaling high-growth environment with SOX compliance requirements.
  • Familiarity with Python or other scripting languages for data manipulation and automation.
  • Experience with AI / ML use cases in Finance (e.g., forecasting, anomaly detection, narrative generation).
  • Prior experience in management consulting, Big 4 advisory, or a Finance Transformation Center of Excellence.

Key Competencies

  • Proactive self-starter — anticipates needs, identifies issues and opportunities ahead of stakeholders, and drives them to resolution without waiting for direction.
  • Strong analytical mindset — naturally curious about data, comfortable digging into details to validate accuracy and uncover insights.
  • Strategic thinking with strong execution discipline — able to set vision and ship results.
  • Bias for action and continuous improvement; comfortable navigating ambiguity.
  • Strong systems thinking; sees data, process, and technology as one operating model.
  • Influential communicator and collaborator across Finance, IT, and the business — able to drive outcomes through expertise and partnership rather than direct authority.
  • Highly self-directed; thrives owning end-to-end work as an individual contributor.

Similar jobs