Databricks Data Modeler Consultant

We are seeking a Databricks Data Modeler (Enterprise Supply Chain & Analytics) to design, optimize, and maintain enterprise data modeling solutions on Microsoft Azure. This role spans supply chain and cross-enterprise analytics, delivering trusted datasets consumed by reporting/dashboards, AI/ML pipelines, and application integrations. You will work within Unity Catalog to ensure governed, well-documented, and secure data products across the organization.Location: US RemoteType: ContractResponsibilitiesDesign and develop enterprise-scale data models in Databricks across Bronze/Silver/Gold layers supporting supply chain analytics, demand/supply planning, inventory, procurement, and order management.Build and maintain semantic models and KPIs covering forecast accuracy, inventory visibility (WIP/FG/in-transit), aging, service-level metrics, supplier lead time/OTIF, backorders, shipment/receipt traceability, and product/item master hierarchies.Implement Delta Lake modeling patterns: incremental processing, upserts/merges, late-arriving data handling, SCD, surrogate key strategies, partitioning, and ZORDER optimization.Deliver consumption-ready datasets for reporting (consistent grains and metric definitions), AI/ML (feature tables, training/serving datasets), and application integrations.Collaborate with engineering and business stakeholders to confirm data grain, business rules, and reconciliation requirements.Establish and enforce data modeling standards: naming conventions, schema organization, documentation, model ownership, and data contracts for critical datasets.Implement automated data quality validations.Manage Unity Catalog governance: catalogs/schemas, access controls, metadata, lineage, and discoverability.Support CI/CD practices for data assets (Git-based development, testing gates).Troubleshoot and improve model performance, correctness, and refresh reliability.Required Qualifications4+ years in data modeling/analytics engineering with Databricks (Databricks SQL and/or Spark).Strong fundamentals in dimensional modeling (star/snowflake), SCD patterns, grain definition, and master data modeling.Strong SQL skills and performance tuning.Experience with Azure data platform and Databricks on Azure.Proven Unity Catalog experience.Familiarity with automated data quality/validation frameworks.Preferred QualificationsSupply chain dataset experience with Databricks SQL and Spark.Enterprise application integration patterns (curated tables with stable schemas, event-driven or batch consumption).Technical SkillsGovernance:Unity Catalog — permissions, ownership, lineage, and metadata managementPlatform:Azure — Databricks on Azure, storage, and security conceptsQuality:Automated validation and reconciliation strategiesTooling:Git-based workflows, CI/CD#J-18808-Ljbffr