Senior Data Engineer

What the role needs

• Design, develop, test, and support batch, event-driven, and near-real-time pipelines for supply chain data ingestion, integration, transformation, and curation.
• Build modular, well-documented dbt models in Snowflake using reusable patterns, incremental processing, testing, lineage, and performance-conscious design.
• Create governed, analytics-ready data products that support transportation, fulfillment, inventory, delivery promise, last-mile delivery, returns, and related supply chain decisions.
• Partner with supply chain product owners, analysts, application teams, data scientists, and business stakeholders to clarify requirements, define data contracts, and deliver fit-for-purpose solutions.
• Build reliable data foundations for AI and agentic workflows by creating governed datasets, semantic context, metadata, evaluation data, and secure production interfaces.
• Use Databricks capabilities such as Spark, notebooks, workflows, Unity Catalog, and Genie when they are the right fit for scalable engineering, governed data products, and conversational analytics.
• Implement automated 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 software engineering practices including Git-based version control, peer review, CI/CD, environment promotion, secrets management, and infrastructure automation.
• Create reusable frameworks and components while reducing technical debt and improving engineering standards across the team.
• Document architecture, data models, lineage, operational procedures, and support expectations so solutions are transparent and maintainable.
• Lead assigned initiatives from design through production with minimal oversight, communicate risks early, and contribute actively to design and code reviews.

From the employer

The Staples Enterprise Data team builds and governs scalable data products that enable trusted, timely decision-making. Within Data & Analytics, the Supply Chain Data team partners across transportation, fulfillment, inventory, delivery, returns, product, analytics, and engineering to create dependable foundations for operational reporting, advanced analytics, and AI-enabled experiences. As a Senior Data Engineer I, you will design, build, test, deploy, and operate modern data products for Staples Supply Chain. You will translate complex operational needs into governed, reusable datasets and pipelines, with Snowflake and dbt serving as the primary production stack. You will also help extend the platform for AI-ready data products and conversational analytics using Snowflake and Databricks capabilities where they provide clear value. In this hands-on role, you will own solutions from design through production, build strong cross-functional partnerships, and improve reliability, data quality, security, and measurable business outcomes. Your work will help supply chain teams find and trust the data they need to make faster, better-informed decisions while enabling future analytics and AI experiences. What you’ll be doing: • Design, develop, test, and support batch, event-driven, and near-real-time pipelines for supply chain data ingestion, integration, transformation, and curation. • Build modular, well-documented dbt models in Snowflake using reusable patterns, incremental processing, testing, lineage, and performance-conscious design. • Create governed, analytics-ready data products that support transportation, fulfillment, inventory, delivery promise, last-mile delivery, returns, and related supply chain decisions. • Partner with supply chain product owners, analysts, application teams, data scientists, and business stakeholders to clarify requirements, define data contracts, and deliver fit-for-purpose solutions. • Build reliable data foundations for AI and agentic workflows by creating governed datasets, semantic context, metadata, evaluation data, and secure production interfaces. • Use Databricks capabilities such as Spark, notebooks, workflows, Unity Catalog, and Genie when they are the right fit for scalable engineering, governed data products, and conversational analytics. • Implement automated 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 software engineering practices including Git-based version control, peer review, CI/CD, environment promotion, secrets management, and infrastructure automation. • Create reusable frameworks and components while reducing technical debt and improving engineering standards across the team. • Document architecture, data models, lineage, operational procedures, and support expectations so solutions are transparent and maintainable. • Lead assigned initiatives from design through production with minimal oversight, communicate risks early, and contribute actively to design and code reviews. What you bring to the table: • A strong ownership mindset and the ability to move from ambiguous business needs to practical, supportable data solutions. • Clear written and verbal communication, with the ability to explain technical choices, tradeoffs, risks, and outcomes to technical and nontechnical partners. • Curiosity, sound judgment, and a continuous-learning mindset in a fast-moving data and AI environment. • The ability to balance delivery speed with quality, governance, security, and long-term maintainability. • Comfort working independently while collaborating across product, engineering, analytics, and business teams. What’s needed- Basic Qualifications: • 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 working with supply chain data or closely related operational domains, with working knowledge of one or more areas such as transportation, fulfillment, inventory, order lifecycle, delivery, returns, reverse logistics, or distribution operations. • Advanced SQL skills and hands-on 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 model design, tests, documentation, lineage, incremental strategies, and deployment practices. • Hands-on programming experience with Python and working knowledge of PySpark or Apache Spark for distributed data processing. • Experience with Microsoft Azure or Google Cloud, including cloud storage, identity and access patterns, orchestration, monitoring, and secure integration with modern data platforms. • 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. What’s needed- Preferred Qualifications: • Hands-on experience with Databricks, including Spark, Delta Lake, Unity Catalog, notebooks, jobs or workflows, and governed data-product development. • Experience enabling Databricks Genie or Genie Code, semantic layers, natural-language analytics, or AI-assisted data engineering workflows. • Experience building data foundations for machine learning, generative AI, retrieval, or agentic applications, including metadata, data contracts, evaluation, and production monitoring. • Experience with orchestration and streaming technologies such as Apache Airflow, Azure Data Factory, Kafka, or cloud-native equivalents. • Experience with 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, improving standards, and influencing technical direction through design reviews and reusable patterns. • Background in retail, B2B, B2C, ecommerce, logistics, or high-volume operational data environments. We Offer: • Inclusive culture with associate-led Business Resource Groups • 22 days of PTO and Holiday Schedule (7 observed paid holidays + 1 floating holiday) • Online and Retail Discounts, Company Match 401(k), Physical and Mental Health Wellness programs, and more! The salary range represents the expected compensation for this role at the time of posting. The specific base pay may be influenced by a variety of factors to include the candidate's experience, skill set, education, geography, business considerations, and internal equity. In addition to base pay, this role may be eligible for bonuses, or other forms of variable compensation. #LI-AF1