Data Engineer 3 - TS clearance required - Wash DC area

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

Job summary

Bow Wave LLC in Arlington, VA is seeking a Data Engineer to design, develop, and maintain scalable ETL pipelines, ensuring data accuracy and performance across cloud platforms. You will collaborate with analysts and developers to translate requirements into robust data solutions, applying best practices in data warehousing and automating workflows for reliability and scalability.

You will work with cross-functional teams to optimize data structures, implement migration strategies, and ensure

Qualifications

• Bachelor's degree or equivalent in a related field.
• 2+ years of professional data engineering or ETL experience.
• Strong SQL skills with complex queries and performance tuning.
• Python proficiency for data manipulation and automation.
• Experience with ETL frameworks and orchestration tools.
• Understanding of data warehousing concepts.
• Experience with cloud data platforms (AWS Redshift, BigQuery, Azure SQL).

Responsibilities

• Design, develop, and maintain scalable ETL pipelines.
• Analyze data structures and mappings to optimize workflows.
• Monitor data accuracy and integrity across systems.
• Implement data migration strategies for modernization.
• Collaborate with analysts, data scientists, and developers.
• Monitor pipeline performance and improve reliability and scalability.
• Document data flows and transformation logic for maintainability.

Skills

ETL pipeline development

SQL

Python for data processing

Data modeling

Data warehousing concepts

Cross-functional collaboration

Documentation of processes

Education

Bachelor's degree

Tools

Apache Airflow

Talend

dbt

Git

Job description

Education Requirement: Bachelor's Degree

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

Required Skills & Experience

• 2+ Years Professional Experience
• Hands-on experience with data analysis, ETL development, and data migration.
• Proficiency in SQL, including writing complex queries, transformations, and performance tuning.
• Familiarity with 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 principles including dimensional modeling and staging architecture.
• Exposure to cloud-based data platforms such as AWS Redshift, Google BigQuery, Azure SQL, or similar environments.

Preferred Qualifications

• Experience with cloud ecosystems such as AWS, Azure, or Google Cloud Platform.
• Knowledge of big data technologies (Hadoop, Spark, or distributed processing frameworks).
• Exposure to data visualization tools (Power BI, Tableau, Looker) and version control systems (e.g., Git).
• Experience designing automated data workflows or integrating workflow orchestration tools.

Core Skills & Competencies

• ETL pipeline development & optimization
• SQL & Python for data processing
• Data modeling and profiling
• Understanding of data warehousing concepts
• Cross-functional collaboration
• Problem-solving & root cause analysisAbility to document technical processes clearly
• Continuous improvement mindset