Senior Data Engineer, Supply Chain & AI - Onsite Framingham, MA
Staples Canada19 days ago
Framingham, MA, USASenior
Responsibilities
- Design, develop, test, deploy, and support batch, event-driven, and near-real-time supply chain data pipelines.
- Build modular, documented dbt models in Snowflake with incremental processing, testing, lineage, and performance-conscious design.
- Create governed, analytics-ready data products for transportation, fulfillment, inventory, delivery, returns, and related supply chain decisions.
- Build governed datasets, semantic context, metadata, evaluation data, and secure interfaces for AI and agentic workflows.
- Use Databricks, Spark, notebooks, workflows, Unity Catalog, and Genie for scalable engineering and conversational analytics when appropriate.
- Implement data quality checks, unit and integration tests, reconciliation controls, observability, alerting, and production support practices.
- Optimize Snowflake compute, storage, SQL, and dbt workloads for performance, reliability, and responsible cost management.
- Apply Git-based version control, peer review, CI/CD, environment promotion, secrets management, and infrastructure automation.
- Create reusable frameworks, reduce technical debt, document architecture and operations, and improve engineering standards.
- Lead assigned initiatives from design through production, communicate risks, and contribute to design and code reviews.
Requirements
- Bachelor's degree in computer science, engineering, information systems, data analytics, or a related quantitative field, or equivalent practical experience.
- 7+ years of hands-on data engineering or analytics engineering experience delivering production data solutions, or equivalent experience demonstrated through progressively complex technical ownership.
- Experience with supply chain or related operational data, including areas such as transportation, fulfillment, inventory, order lifecycle, delivery, returns, reverse logistics, or distribution.
- Advanced SQL skills and experience designing scalable data models, ELT pipelines, and cloud data warehouse solutions.
- Production experience with Snowflake, including data modeling, workload optimization, access patterns, and operational support.
- Production experience with dbt, including modular models, tests, documentation, lineage, incremental strategies, and deployment practices.
- Hands-on Python experience and working knowledge of PySpark or Apache Spark.
- Experience with Microsoft Azure or Google Cloud, including storage, identity and access patterns, orchestration, monitoring, and secure integration.
- Experience implementing data quality, monitoring, troubleshooting, root-cause analysis, and support controls for business-critical pipelines.
- Experience delivering multiple concurrent initiatives in an Agile product or engineering environment.
- Preferred experience with Databricks, Spark, Delta Lake, Unity Catalog, notebooks, jobs or workflows, and governed data products.
- Preferred experience with Databricks Genie or Genie Code, semantic layers, natural-language analytics, or AI-assisted data engineering workflows.
- Preferred experience building data foundations for machine learning, generative AI, retrieval, or agentic applications.
- Preferred experience with Apache Airflow, Azure Data Factory, Kafka, infrastructure as code, containerized workloads, APIs, event schemas, and secure integration patterns.
- Knowledge of dimensional modeling, data vault or domain-oriented data products, master data, data governance, privacy, and role-based access control.
- Experience mentoring engineers and influencing technical direction through design reviews and reusable patterns.
- Background in retail, B2B, B2C, ecommerce, logistics, or high-volume operational data environments.
Benefits
- Inclusive culture with associate-led Business Resource Groups.
- 22 days of PTO plus a holiday schedule with 7 observed paid holidays and 1 floating holiday.
- Online and retail discounts.
- Company Match 401(k).
- Physical and mental health wellness programs.
- Onsite role in Framingham, Massachusetts.
Tech Stack
Categories
Data Engineering
About Staples Canada
Staples Canada is a privately held retailer of office supplies, technology, furniture, and business services for consumers, educators, and small businesses. It sells online and through nearly 300 stores across Canada, offering printing, tech support, shipping, and workplace solutions alongside products. Headquartered in Richmond Hill, Ontario, it has served the Canadian market for over 30 years and operates distribution and fulfillment networks to support e-commerce and store operations.