SIOP Data and Model Specialist (dbt)

Amplify

1d • $120,000 - $140,000

About The Position

A pioneer in K–12 education since 2000, Amplify is leading the way in next-generation curriculum and assessment. Our core and supplemental programs in ELA, math, and science engage all students in rigorous learning and inspire them to think deeply, creatively, and for themselves. Our formative assessment products help teachers identify the targeted instruction students need to build a strong foundation in early reading and math. All of our programs provide educators with powerful tools that help them understand and respond to the needs of every student. Today, Amplify serves more than 15 million students in all 50 states. For more information, visit amplify.com. Amplify is seeking a SIOP Data & Model Specialist to join our Central Services Technology team. This role owns the technology backbone and planning science of Supply Chain Sales, Inventory, and Operations Planning (SIOP), building and governing the framework that underpins forecasting, demand/supply planning, and scenario modeling. You'll serve as a bridge between supply chain expertise and technical implementation, owning planners' Excel templates and the structured planning technology layer (currently dbt-based) while leading the transition from spreadsheets to a policy-driven planning process. The ideal candidate brings deep expertise in forecasting, inventory modeling, demand/supply planning, and operational workflows, with the ability to translate supply chain subject matter knowledge into scalable planning solutions. You'll drive forecasting accuracy and scenario modeling while partnering closely with planners to gain a deeper understanding of day-to-day operations. Success is measured by operational metrics, including fill rate, forecast value add (FVA), inventory turns, and expedite costs, as you collaborate with Data/Technology teams on architecture and Finance on policy guardrails to enable long-term supply chain resilience.

Requirements

• Bachelor’s degree in Industrial Engineering, Operations Research, Applied Statistics or other engineering- or analytics-based discipline (MS preferred).
• 6–10+ years experience in planning science (forecasting, inventory optimization) with hands‑on modeling.
• Strong SQL and dbt experience; advanced Excel skill set, and at minimum a familiarity with Atlan / Snowflake or an equivalent platform.
• Proven product ownership of analytics/plan platforms including management of the backlog, releases, and change control.
• Demonstrated change leadership with planners with measurable FVA and adoption wins.
• Experience working in a cross-functional or centralized technology/process improvement team.

Nice To Haves

• Experience with ERP and CRM (preferably, NetSuite and Salesforce) integration.
• An understanding of K-12 education business model and seasonality.
• Experience in dealing with complex independent and dependent demand scenarios driven by complex kits and BOMs.
• Excellent communication skills with the ability to convey complex data models to non-technical stakeholders.
• Familiarity with continuous improvement methodologies (e.g., Lean, Six Sigma), quality assurance practices, or structured project/change management frameworks.

Responsibilities

• Governance & Decision Rights: Approve/deny changes to planning templates and dbt models; set and govern policy parameters (service levels, safety stock, MOQ/EOQ, freeze fences); gate planning releases and prioritize SIOP backlog; call stop-the-line on non-compliant processes.
• Model Development: Model Development: Lead migration from Excel to governed dbt frameworks in Snowflake; collaborate with analytics engineers to build forecast models (time-series, causal), inventory policies (multi-echelon), and FVA diagnostics; develop demand sensing approaches of market data to improve FVA; maintain semantic layer with version control and clear documentation.
• Data Integration & Quality: Own integrations with NetSuite, and Salesforce; partner with data engineering on ETL processes; establish data quality rules; monitor data health proactively and enforce quality standards and validation processes.
• Scenario Planning & Analytics: Build and manage dbt sandbox for "what-if" analysis; run scenario planning for build-to-stock and adoptions; develop simulation capabilities for supply chain configurations and demand fluctuations; create dashboards for planning visibility.
• Collaboration & Training: Train planners and establish certification for template/dbt usage; mentor colleagues on modeling and technology best practices; partner with Finance on working-capital targets; generate and review Pull Requests for production integration.
• Process Standardization: Standardize master data needed for SIOP with Product Data Integrity; publish playbooks for call-downs and expedites; track adoption and compliance; ensure roadmap alignment with business objectives.

Benefits

• Salary is only one component of the Amplify Total Rewards package, which includes a 401(k) plan, competitive health insurance and mental health options, basic life insurance, paid time off, parental leave, and access to best-in-class development programs.
• This role is eligible to earn an annual discretionary bonus that rewards individual and company performance.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees