Data Automation Engineer — Hybrid DC: ETL & Cloud Pipelines

Big Impact Tech (BIT); Washington (District of Columbia); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Big Impact Tech (BIT) is hiring a Data Automation Engineer to design and maintain automated data pipelines for Coast Guard data modernization. The role focuses on ETL/ELT development, API integrations, and cloud-based data solutions to improve data quality and reporting.

You will collaborate with analysts, developers, and stakeholders to automate data collection and validation, while ensuring security and governance standards across platforms.

Qualifications

• Bachelor’s degree in a related field.
• 3+ years in data engineering, automation, or data integration roles.
• Proficiency in Python, SQL, and automation scripting.
• Experience building ETL/ELT pipelines and workflow orchestration.
• Experience with relational and non-relational databases.
• Strong data modeling, transformation, and quality practices.
• Experience with APIs, file-based integrations, and enterprise data systems.

Responsibilities

• Design, develop, and maintain automated data pipelines and workflows for reporting needs.
• Build and optimize ETL/ELT processes for multi-source data ingestion, transformation, and loading.
• Develop data integration solutions using APIs, databases, cloud services, and enterprise apps.
• Automate manual data collection, validation, reconciliation, and reporting tasks.
• Monitor and troubleshoot data pipelines for reliability, performance, and data integrity.
• Implement data quality checks, exception handling, and monitoring frameworks.
• Collaborate with stakeholders, analysts, and engineers to deliver automated solutions.
• Support cloud data platforms and data warehouse environments.
• Create and maintain technical docs, process flows, and SOPs.
• Ensure compliance with security, governance, and data management standards.

Skills

Python

SQL

ETL/ELT

API Integration

Data Warehousing

Process Automation

Git/GitHub

Data Modeling

Analytical Skills

Education

Bachelor’s degree in Computer Science/IT/Engineering/Data Science or related

Tools

Azure Data Factory

Databricks

Snowflake

Apache Airflow

Microsoft Fabric

Terraform/IaC

Job description

Big Impact Tech (BIT) is hiring a Data Automation Engineer to design and maintain automated data pipelines for Coast Guard data modernization. The role focuses on ETL/ELT development, API integrations, and cloud-based data solutions to improve data quality and reporting.

You will collaborate with analysts, developers, and stakeholders to automate data collection and validation, while ensuring security and governance standards across platforms.