[Hiring] Senior Data Engineer @Transflo

Role Description

Transflo is seeking a Senior Data Engineer to architect and own our enterprise data platform — from raw ingestion through curated, analytics-ready data products. You will be the foundational engineer behind our data warehouse, data pipeline infrastructure, and the bronze-silver-gold medallion architecture that serves internal analytics teams, operational reporting, and our growing Data as a Service (DaaS) capability.

This role demands both deep technical expertise and a strategic mindset. You will work across a wide range of source systems — APIs, relational databases, NoSQL stores, file-based feeds, and streaming data — normalizing and modeling data into reliable, governed, and high-performance analytical assets. You will build and scale systems designed for near real-time data environments supporting high-traffic, mission-critical workloads in the transportation and logistics industry.

Core Areas of Responsibility

• Architect, build, and evolve a scalable enterprise data warehouse on Amazon Redshift.
• Design and implement bronze, silver, and gold data layer architecture (medallion architecture).
• Develop dimensional data models, fact and dimension tables, slowly changing dimensions (SCDs), and aggregate structures.
• Apply rigorous data modeling practices including schema design, constraint definition, indexing strategy, sort keys, distribution keys, and query plan optimization.
• Build, own, and maintain robust batch and streaming data pipelines.
• Implement real-time and near real-time data streaming architectures using AWS-native services.
• Design pipeline frameworks for data extraction, transformation, and loading (ETL/ELT).
• Ensure pipeline reliability, idempotency, fault tolerance, and automated recovery.
• Own data quality end-to-end.
• Build and continuously evolve tooling and processes to support data governance.
• Define and enforce data contracts between source systems and the warehouse.
• Partner with data consumers to understand consumption patterns.
• Support the architecture and buildout of a reliable, scalable Data as a Service (DaaS) product.
• Contribute to the data platform infrastructure using infrastructure-as-code practices (Terraform).
• Design for scale: apply partitioning strategies, workload management (WLM) tuning, concurrency scaling, and caching patterns.
• Champion security and compliance best practices across the data platform.
• Collaborate with software engineers, mobile platform teams, and DevOps.
• Leverage AI-assisted development practices and tooling.

Qualifications

• 5+ years of professional data engineering experience.
• Expert-level experience with Amazon Redshift.
• Deep proficiency in SQL for complex analytical queries.
• Hands-on experience ingesting data from heterogeneous source systems.
• Proven experience designing and implementing medallion (bronze/silver/gold) or equivalent layered data architectures.
• Strong working knowledge of star schema and snowflake schema design.
• Experience building real-time or near real-time data pipelines.
• Proficiency with ETL/ELT orchestration tools.
• Demonstrated experience implementing data governance practices.
• Infrastructure-as-code experience with Terraform.
• Strong Python skills for pipeline development.
• Deep understanding of data reliability engineering.

Skills/Experience

• Experience in the transportation, logistics, trucking, or fleet management industry.
• Experience building DaaS or data product offerings.
• Knowledge of columnar storage formats and lakehouse patterns.
• Familiarity with BI and analytics consumption tools.
• Experience with data observability platforms.
• Contributions to reusable data platform tooling.
• Experience working in fully remote, distributed engineering teams.