Data Engineer

TMC Transportation is a dynamic, employee-owned company renowned for its commitment to excellence in service. Our culture emphasizes safety, high standards, and continuous growth, fostering an energetic environment where every team member contributes to our shared success.

Join a team that’s modernizing data from the ground up. We’re building a scalable, high‑impact data platform using Snowflake, dbt, and Airbyte — and we’re looking for a Data Engineer who’s passionate about turning complex, legacy logic into modern, reusable data assets. If you enjoy solving data challenges, exploring AI‑driven possibilities, and driving meaningful change, this role is for you.

SHIFT: 40 hours per week, Monday-Friday. Team is available between 7-5 central time, can be flexible work hours between those with a consistent schedule.

Onsite with potential hybrid opportunity

• Design and build modern data solutions — lead design and implementation for both new (greenfield) initiatives and legacy modernization efforts.
• Migrate and refactor legacy logic — extract transformation and business logic from existing reports, scripts, and code into documented, centralized models.
• Champion best practices — advocate for clean data architecture, maintainable code, reproducible builds, and data quality.
• Develop and deploy workflows — implement robust ELT pipelines using Snowflake, dbt, and Airbyte.
• Collaborate on AI/ML integration — support machine learning and AI initiatives by preparing reliable, well-structured training data and partnering with data scientists.
• Contribute to data strategy — collaborate across teams to strengthen our data foundation and align with enterprise data standards.
• Mentor peers and enhance processes — promote automation, monitoring, and scalable development patterns.
• Support production environments — occasionally provide after-hours support for critical workloads.

You may work with:

• Snowflake
• dbt (data build tool)
• Airbyte
• SQL Server
• Python
• Terraform
• Machine Learning and AI tools such as Sage Maker, Snowpark ML, or similar frameworks
• (Secondary exposure to AWS tools such as Lambda, S3, Glue, and Cloud Watch)

• Bachelor’s degree in Computer Science, Data Science, Mathematics, Information Systems, or a related technical field—or equivalent experience.
• 5+ years of experience on a reporting, data, or software engineering team.
• Strong SQL and data modeling skills with hands-on experience in ELT workflows.
• Proficiency in Python or C# for data processing and automation.
• Experience contributing to or supporting machine learning or AI workflows
• Independent operator with experience planning, building, and deploying workloads to cloud environments.

• Experience with Snowflake data architecture, dbt model development, and Airbyte integration.
• Familiarity with documentation and architecture visualization tools such as Miro, Lucidchart, or equivalent.
• Snowflake certifications such as Snow Pro Core or Snow Pro Advanced.
• Experience modernizing or sun setting legacy systems with minimal business disruption.
• Prior technical leadership or mentorship experience.
• Background in quality or process improvement (Lean, Six Sigma, or similar).
• Strong root cause analysis and risk mitigation skills.

We know great data engineers come from all kinds of backgrounds. Even if you don’t check every box but have strong skills, curiosity, and a drive to build modern data solutions, we’d love to hear from you. Apply anyway - you might be the perfect fit we didn t know we needed!