About Foundation Logistics
Foundation Logistics moves freight for more than 2,000 shippers across North America through a network of carriers, warehouses and last-mile partners. Every day our platform processes millions of shipment events, GPS pings and warehouse scans. Our data team turns them into on-time delivery forecasts, carrier scorecards and the cost insights that keep our customers' supply chains running.
The Role
We're looking for a Senior Data Engineer to design, build and own the data platform behind our operations, analytics and machine learning. You'll architect scalable pipelines and data models in Snowflake, set standards for data quality and reliability, and work cross-functionally with analytics, data science, product and operations leaders. This is a hands-on technical leadership role: you'll mentor engineers, shape our architecture roadmap, and directly affect how freight moves.
What You'll Do
Design and maintain scalable ETL/ELT pipelines that ingest data from TMS and WMS systems, carrier APIs, EDI feeds and IoT telematics into our Snowflake data warehouse.
Build and orchestrate batch and streaming workflows with Airflow, Kafka and Spark, meeting defined SLAs for freshness and reliability.
Own data modeling: design dimensional models (star schema) and a semantic layer in dbt that power self-service BI in Power BI and Tableau.
Implement data quality, testing, observability and data lineage, including automated dbt tests, alerting and root cause analysis.
Drive data governance and security: role-based access control, PII handling, data catalog and documentation best practices.
Optimize performance and cost across Snowflake and AWS through query tuning, clustering, partitioning and right-sized compute.
Partner with data scientists to productionize features and models for ETA prediction, demand forecasting and route optimization.
Champion engineering best practices: Git, CI/CD, code review, infrastructure as code with Terraform, and Agile delivery.
Mentor data engineers and analysts, and help translate business requirements from operations, finance and customer teams into data solutions.
What You Bring (Required)
5+ years of experience in data engineering, analytics engineering or a related field.
Expert SQL and strong Python skills.
Hands-on experience with a cloud data warehouse, preferably Snowflake (BigQuery, Redshift or Databricks is also valued).
Production experience with dbt and a workflow orchestrator such as Airflow, Dagster or Prefect.
Deep knowledge of data modeling, data warehousing and dimensional design.
Experience with a major cloud platform, preferably AWS (S3, Glue, Lambda).
A track record of building reliable, well-tested, well-documented pipelines at scale.
Strong communication skills and the ability to explain technical trade-offs to non-technical stakeholders.
A bachelor's degree in Computer Science, Engineering, Mathematics or a related field, or equivalent experience.
Nice to Have
Streaming experience with Kafka or Kinesis, and Spark or PySpark.
Lakehouse experience with Databricks, Delta Lake or Apache Iceberg.
Terraform, Docker or Kubernetes.
Experience with logistics, supply chain, transportation or e-commerce data, including EDI, telematics and TMS or WMS systems.
Experience supporting ML pipelines and MLOps.
Certifications such as SnowPro, AWS Data Engineer Associate or Databricks Data Engineer.
A master's degree in a quantitative or technical field.
Our Stack
Snowflake, dbt, Airflow, Kafka, Spark, AWS (S3, Glue, Lambda), Terraform, Git and GitHub Actions, Power BI, Tableau, Python, SQL
Why Foundation Logistics
Competitive base salary, annual bonus and equity.
Medical, dental and vision coverage starting day one, and a 401(k) with a 5% match.
Flexible PTO, 11 paid holidays, and paid parental leave.
A $2,500 annual learning budget, with certification exams fully covered.
Remote-first culture with quarterly team on-sites.
Foundation Logistics is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or veteran status.