SIOP Data and Model Specialist (dbt) at Amplify

You're a seasoned professional with 6-10 years of experience in planning science, including forecasting and inventory optimization, and a Bachelor's degree in a

Work type: remote

Location: Remote - United States

Salary: $120,000 – $140,000/yr

Type: Full-time

Summary

You're a seasoned professional with 6-10 years of experience in planning science, including forecasting and inventory optimization, and a Bachelor's degree in an engineering or analytics-based field. You have hands-on modeling experience and a strong understanding of translating supply chain knowledge into scalable planning solutions. **What makes it worth a look...** Amplify, a pioneer in K-12 education, is offering a fully remote, full-time role with a salary of $120,000 - $140,000 per year. This position allows you to own the technology backbone for Supply Chain Sales, Inventory, and Operations Planning (SIOP). **You might be a good fit if you...** * Have strong SQL and dbt experience, with advanced Excel skills. * Possess proven product ownership of analytics/plan platforms, including backlog and release management. * Are familiar with Atlan/Snowflake or equivalent platforms, and have experience with NetSuite and Salesforce integrations. * Demonstrate change leadership with planners, achieving measurable FVA and adoption wins.

Job Description

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.

Essential 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.

 

Required Qualifications:







 

Preferred Qualifications:






What we offer:

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. The gross salary range for this role is $120,000 - $140,000. This role is eligible to earn an annual discretionary bonus that rewards individual and company performance.

View this job on nocollar jobs