Data Engineer

Socket.dev; Delafield (WI); Hybrid; USD 90,000 - 140,000; Full time

Benefits offered by this job

Hybrid/Remote work flexibility

Job summary

Evans Transportation is seeking a Data Engineer to design, build, and maintain data pipelines powering analytics, reporting, and data-driven decision-making. You will own the pipelines that move data from source systems into clean, well-modeled datasets used by analysts and data scientists.

This role emphasizes data quality, observability, and collaboration with cross-functional teams, with hybrid/remote flexibility and a focus on scalable data infrastructure.

Qualifications

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

Responsibilities

• Design, build, and maintain scalable batch and streaming data pipelines (ETL/ELT).
• Model data in warehouses and lakehouses to support analytics use cases.
• Integrate data from 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 deliver usable data products.
• Document data flows, schemas, and processes to keep the platform maintainable.

Skills

SQL

.NET

Python

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.

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.

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