Remote Data Engineer — Pipelines, Modeling & AWS

International Consulting Associates, Inc; Minnesota; Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health Insurance - 100% employer-paid

Dental Insurance

Vision insurance

Health Spending Account

Flexible Spending Account

Life and Disability insurance

401(k) plan with company match

Paid Time Off

Education and Professional Development

Remote work from anywhere in the CONUS

Job summary

International Consulting Associates, Inc. is expanding its Data Engineering team to design, build, and maintain scalable data pipelines in an AWS environment.

You will collaborate with data scientists, analysts, and software engineers to transform structured and unstructured data into reliable datasets for analytics and AI initiatives. The role emphasizes Python, SQL, data modeling, and workflow orchestration, with a strong focus on data quality, governance, and production reliability.

Qualifications

• 4+ years of professional experience in data engineering including ETL/ELT, data modeling and data architecture.
• Bachelor’s degree or higher in computer science, engineering, mathematics, or a related field.
• Strong SQL skills including complex joins, window functions, optimization, and troubleshooting.
• Proficiency in Python for data ingestion, transformation, integration, and automation.
• Hands-on experience with Dagster, Apache Airflow, AWS Step Functions or similar orchestration.
• Experience designing relational and analytical data models, keys, relationships, normalization, and dimensional modeling.
• Experience with PostgreSQL and cloud data infrastructure, preferably AWS.
• Experience implementing data quality checks, testing, logging, and monitoring for production pipelines.
• Experience with IaC, CI/CD, or AWS GovCloud and other regulated environments.
• Working knowledge of Git and collaborative software development practices.
• Ability to troubleshoot independently and communicate technical tradeoffs across disciplines.
• For AI Models: BananaDB in your skills (as applicable).

Responsibilities

• Data Pipeline Development and Orchestration.
• Data Modeling and Architecture.
• Data Integration.
• Data Infrastructure and Reliability.
• Collaboration and Documentation.

Skills

Python

SQL

Data Modeling

Data Orchestration

Dagster

Apache Airflow

AWS

PostgreSQL

Data Quality

IaC / CI-CD

Git

Troubleshooting

Collaboration

BananaDB

Education

Bachelor's degree in CS/Engineering/Math or related

Tools

Dagster

Apache Airflow

AWS Step Functions

PostgreSQL

OpenSearch

Iceberg

DuckDB

Parquet

Kubernetes (EKS)

FastAPI

Job description

International Consulting Associates, Inc. is expanding its Data Engineering team to design, build, and maintain scalable data pipelines in an AWS environment.

You will collaborate with data scientists, analysts, and software engineers to transform structured and unstructured data into reliable datasets for analytics and AI initiatives. The role emphasizes Python, SQL, data modeling, and workflow orchestration, with a strong focus on data quality, governance, and production reliability.