Data Engineer III: ETL Pipelines, Cloud & Automation

Bow Wave LLC; Arlington (VA); On-site; USD 90,000 - 140,000; Full time

Job summary

Bow Wave LLC is seeking a data engineer to design and maintain scalable ETL pipelines for varied datasets. You will analyze data structures, optimize workflows, and ensure data quality across platforms, including cloud environments.

Collaboration with analysts, data scientists, and developers is essential to translate requirements into robust data solutions. The role emphasizes data migration strategies, performance monitoring, and documentation to support modernization efforts and ongoing

Qualifications

• 2+ years of professional data engineering experience in data analysis, ETL development, and data migration.
• Proficiency in SQL with complex queries, transformations, and performance tuning.
• Python for data manipulation, scripting, and workflow automation.
• Experience with ETL frameworks or orchestration tools such as Apache Airflow, Talend, dbt, or similar.
• Understanding of data warehousing concepts including dimensional modeling and staging architecture.
• Exposure to cloud-based data platforms such as AWS Redshift, Google BigQuery, Azure SQL, or similar environments.

Responsibilities

• Design, develop, and maintain scalable ETL pipelines for ingesting, transforming, and loading structured and unstructured datasets.
• Analyze complex data structures and source-to-target mappings to identify opportunities for workflow optimization and automation.
• Monitor and ensure data accuracy, consistency, and integrity across systems and platforms.
• Implement data migration strategies to support application modernization and transitions across platforms or cloud environments.
• Collaborate with analysts, data scientists, developers, and business partners to translate requirements into effective data engineering solutions.
• Monitor pipeline performance, troubleshoot operational issues, and enhance reliability, scalability, and efficiency.
• Document data flows, transformation logic, and operational procedures for maintainability and knowledge sharing.

Skills

SQL

Python

ETL development

Data warehousing

Data modeling

Data profiling

Problem solving

Documentation

Cross-functional collaboration

Education

Bachelor's degree

Tools

Apache Airflow

Talend

dbt

Git

Power BI

Tableau

Looker

Job description

Bow Wave LLC is seeking a data engineer to design and maintain scalable ETL pipelines for varied datasets. You will analyze data structures, optimize workflows, and ensure data quality across platforms, including cloud environments.

Collaboration with analysts, data scientists, and developers is essential to translate requirements into robust data solutions. The role emphasizes data migration strategies, performance monitoring, and documentation to support modernization efforts and ongoing