Data Automation Engineer in Mundelein

Energy Jobline ZR; Mundelein (IL); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Big Impact Tech (BIT) seeks a Data Automation Engineer to support Coast Guard data modernization. You will design, develop, and maintain automated data pipelines, workflows, and integration solutions to improve operational efficiency, data quality, and reporting capabilities in a federal context.

The role requires expertise in ETL/ELT development, cloud data platforms, APIs, and data governance, with collaboration across stakeholders and engineers.

Qualifications

• Bachelor’s degree in a related field is required.
• 3+ years of experience in data engineering, automation, or data integration.
• Proficiency with Python, SQL, and ETL/ELT development.
• Experience with APIs and cloud data platforms is preferred.

Responsibilities

• Design, develop, and maintain automated data pipelines and workflows.
• Build and optimize ETL/ELT processes for multiple source systems.
• Develop data integration solutions using APIs, databases, and cloud services.
• Automate manual data collection, validation, reconciliation, and reporting.
• Monitor and troubleshoot data pipelines for reliability and data quality.
• Implement data quality checks, exception handling, and monitoring.
• Collaborate with stakeholders and engineers to deliver automated solutions.
• Support cloud data platforms and data warehouse environments.
• Develop scripts and automation tools to streamline processes.
• Create and maintain technical documentation and SOPs.
• Ensure compliance with security, governance, and data management standards.

Skills

Strong analytical skills

Excellent communication

Ability to manage multiple projects

Collaboration across teams

Education

Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Science, or a related field

Tools

Python

SQL

ETL/ELT Development

Data Pipeline Automation

API Integration

Azure Data Factory

Databricks

Snowflake

Apache Airflow

Git/GitHub

Job description

Job Description

Data Automation Engineer

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.

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
• Data Pipeline Automation
• API Integration
• Azure Data Factory / Microsoft Fabric
• Databricks
• Snowflake
• Apache Airflow
• Git/GitHub
• Cloud Data Platforms
• Data Warehousing
• Process Automation

Key Competencies

• 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.