Website Transflo

Senior Data Engineer – Transflo

Location: Remote (United States)
Employment Type: Full-Time
Department: Data Platform & Architecture
Industry: Transportation, Logistics, Supply Chain Tech, SaaS
Core Stack: Amazon Redshift, AWS Glue, dbt, Python, Kinesis/MSK, Terraform

About Transflo

Transflo is a leading software innovator in the transportation and logistics sector, powering mobile, telematics, and business process automation solutions across North America. Our SaaS and AI-driven platforms empower freight carriers, brokers, and shippers to automate workflows, cut operational overhead, and connect supply chain ecosystems seamlessly.

About the Role

Transflo is hiring a Senior Data Engineer to architect, scale, and govern our enterprise data platform from raw ingestion to curated, analytics-ready data products.
In this strategic hands-on role, you will own our Medallion Architecture (Bronze-Silver-Gold) on Amazon Redshift and S3—scaling near real-time streaming and batch pipelines that fuel internal business intelligence, operational telemetry, data science models, and Transflo’s external Data as a Service (DaaS) offerings.

Key Responsibilities

  • Redshift Data Warehouse Architecture: Design and optimize enterprise data warehouses on Amazon Redshift using star/snowflake dimensional modeling, slowly changing dimensions (SCDs), custom distribution/sort keys, and WLM query tuning.
  • Medallion Architecture Implementation: Construct scalable Bronze (raw ingestion), Silver (cleansed/standardized), and Gold (curated analytics) data layers to support business reporting and DaaS APIs.
  • Heterogeneous Data Ingestion: Build robust ELT/ETL pipelines ingesting structured and unstructured data from REST APIs, IBM DB2, MySQL, Amazon Aurora, DynamoDB, PostgreSQL, and flat files (Parquet, JSON, CSV).
  • Streaming & Event Pipelines: Implement low-latency streaming architectures using AWS Kinesis Data Streams, Kinesis Firehose, Amazon MSK (Managed Kafka), and EventBridge.
  • Orchestration & Data Quality: Orchestrate workflows using AWS Glue, dbt, and Apache Airflow. Enforce automated data quality checks, profiling, and data contracts to meet strict SLAs.
  • Data Governance & Security: Maintain metadata catalogs, automated lineage tracking, row/column-level security, and RBAC via AWS Glue Data Catalog and Redshift Data Sharing.
  • Infrastructure as Code (IaC): Provision and control versioned data infrastructure using Terraform.

Qualifications & Required Experience

  • Experience: 5+ years of dedicated professional data engineering experience building production-grade data platforms.
  • Amazon Redshift Mastery: Deep expert-level proficiency in Redshift cluster tuning, distribution strategies, query optimization, and ANSI SQL.
  • Data Modeling: Strong working knowledge of Kimball dimensional modeling theory, fact/dimension table design, and schema evolution.
  • Streaming & Orchestration: Proven track record with real-time technologies (Kafka/MSK, Kinesis) and orchestrators (dbt, AWS Glue, Airflow).
  • Programming & IaC: Advanced Python programming skills for pipeline scripting and automation; hands-on experience using Terraform on AWS.
  • Industry Experience (Bonus): Direct background in logistics, supply chain, fleet management telematics, or high-volume transactional SaaS environments.

Role Summary

Attribute Details
Job Title Senior Data Engineer
Company Transflo
Work Location Remote (United States)
Primary Stack AWS Redshift, S3, dbt, Python, Kinesis, MSK, Airflow, Terraform
Architecture Medallion (Bronze/Silver/Gold), DaaS, Dimensional Modeling
Min. Experience 5+ Years

To apply for this job please visit remotejobhiring.com.