About the role
- Our central data and analytics team builds and operates the data pipelines that power reporting, analytics, and automation across Redwood
- This is a hands-on engineering role: the majority of our work is code-based data pipelining and automated data analyses
- You will spend most of your time on code-based analysis and building and maintaining production pipelines rather than working in a BI tool
- You will work directly with stakeholders in finance, supply chain, and operations to understand what they need, scope technical solutions, and deliver reliable, automated data products
- We are looking for someone who can translate a business conversation into a well-engineered pipeline and stand behind it in production
- Build, deploy, and maintain production-grade automated data pipelines using Python and SQL
- Perform one-off and automated data-driven analyses using financial and supply chain models and calculations
- Scope technical pipeline and automation solutions based on conversations with users and an understanding of the underlying business value drivers
- Develop and orchestrate pipelines using tools such as Dagster or Airflow, and manage transformations with dbt
- Apply CI/CD and sound software engineering practices (version control, testing, code review) to data workflows
- Deploy and run pipelines on cloud infrastructure, and help maintain the reliability of what we ship
- Partner with finance, supply chain, and operations stakeholders to deliver the metrics, datasets, and automations they rely on
- Own delivery of your work end to end, including scoping, prioritization, and follow-through
- Familiarity with CI/CD and good coding practices
- Ability to scope technical data pipeline solutions and automations from stakeholder conversations and business context
- Strong Python and SQL
- Domain expertise in financial metrics or in supply chain and operations
- Minimum bachelor’s degree in quantitative or technical field such as Data Engineering, Computer Science, Applied Math, etc. Graduate degree preferred
- Working knowledge of cloud infrastructure
- Experience with orchestration tools such as Dagster or Airflow, and with dbt
- 3+ years building, deploying, and maintaining production data pipelines
- Experience with AWS
- Domain expertise across both financial metrics and supply chain/operations
- Project management skills
- Experience with Starburst and OpenMetadata