Data Automation Engineer

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

Location: Hybrid (Washington D.C) 2-3 times a week

Clearance: Active Secret

Employment Type: Full Time

Company Description

Big Impact Tech (BIT) is a Small Business providing IT and business management consulting services to federal and commercial clients. We deliver mission-focused solutions in digital transformation, cloud technologies, cybersecurity, enterprise platforms, and program management.

Position Overview

We are seeking a skilled Data Automation Engineer to support Coast Guard data modernization and automation initiatives. The ideal candidate will design, develop, and maintain automated data pipelines, workflows, and integration solutions that improve operational efficiency, data quality, and reporting capabilities. This role requires expertise in data engineering, process automation, ETL/ELT development, and cloud-based data solutions.

Key Responsibilities

• Design, develop, and maintain automated data pipelines and workflows to support business and operational reporting requirements.
• Build and optimize ETL/ELT processes for ingesting, transforming, and loading data from multiple source systems.
• Develop data integration solutions using APIs, databases, cloud services, and enterprise applications.
• Automate manual data collection, validation, reconciliation, and reporting processes.
• Monitor and troubleshoot data pipelines to ensure reliability, performance, and data integrity.
• Implement data quality checks, exception handling, and monitoring frameworks.
• Collaborate with business stakeholders, analysts, developers, and data engineers to gather requirements and deliver automated solutions.
• Support cloud-based data platforms and data warehouse environments.
• Develop scripts and automation tools to streamline operational processes.
• Create and maintain technical documentation, process flows, and standard operating procedures.
• Ensure compliance with organizational security, governance, and data management standards.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Science, or a related field.
• 3+ years of experience in data engineering, automation, or data integration roles.
• Strong experience with Python, SQL, and automation scripting.
• Experience developing ETL/ELT pipelines and workflow orchestration.
• Experience with relational and non-relational databases.
• Strong understanding of data modeling, data transformation, and data quality practices.
• Experience working with APIs, file-based integrations, and enterprise data systems.

Preferred Qualifications

• Experience supporting Coast Guard or other government-related programs.
• Experience with cloud platforms such as Azure, AWS, or Google Cloud.
• Experience with Azure Data Factory, Databricks, Snowflake, Microsoft Fabric, Apache Airflow, or similar tools.
• Knowledge of DevOps, CI/CD pipelines, and Infrastructure as Code (IaC).
• Experience with Power BI, Qlik, Tableau, or other reporting tools.
• Familiarity with Agile/Scrum methodologies.

Technical Skills

• Python
• SQL
• ETL/ELT Development
• API Integration
• Databricks
• Snowflake
• Git/GitHub
• Data Warehousing
• Process Automation
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to manage multiple projects and priorities.
• Strong attention to detail and commitment to data accuracy.
• Self-motivated with the ability to work independently and in team environments.