Skip to main content
Loading
loadingbar
Loading, Please wait..!!

Lead Data Modeler – Supply Chain & Warehouse (WMS) Data

  • Lead Data Modeler – Supply Chain & Warehouse (WMS) Data job type Posted on: Nov 15, 2026
  • Lead Data Modeler – Supply Chain & Warehouse (WMS) Data experience level BPS Technologies
  • Lead Data Modeler – Supply Chain & Warehouse (WMS) Data employment type Westerville, Ohio
  • Lead Data Modeler – Supply Chain & Warehouse (WMS) Data salary Salary: $130,000 per year
  • Lead Data Modeler – Supply Chain & Warehouse (WMS) Data employment type Onsite
  • Lead Data Modeler – Supply Chain & Warehouse (WMS) Data salary Full-time

Point Apply Here APPLY LATER

Curious about compensation?

Explore the historical salary trends, average pay, and estimated compensation for Lead Data Modeler – Supply Chain & Warehouse (WMS) Data roles in Ohio.

View Salary Guide →

Job Title :

Lead Data Modeler – Supply Chain & Warehouse (WMS) Data

Job Type :

Full-Time

Job Location :

Westerville Ohio United States

Remote :

No

Jobcon Logo Job Description :

Lead Data Modeler – Supply Chain & Warehouse (WMS) Data | Westerville, OH | Contract-to-Hire

  • Location: Westerville, OH (Columbus area). Local, on-site/hybrid candidates strongly preferred; exceptional remote candidates considered.
  • Type: Contract-to-hire. 2–3 month initial contract, then conversion to a full-time role.
  • Conversion salary: Up to $130,000 + 10% annual bonus.
  • Start: ASAP

About the role

If you've modeled warehouse management system data, and you know how a receipt becomes a putaway, a pick and a shipment in the tables, this role was written for you.

A global logistics leader's AI & Data Analytics team is building a new set of data warehouse data products on Azure Synapse. The data comes from the warehouse floor: receiving, putaway, inventory, picking, packing and shipping across many distribution sites.

You'll be the team's dedicated data modeler. You'll run the modeling sessions with sector analytics experts, turn what they need into clean dimensional models, and own those models from whiteboard to physical design. This is a hands-on role for someone who is comfortable leading the room and doing the modeling.

What you'll do

  • Lead requirements and modeling sessions with sector analytics experts and operations leaders: set the agenda, settle definitions like on-time or available, and agree on grain before anything gets built.
  • Design dimensional models for warehouse data products: transaction facts (receipts, putaways, picks, shipments), periodic inventory snapshots, and accumulating snapshots for order and fulfillment milestones.
  • Build conformed dimensions for item/SKU, site, location and bin, client, carrier, order and calendar, with clear slowly changing dimension rules.
  • Map WMS source data (tasks, transactions, locations, inventory) to the models, and document business keys, transformation rules and edge cases.
  • Take models from conceptual to logical to physical in Hackolade or a similar tool, and help data engineers translate them into Azure Synapse tables.
  • Keep data dictionaries, model documentation and decision logs current.
  • Deliver the first set of data products within the initial contract, with a clear path to the next group.

What you need (all four required)

The client will only review candidates who clearly have all four. Please make sure your resume shows them in the roles where you did the work.

  1. Supply chain data experience. You've modeled data from warehousing, distribution, logistics, inventory or fulfillment operations, not only procurement or finance data.
  2. Hands-on WMS data experience. You've worked directly with data from a warehouse management system such as Manhattan, Blue Yonder/JDA, SAP EWM/WM, Körber or Oracle WMS, and understand its core entities: receipts, tasks, locations, inventory and shipments.
  3. Dimensional modeling as your primary skill. Several years designing star schemas, defining fact grain, and building transaction, periodic and accumulating snapshot facts, conformed dimensions and SCDs. Building pipelines alone doesn't count.
  4. You lead modeling sessions. You've independently run requirements and modeling workshops with business stakeholders and are comfortable being the only modeler in the room.

This role is not a fit if most of your recent work is ETL/ELT pipeline development, BI/dashboard development, or ML/AI engineering, or if your supply chain experience is reporting-only without data modeling.

