Role Summary
The Inventory & Demand Planning team is hiring a Data Analyst to scale a high-impact analytics roadmap across inventory, in-stock, supply, and forecasting. This role builds and maintains the data foundation that powers decision-making by translating business rules into reliable datasets, automating recurring KPI outputs, and supporting the ABC/XYZ + lifecycle governance framework so leaders and merchants operate from consistent, auditable numbers with minimal manual effort.
This is a hands-on analytics engineering role centered on data pipelines, automation, and metric integrity to enable planning decisions and streamline reporting/governance outputs. The analyst will partner closely with Inventory Planning leadership to implement definitions, validations, and scalable reporting.
What You’ll Work On
- Build and maintain curated BigQuery tables/views that standardize inventory, demand, availability, open POs/in-transit, backorders, and KPI feeds.
- Write clean, performant SQL that powers weekly/monthly reporting and executive dashboards.
- Automate refreshes and reduce manual effort through validations, reconciliations, exception flags, and clear documentation.
- Support ABC/XYZ roadmap execution by producing required inputs/outputs, applying multiplier logic, and keeping the classification pipeline stable and easy to audit.
- Support forecasting improvements using Python (data prep, feature engineering, back-testing, evaluation) and help operationalize outputs into cadence reporting.
- Expand datasets with additional signals where available (promo flags/types, merchandising tags, launch/NPA indicators, traffic/CVR signals, marketing calendar attributes).
- Partner with Merchandising, Marketing Ops, Finance, and BI/IT to align definitions, improve data quality, and drive adoption of standardized metrics.
How Success Will Be Measured
- KPI tables and dashboard feeds refresh reliably with minimal manual intervention.
- Faster turnaround on leadership and merchant requests with consistent, traceable metric logic.
- ABC/XYZ outputs are accurate, on-time, and easy to maintain.
- Forecast inputs improve through better data structure and added business/marketing signals.
- Documentation and change control keep datasets stable as business rules evolve.
Required Qualifications
- 3–5 years in analytics/data roles (retail/e-commerce strongly preferred).
- Strong SQL and hands-on experience with BigQuery (or similar cloud warehouse).
- Working Python proficiency for analysis/automation (pandas/NumPy).
- Experience supporting BI dashboards and recurring reporting.
- Demonstrated ability to validate and reconcile metrics across sources, troubleshoot discrepancies, and document logic clearly.
- Strong problem-solving, attention to detail, and clear communication with business stakeholders.
Preferred Qualifications
- Familiarity with ML/forecasting workflows (feature engineering, evaluation, operationalizing outputs) to support forecasting and driver-based models in partnership with the team.
- Familiarity with Looker/LookML (or similar semantic layers).
- Exposure to dbt and/or orchestration tools (Airflow/Composer or equivalents).
- Comfort with inventory/planning concepts (WOS, aging, availability, lost demand, backorders) and classification/ranking approaches (ABC/XYZ, PFEP).
- Version control (Git) and basic engineering hygiene (testing, documentation, change logs).
Tools / Environment
BigQuery, SQL, Python, Looker, Jira/Confluence (or equivalent), Google Cloud tooling as applicable.