{"schemaVersion":"jobsearcher.job.v1","id":"7a52ed8dae3eb4e2c01ed09e","url":"https://jobsearcher.com/jobs/7a52ed8dae3eb4e2c01ed09e","canonicalUrl":"https://jobsearcher.com/jobs/7a52ed8dae3eb4e2c01ed09e","title":"Databricks Data Modeler Consultant","description":"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.\r\nLocation: US Remote\r\nType: Contract\r\nResponsibilities\r\nDesign 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.\r\nBuild 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.\r\nImplement Delta Lake modeling patterns: incremental processing, upserts/merges, late-arriving data handling, SCD, surrogate key strategies, partitioning, and ZORDER optimization.\r\nDeliver consumption-ready datasets for reporting (consistent grains and metric definitions), AI/ML (feature tables, training/serving datasets), and application integrations.\r\nCollaborate with engineering and business stakeholders to confirm data grain, business rules, and reconciliation requirements.\r\nEstablish and enforce data modeling standards: naming conventions, schema organization, documentation, model ownership, and data contracts for critical datasets.\r\nImplement automated data quality validations.\r\nManage Unity Catalog governance: catalogs/schemas, access controls, metadata, lineage, and discoverability.\r\nSupport CI/CD practices for data assets (Git-based development, testing gates).\r\nTroubleshoot and improve model performance, correctness, and refresh reliability.\r\nRequired Qualifications\r\n4+ years in data modeling/analytics engineering with Databricks (Databricks SQL and/or Spark).\r\nStrong fundamentals in dimensional modeling (star/snowflake), SCD patterns, grain definition, and master data modeling.\r\nStrong SQL skills and performance tuning.\r\nExperience with Azure data platform and Databricks on Azure.\r\nProven Unity Catalog experience.\r\nFamiliarity with automated data quality/validation frameworks.\r\nPreferred Qualifications\r\nSupply chain dataset experience with Databricks SQL and Spark.\r\nEnterprise application integration patterns (curated tables with stable schemas, event-driven or batch consumption).\r\nTechnical Skills\r\nGovernance: Unity Catalog — permissions, ownership, lineage, and metadata management\r\nPlatform: Azure — Databricks on Azure, storage, and security concepts\r\nQuality: Automated validation and reconciliation strategies\r\nTooling: Git-based workflows, CI/CD\r\nJ-18808-Ljbffr","company":"Avansis Solutions","rawCompany":"avansis solutions","city":"New York","state":"NY","isRemote":false,"isActive":false,"createdAt":"2026-05-23T06:48:26.614Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-2051.00","title":"Data Scientists","slug":"data-scientists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Databricks Data Modeler Consultant","description":"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.\r\nLocation: US Remote\r\nType: Contract\r\nResponsibilities\r\nDesign 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.\r\nBuild 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.\r\nImplement Delta Lake modeling patterns: incremental processing, upserts/merges, late-arriving data handling, SCD, surrogate key strategies, partitioning, and ZORDER optimization.\r\nDeliver consumption-ready datasets for reporting (consistent grains and metric definitions), AI/ML (feature tables, training/serving datasets), and application integrations.\r\nCollaborate with engineering and business stakeholders to confirm data grain, business rules, and reconciliation requirements.\r\nEstablish and enforce data modeling standards: naming conventions, schema organization, documentation, model ownership, and data contracts for critical datasets.\r\nImplement automated data quality validations.\r\nManage Unity Catalog governance: catalogs/schemas, access controls, metadata, lineage, and discoverability.\r\nSupport CI/CD practices for data assets (Git-based development, testing gates).\r\nTroubleshoot and improve model performance, correctness, and refresh reliability.\r\nRequired Qualifications\r\n4+ years in data modeling/analytics engineering with Databricks (Databricks SQL and/or Spark).\r\nStrong fundamentals in dimensional modeling (star/snowflake), SCD patterns, grain definition, and master data modeling.\r\nStrong SQL skills and performance tuning.\r\nExperience with Azure data platform and Databricks on Azure.\r\nProven Unity Catalog experience.\r\nFamiliarity with automated data quality/validation frameworks.\r\nPreferred Qualifications\r\nSupply chain dataset experience with Databricks SQL and Spark.\r\nEnterprise application integration patterns (curated tables with stable schemas, event-driven or batch consumption).\r\nTechnical Skills\r\nGovernance: Unity Catalog — permissions, ownership, lineage, and metadata management\r\nPlatform: Azure — Databricks on Azure, storage, and security concepts\r\nQuality: Automated validation and reconciliation strategies\r\nTooling: Git-based workflows, CI/CD\r\nJ-18808-Ljbffr","datePosted":"2026-05-23T06:48:26.614Z","dateModified":"2026-05-23T06:48:26.614Z","hiringOrganization":{"@type":"Organization","name":"Avansis Solutions","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"New York","addressRegion":"NY","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"7a52ed8dae3eb4e2c01ed09e"},"url":"https://jobsearcher.com/jobs/7a52ed8dae3eb4e2c01ed09e"}}