Data Modeler
Priyanka GuptaRemoteSENIORPosted 48m ago
Oracle FusionDatabricksSQLPySpark
About the Role
We are looking for a Data Modeler to join our team for a 6-week contract role that may be extended. This position involves mapping Oracle Fusion and other Bronze sources into the canonical Silver model on Databricks.
Key Responsibilities
• Investigate connections across source objects and business domains
• Define keys, cardinality, and join paths that optimize data access
• Resolve identities across systems and business units
• Define entities, attributes, and record grain
• Establish consistent business definitions of shared data
• Map Oracle Fusion objects and fields to data model entities
• Define transformations, reference-code mappings, and history rules
• Use Databricks SQL/PySpark to profile data and validate modeling assumptions
• Verify uniqueness, referential integrity, and reconciliation to source totals
• Produce entity diagrams and implementation-ready mappings
Requirements
• 7+ years of experience in data modeling
• Experience with Oracle Fusion and Databricks
• Proficiency in SQL and PySpark
• Understanding of procurement, supplier, finance, and treasury processes
• Ability to work with SMEs and engineers to deliver implementation-ready mappings