Databricks Data Modeler Consultant
Avansis Solutions
- New York, New York, United States
- New York, New York, United States
About
Location: US Remote
Type: Contract
Responsibilities
Design 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 Qualifications
4+ 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 Qualifications
Supply chain dataset experience with Databricks SQL and Spark.
Enterprise application integration patterns (curated tables with stable schemas, event-driven or batch consumption).
Technical Skills
Governance:
Unity Catalog — permissions, ownership, lineage, and metadata management
Platform:
Azure — Databricks on Azure, storage, and security concepts
Quality:
Automated validation and reconciliation strategies
Tooling:
Git-based workflows, CI/CD
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.