Data Lead – Finance/SAP/Life science

Role-Data Lead – Finance/SAP/Life science

Location: US-based, Remote | Occasional travel for key workshops

About the Role

Our client, a global biopharmaceutical company, is building a modern Finance Data Foundation on Databricks . We are seeking a Finance Data Design Lead to translate the Finance Data Strategy and Architecture into practical, reusable data models, mappings, business rules, and technical design specifications.

This is a hands-on data design and delivery leadership role , working closely with Finance, Enterprise Architecture, Data & Analytics, GTS, and development teams. You will define the designs and guide development teams through implementation rather than building the data pipelines yourself.

Key Responsibilities

• Translate Finance business requirements and data strategy into conceptual, logical, and physical data models .
• Define source-to-target mappings, transformation logic, business rules, calculations, hierarchies, and financial definitions .
• Design Finance data products covering P&L, balance sheet, spend/travel, and other core Finance domains .
• Design and integrate data from SAP FI/CO, TM1/IBM Planning Analytics, Concur, Agiloft , and other Finance sources into Databricks.
• Establish data quality, reconciliation, controls, auditability, and traceability requirements.
• Create clear, build-ready design specifications and acceptance criteria for development teams.
• Establish reusable Finance data modeling standards, naming conventions, documentation, and design patterns .
• Partner with Enterprise Architects to ensure designs align with enterprise architecture and governance standards.
• Review development output, resolve design questions, and support testing and business validation.
• Mentor client and partner teams on Finance data design practices.

Required Qualifications

• 10+ years of experience in data management, data warehousing, analytics, and enterprise data design.
• Strong Finance domain knowledge , including P&L, balance sheet, cash flow, chart of accounts, cost/profit centers, hierarchies, multi-currency, and financial close.
• Pharmaceutical / Life Sciences Finance experience is required , including familiarity with areas such as R&D/clinical costs, product/market P&L, intercompany, transfer pricing, and Finance controls.
• Strong SAP Finance experience , including SAP FI/CO, GL, Universal Journal (ACDOCA), cost/profit centers, internal orders, WBS, company codes, and hierarchies.
• Proven experience designing and integrating SAP Finance data into a data warehouse/lakehouse .
• Strong conceptual, logical, and physical data modeling skills.
• Demonstrated experience creating source-to-target mappings, business rules, and development-ready specifications .
• Working knowledge of Databricks/lakehouse architecture , including Delta and Unity Catalog.
• Experience with financial data quality, reconciliation, and controls .
• Excellent communication and facilitation skills with both Finance and technical stakeholders.
• US-based with valid US work authorization and availability during US business hours.

Preferred Qualifications

• SAP BW/BW4HANA, SAP Datasphere, or SAP Analytics Cloud.
• TM1 / IBM Planning Analytics, Oracle EPM, Anaplan, or similar planning platforms.
• Concur, Agiloft, or similar enterprise SaaS platforms.
• Master Data Management experience.
• Power BI semantic modeling and Finance reporting.
• Experience with data modeling and metadata/catalog tools.
• Consulting or client-facing delivery experience.

What Success Looks Like

You will be successful when priority Finance data products are designed and implemented with minimal rework , reusable Finance data models and standards are established, and client teams have a foundation they can continue to extend.

Ideal Profile: A Finance data professional with deep Pharma/Life Sciences and SAP experience who enjoys the details of translating Finance requirements into precise data models, mappings, rules, and specifications that development teams can implement confidently.