Data Engineer

Emergent Software; Iowa City (IA); Hybrid; USD 100,000 - 120,000; Full time

Job summary

Emergent Software is seeking a Data Engineer for a hybrid role based in Iowa City, IA. The role focuses on building scalable ETL/ELT pipelines, ensuring data quality, and delivering reliable datasets for reporting and analytics.

You will design and maintain data infrastructure, automate manual tasks, monitor pipelines, and troubleshoot data quality, schema, and workflow issues while collaborating with business stakeholders to meet data requirements.

Qualifications

• Experience building and supporting production data pipelines.
• Proficiency in SQL and Python for data processing.
• Experience with structured, semi-structured, and unstructured data.
• Strong analytical, troubleshooting, and communication skills.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines to support reporting and analytics.
• Integrate data from ERP, manufacturing, and other systems into centralized platforms.
• Build scalable data workflows across extraction, transformation, and loading.
• Develop and maintain data models, testing frameworks, and documentation.
• Monitor pipeline performance and troubleshoot data quality, schema, and workflow issues.
• Collaborate with stakeholders to understand data requirements and deliver scalable solutions.
• Automate manual processes to improve data delivery efficiency.
• Ensure data accuracy, consistency, security, and reliability across systems.
• Stay current with emerging data engineering technologies and best practices.

Skills

Production pipelines

SQL

Python

Structured data

Semi/Unstructured data

Analytical skills

Communication

Prioritization

Tools

Prefect

Apache Airflow

dbt

MongoDB

Redis

Microsoft SQL Server

Docker

Job description

Emergent Software is hiring a Data Engineer for a hybrid role in Iowa City, IA. This position builds the reliable data foundation that supports reporting, analytics, and business decision-making, with a focus on scalable ETL/ELT pipelines, data quality, and dependable datasets.

You will design and maintain data infrastructure that helps technical and business teams work from consistent, accurate information. The scope includes automating manual work to improve delivery efficiency, monitoring pipeline performance, and troubleshooting issues across data quality, schemas, and workflows. With tooling across orchestration, transformation, and databases, you will have opportunities to apply modern data engineering practices and keep improving how data moves through the organization.

What you will do

• Design, develop, and maintain ETL/ELT pipelines that support enterprise reporting and analytics.
• Integrate data from ERP, manufacturing, and other business systems into centralized data platforms.
• Build scalable data workflows across extraction, transformation, and loading processes.
• Develop and maintain data models, testing frameworks, and technical documentation.
• Monitor pipeline performance and troubleshoot problems related to data quality, schema, and workflow behavior.
• Collaborate with business stakeholders to understand data requirements and deliver scalable solutions.
• Automate manual processes and improve overall data delivery efficiency.
• Ensure data accuracy, consistency, security, and reliability across systems.
• Stay current with emerging data engineering technologies and best practices.

What you bring

• Strong experience building and supporting production data pipelines.
• Proficiency in SQL and Python.
• Experience working with structured, semi-structured, and unstructured data.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and organizational skills.
• Ability to manage multiple priorities in a fast-paced environment.

Tools you may work with

SQL, Python, Prefect, Apache Airflow, dbt, MongoDB, Redis, Microsoft SQL Server, Docker

Nice to have

• Experience in manufacturing, ERP, or operational data environments.
• Experience with orchestration tools such as Prefect or Apache Airflow.
• Experience with CDC or incremental data processing strategies.
• Familiarity with dbt, MongoDB, Redis, Microsoft SQL Server, and Docker.
• Knowledge of modern data architecture and cloud analytics platforms.

Interview process

• Application (5 minutes)
• Online Assessment (40 minutes)Initial Video Interview (30-45 minutes)
• Client Phone Interview (30 minutes)
• Client On-site interview (60 minutes)
• Job Offer

Compensation: USD 100,000 - 120,000 per year.