Nice to have

  • Hackolade (the team's modeling tool); ERwin, ER/Studio or PowerDesigner experience transfers
  • Azure Synapse dedicated SQL pools: distribution, partitioning and columnstore design
  • 3PL or multi-client warehouse experience
  • Labor, transportation (TMS) or yard data
  • Based in the Columbus area

Why this role

  • You own the models. You're the modeling lead for a new set of data products, with no committee in between.
  • Real conversion path. Converts to full time at up to $130K plus a 10% bonus after the initial contract.
  • Visible, high-impact work. Your models feed operational analytics across a global logistics network.
  • Fast process. Two interview rounds, with a start as soon as possible.

Jobcon Logo Position Details

Posted:

Nov 15, 2026

Reference Number:

2562726

Employment:

Full-time

Salary:

$130,000 per year

City:

Westerville

Job Origin:

RECRUITCRM_ORGANIC_FEED

Share this job:

  • linkedin

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Lead Data Modeler – Supply Chain & Warehouse (WMS) Data    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Lead Data Modeler – Supply Chain & Warehouse (WMS) Data | Westerville, OH | Contract-to-Hire

  • Location: Westerville, OH (Columbus area). Local, on-site/hybrid candidates strongly preferred; exceptional remote candidates considered.
  • Type: Contract-to-hire. 2–3 month initial contract, then conversion to a full-time role.
  • Conversion salary: Up to $130,000 + 10% annual bonus.
  • Start: ASAP

About the role

If you've modeled warehouse management system data, and you know how a receipt becomes a putaway, a pick and a shipment in the tables, this role was written for you.

A global logistics leader's AI & Data Analytics team is building a new set of data warehouse data products on Azure Synapse. The data comes from the warehouse floor: receiving, putaway, inventory, picking, packing and shipping across many distribution sites.

You'll be the team's dedicated data modeler. You'll run the modeling sessions with sector analytics experts, turn what they need into clean dimensional models, and own those models from whiteboard to physical design. This is a hands-on role for someone who is comfortable leading the room and doing the modeling.

What you'll do

  • Lead requirements and modeling sessions with sector analytics experts and operations leaders: set the agenda, settle definitions like on-time or available, and agree on grain before anything gets built.
  • Design dimensional models for warehouse data products: transaction facts (receipts, putaways, picks, shipments), periodic inventory snapshots, and accumulating snapshots for order and fulfillment milestones.
  • Build conformed dimensions for item/SKU, site, location and bin, client, carrier, order and calendar, with clear slowly changing dimension rules.
  • Map WMS source data (tasks, transactions, locations, inventory) to the models, and document business keys, transformation rules and edge cases.
  • Take models from conceptual to logical to physical in Hackolade or a similar tool, and help data engineers translate them into Azure Synapse tables.
  • Keep data dictionaries, model documentation and decision logs current.
  • Deliver the first set of data products within the initial contract, with a clear path to the next group.

What you need (all four required)

The client will only review candidates who clearly have all four. Please make sure your resume shows them in the roles where you did the work.

  1. Supply chain data experience. You've modeled data from warehousing, distribution, logistics, inventory or fulfillment operations, not only procurement or finance data.
  2. Hands-on WMS data experience. You've worked directly with data from a warehouse management system such as Manhattan, Blue Yonder/JDA, SAP EWM/WM, Körber or Oracle WMS, and understand its core entities: receipts, tasks, locations, inventory and shipments.
  3. Dimensional modeling as your primary skill. Several years designing star schemas, defining fact grain, and building transaction, periodic and accumulating snapshot facts, conformed dimensions and SCDs. Building pipelines alone doesn't count.
  4. You lead modeling sessions. You've independently run requirements and modeling workshops with business stakeholders and are comfortable being the only modeler in the room.

This role is not a fit if most of your recent work is ETL/ELT pipeline development, BI/dashboard development, or ML/AI engineering, or if your supply chain experience is reporting-only without data modeling.

Nice to have

  • Hackolade (the team's modeling tool); ERwin, ER/Studio or PowerDesigner experience transfers
  • Azure Synapse dedicated SQL pools: distribution, partitioning and columnstore design
  • 3PL or multi-client warehouse experience
  • Labor, transportation (TMS) or yard data
  • Based in the Columbus area

Why this role

  • You own the models. You're the modeling lead for a new set of data products, with no committee in between.
  • Real conversion path. Converts to full time at up to $130K plus a 10% bonus after the initial contract.
  • Visible, high-impact work. Your models feed operational analytics across a global logistics network.
  • Fast process. Two interview rounds, with a start as soon as possible.

Loading
Please wait..!!