Note: The job is a remote job and is open to candidates in USA. Silicontek Inc is supporting a global biopharmaceutical company building a modern Finance Data Foundation on Databricks. The Finance Data Design Lead will translate Finance strategy and requirements into reusable data models, mappings, business rules, and technical specifications, while guiding development teams and collaborating with Finance, architecture, analytics, and technical stakeholders.
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
Skills
- 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
- 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
Benefits
- US-based, Remote
- Occasional travel for key workshops
Company Overview