Data Engineer

Evans Transportation, Inc.; Delafield, Northern (WI, KY); Hybrid; USD 100,000 - 150,000; Full time

Job summary

Evans Transportation is seeking a Data Engineer to design, build, and maintain data pipelines powering analytics and decision-making. You will own pipelines moving data from source systems to clean, well-modeled datasets used by analysts, data scientists, and business teams.

Responsibilities include modeling data in warehouses, integrating diverse data sources, ensuring data quality, and collaborating with cross-functional teams to deliver usable data products.

Qualifications

• 3+ years of experience in data engineering or related role.
• Strong proficiency in SQL and programming knowledge (.NET and Python).
• Solid data modeling, warehousing concepts, and distributed data systems understanding.
• Good problem-solving skills and focus on data quality.

Responsibilities

• Design, build, and maintain scalable data pipelines (ETL/ELT).
• Model and structure data in warehouses and lakehouses for analytics.
• Integrate data from databases, APIs, third-party platforms, and event streams.
• Ensure data quality, reliability, and observability through testing and monitoring.
• Optimize pipeline performance and manage cost and scalability.
• Implement data governance, security, and access control best practices.
• Collaborate with analysts, data scientists, and engineers to deliver usable data products.
• Document data flows, schemas, and processes for maintainability.
• Perform all other duties as assigned.

Skills

SQL

.NET

Python

Data modeling

Warehousing concepts

Distributed data systems

Data quality

Problem-solving

Tools

Airflow

Dagster

dbt

Azure

Terraform

Docker

Git

Job description

Description

THE POSITION

Under the direction of the Manager, Data & Analytics, this role will be the Data Engineer responsible for designing, building, and maintaining the data infrastructure that powers analytics, reporting, and data-driven decision-making across Evans Transportation. This position owns the pipelines that move and transform data from source systems into clean, reliable, well-modeled datasets that analysts, data scientists, and business teams depend on.

Requirements

ROLES AND RESPONSIBILITIES

• Design, build, and maintain scalable batch and streaming data pipelines (ETL/ELT).
• Model and structure data in warehouses and lakehouses to support reporting and analytics use cases.
• Integrate data from a wide range of sources: databases, APIs, third-party platforms, and event streams.
• Ensure data quality, reliability, and observability through testing, monitoring, and alerting.
• Optimize pipeline and query performance and manage cost and scalability of data systems.
• Implement and enforce data governance, security, and access-control best practices.
• Collaborate with analysts, data scientists, and software engineers to understand requirements and deliver usable data products.
• Document data flows, schemas, and processes to keep the platform maintainable.
• Perform all other duties as assigned.

An individual in this position must be able to successfully perform the essential duties and responsibilities listed above. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of this position.

The above list reflects the general details necessary to describe the principle and essential functions of the position and shall not be construed as the only duties that may be assigned for the position.

MINIMUM QUALIFICATIONS AND REQUIREMENTS

Experience / Training: 3+ years of experience in data engineering or a closely related role. Strong proficiency in SQL and some programming knowledge, preferably .NET and Python. Solid understanding of data modeling, dimensional modeling, warehousing concepts, and distributed data systems. Strong problem-solving skills and attention to data quality and correctness.

Licenses / Certifications: None required

Technology / Equipment: Hands-on experience with a cloud data warehouse and/or lakehouse platform. Experience building pipelines with orchestration tools (e.g., Airflow, Dagster, or dbt for transformations). Familiarity with a major cloud provider, preferably Azure.

PREFERRED QUALIFICATIONS AND REQUIREMENTS

Experience / Training: Exposure to data governance, lineage, or catalog tools. Experience supporting machine learning or analytics teams in production.

Licenses / Certifications: None specified

Technology / Equipment: Infrastructure-as-code and CI/CD experience (Terraform, Docker, Git-based workflows). Azure resource implementation with a working understanding of networking and security fundamentals, including virtual networks, private endpoints, firewall and IP rules, and managed identities. Experience with Microsoft Fabric and OneLake.

PHYSICAL AND MENTAL DEMANDS

While performing the duties of this job, the employee must be able to continuously sit, use a keyboard, calculator, and telephone. The employee is occasionally required to stand, walk, stoop, and/or kneel. The employee must occasionally lift and/or move up to 10 pounds while moving files or small packages. Specific vision abilities required by this job include close vision and the ability to adjust focus. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

The mental and physical requirements described here are representative of those that must be met by an individual to successfully perform the essential functions of this position.

WORK ENVIRONMENT

Work is performed in an office environment, with hybrid/remote flexibility available for the ideal candidate. The noise level in the work environment is usually moderate. The work environment characteristics described here are representative of those an individual encounters while performing the essential functions of this position.

The work environment characteristics described here are representative of those an individual encounters while performing the essential functions of this position.