Note: The job is a remote job and is open to candidates in USA. Riverstone Logistics is a supply chain company providing final mile, middle mile, warehousing, fulfillment, and storage solutions. The Senior Data Engineer will build reliable data pipelines and models in Snowflake and dbt, develop integrations, support analytics delivery, and establish data quality, governance, and platform optimization practices.
Responsibilities
- Build and maintain ingestion pipelines into Snowflake using Fivetran and custom Python where connectors fall short
- Design and own dbt models—staging through marts—with clear tests, documentation, and ownership
- Model operational data to reflect real-world logistics workflows, not just source-system structure
- Contribute to improving warehouse design, performance, and maintainability
- Design and implement data integrations with third-party and internal systems (e.g., TMS, WMS, partner platforms)
- Operationalize data through Hightouch, syncing modeled data back into the systems where work happens
- Deliver curated, well-defined datasets that power Omni dashboards and self-serve reporting
- Ensure pipelines and syncs are reliable, scalable, and maintainable in production
- Own Snowflake performance and cost—warehouse sizing, query tuning, storage strategy
- Establish data quality standards: testing, monitoring, alerting, and lineage so issues surface before stakeholders find them
- Set and enforce governance practices—access controls, naming conventions, shared definitions, documentation
- Participate in code reviews and contribute to shared engineering standards and best practices
- Identify and address technical debt and pipeline inefficiencies
- Partner with Analytics, Product, Operations, and Finance on data model design and execution
- Support investigation and resolution of data issues affecting internal teams and customers
- Provide technical input to improve workflows and reduce operational friction
- Communicate clearly on technical trade-offs, timelines, and risks
Skills
- • [5]+ years of experience in data engineering or a closely related role
- • Advanced SQL and strong Snowflake experience, including performance and cost optimization
- • Production dbt experience—modeling, testing, macros, and CI
- • Proficient Python for pipeline work, API integrations, and automation
- • Experience with ELT tooling (Fivetran or equivalent) and reverse ETL (Hightouch or equivalent)
- • Solid grounding in dimensional modeling and warehouse design
- • Track record building data quality and observability into pipelines
- • Git-based workflows and version control discipline
- • Strong collaboration and communication skills
- The physical demands described here are representative of those required of an employee to successfully perform the essential functions of this job. Employees must be able to meet the requirements of this position, with or without reasonable accommodation
- The employee is required to maneuver about the work areas and move/manipulate various objects. This position may require extended work hours and travel
- • Experience with Omni, Looker, or a similar semantic-layer BI tool preferred
- • Experience with logistics, transportation, or supply chain data (TMS, WMS, EDI, telematics) preferred
Company Overview