Data Engineer

Evans Transportation; Delafield (WI); Hybrid; USD 90,000 - 130,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 from source systems to clean datasets used by analysts and data scientists across the business.

The role requires 3+ years in data engineering, strong SQL, and experience with data modeling and warehousing concepts. A hybrid work arrangement is available, with preference for candidates in Wisconsin or nearby regions.

Qualifications

• 3+ years of experience in data engineering or related field.
• Strong proficiency in SQL and programming knowledge (Python/.NET).
• Solid understanding of data modeling and warehousing concepts.

Responsibilities

• Design, build, and maintain scalable data pipelines (ETL/ELT).
• Model and structure data in warehouses/lakehouses for analytics.
• Integrate data from databases, APIs, and event streams.
• Ensure data quality, observability, and monitoring.
• Optimize pipeline performance and manage costs.
• Implement data governance, security, and access controls.
• Collaborate with analysts, data scientists, and engineers to deliver data products.
• Document data flows, schemas, and processes.

Skills

SQL

Python

.NET

Data modeling

Dimensional modeling

Warehousing

Distributed data systems

Tools

Airflow

Dagster

dbt

Azure

Terraform

Docker

Git

Job 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.

DESCRIPTION

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.