Data Analyst Warehouse Management System (WMS)

eSolutionsFirst LLC
Reston, VA, United States
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Data Analysis Business Logic Data Conversion Data Mapping Data Migration Rule Engine SQL Databases

Job description

We are looking for a Data Analyst to support the migration of client s inventory allocation control rules from the legacy ERP system into a new unified Allocation Rules Engine within the WMS. This is a detail-oriented, data-focused role working closely with the client s operations and IT teams to ensure accurate rule translation and validated migration outcomes., * Analyze legacy ERP allocation rule configurations across 14 source tables and document current-state logic, data patterns, and known anomalies

  • Build and maintain source-to-target mapping documentation, translating legacy entity-pair records into the attribute-based rule structure of the new engine
  • Identify records requiring consolidation grouping multiple legacy rows into single unified rules where business logic allows
  • Flag conflicting, contradictory, or inactive source records for stakeholder review and resolution prior to migration
  • Support migration script validation by reconciling migrated rule counts, configurations, and outputs against source data
  • Design and execute data migration test cases to verify that the new rule engine produces identical blocking behavior to the legacy system across key scenarios
  • Maintain a migration tracker covering mapping status, open data issues, decisions made, and sign-off accountability
  • Collaborate with business stakeholders to clarify rule intent where source data is ambiguous or undocumented

Requirements

  • 7+ years in a Data Analyst or data migration role, preferably within supply chain, logistics, or distribution
  • Strong proficiency in Excel or SQL for data analysis, mapping, and reconciliation work
  • Proven experience delivering source-to-target mapping documentation in a system migration or data conversion context
  • Comfortable interpreting structured configuration data and translating it into functional business logic
  • Organized and methodical able to manage large volumes of mapping records with precision and traceability

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:39 min

Harnessing data mapping tools to identify unmapped opportunities

Laura Möller Laura Möller +3 · WWC 2024

9:55 min

Empowering business analysts with a polyglot rule engine

Chris Heilmann +2 · LIVE

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

1:22 min

Prerequisite steps for successful tool and data migration

Sérgio Sancho Pinto Sérgio Sancho Pinto · Europe 2026 Virtual

2:11 min

Evaluating deterministic rule engines for transaction compliance

Oleksandr Korotkykh Oleksandr Korotkykh +1 · WWC Europe 2026

3:57 min

Mapping abstract data attributes into geometric visual configurations

Johanna Schmidt · LIVE

Videos

See all

Related articles

See all