EXSIF
As a part of the global industrial organization Marmon Holdings—which is backed by Berkshire Hathaway—you’ll be doing things that matter, leading at every level, and winning a better way. We’re committed to making a positive impact on the world, providing you with diverse learning and working opportunities, and fostering a culture where everyone’s empowered to be their best.
Job Summary
The Fleet Management Data Analyst (SIOP) owns the coordination, integrity, and readiness of data that powers the Sales, Inventory & Operations Planning process. This role ensures a single source of truth for demand, supply, and inventory, orchestrates data gathering across functions and time zones, validates inputs prior to each SIOP cycle, and publishes trusted datasets and dashboards that drive decisions. The ideal candidate blends strong analytics skills with supply chain process knowledge, brings financial acumen for cross-functional alignment between Operations and Accounting/Finance and stakeholder facilitation.
Key Responsibilities
- Data Intake & Integration
- Coordinate ingestion and refresh of data from ERP, CRM, WMS, MRP/APS, supplier portals, and other internal/external sources.
- Partner with Data Engineering/IT to define robust, documented pipelines (e.g., ETL/ELT, Power Query, ADF/Synapse/Databricks).
- Maintain source-to-target mapping, data lineage, refresh frequency, and cutover windows aligned to the SIOP calendar.
- Data Quality & Governance
- Define and operationalize data quality rules (accuracy, completeness, consistency, timeliness, uniqueness) and exception handling.
- Build automated validation and reconciliation checks (e.g., bookings-to-billings, shipments vs. inventory movements, open orders, backlogs, BOM/route consistency).
- Serve as a steward for master data (items/SKUs, customer hierarchies, locations/plants, calendars, units of measure); coordinate fixes and change controls.
- SIOP Calendar & Readiness
- Own the data readiness checklist for demand review, supply review, pre‑SIOP, and executive SIOP.
- Enforce cutoffs, freeze windows, and audit trails; publish “data is green” status and issues list before each meeting.
- Coordinate cross-functional inputs from Sales, Operations, Procurement, Finance, and Logistics.
- Analytics, KPIs & Reporting
- Design, develop, and maintain dashboards and analytical models to support SIOP decision-making and performance measurement.
- Define, track, and report on key SIOP and fleet management metrics, ensuring alignment with business goals and continuous improvement initiatives.
- Maintain and continuously improve KPI definitions and calculations, including:
- Forecast Accuracy (MAPE/WAPE), Forecast Bias
- Service Level, OTIF/Fill Rate, Backorder Rate
- Inventory Turns, Days of Inventory on Hand (DOH), Excess & Obsolete (E&O)
- Plan Adherence, Schedule Attainment, Capacity Utilization
- Integrate financial data into operational analytics to provide insights on cost drivers, budget adherence, and profitability across the fleet equipment/product group portfolio.
- Partner with Accounting/Finance to interpret financial statements, forecast impacts of operational decisions, and translate findings into actionable recommendations for cross-functional teams.
- Variance & Root-Cause Analysis
- Investigate demand spikes/dips, supply constraints, lead-time shifts, and inventory discrepancies; quantify business impact.
- Facilitate corrective actions with owners, document and track to closure.
- Change Management & Enablement
- Create SOPs, data definitions, and process playbooks, train super-users and planners on new datasets, checks, and tools.
- Champion continuous improvement to reduce manual effort, increase transparency, and shorten SIOP cycle time.
- Compliance & Controls
- Maintain audit-ready documentation for key data transformations and KPI calculations.
- Support internal control requirements for data changes, approvals, and segregation of duties.
Required Qualifications
- 4 – 7 years in data/business analytics within supply chain/SIOP environments.
- Familiarity with SQL and data modeling (star/snowflake), Power BI (DAX), and Excel (Power Pivot, Power Query).
- Demonstrated experience implementing data quality frameworks and master data stewardship.
- Demonstrated understanding of SIOP processes, demand planning and inventory management concepts.
- Demonstrated understanding of financial principles to interpret and connect operational data with accounting and finance metrics.
- Collaborate effectively with finance teams to ensure that SIOP data supports accurate financial reporting, budgeting, and forecasting.
- Excellent communication, facilitation, and stakeholder management skills; able to translate business needs into technical requirements.
- Ability to work across US, Europe and Asia time zones.
Preferred Qualifications
- Bachelor’s degree in a related field is preferred
- Experience with Microsoft Dynamics 365 Finance & Operations (D365 F&O) (e.g., sales order, inventory/on-hand, InventTrans, demand forecast, master planning entities).
- Cloud data stack exposure: Azure Data Factory, Synapse/Databricks, Data Lake; or equivalent.
- SIOP Planning tools exposure (e.g., Kinaxis RapidResponse, SAP IBP, o9, Anaplan, or similar).
- Python or R for advanced data validation or statistical analysis; familiarity with time-series methods.
- Power Automate or similar workflow tools for exception routing and approvals.
- Experience integrating external signals (e.g., POS, distributor sell‑thru, market indices) into demand or inventory analyses.
Following receipt of a conditional offer of employment, candidates will be required to complete additional job-related screening processes as permitted or required by applicable law.