Bow Wave LLC is seeking a Data Engineer 3 to design, develop, and maintain scalable ETL pipelines supporting structured and unstructured datasets. This onsite role in Arlington, VA includes responsibilities across data ingestion, transformation, monitoring, documentation, and migration, with a TS clearance required.
What you’ll do
- 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 find workflow optimization and automation opportunities.
- Monitor 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 improve reliability, scalability, and efficiency.
- Document data flows, transformation logic, and operational procedures to support maintainability and knowledge sharing.
Requirements
- 2+ years of professional experience, including hands-on work with data analysis, ETL development, and data migration.
- Proficiency in SQL, including complex queries, transformations, and performance tuning.
- Working knowledge of 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 including AWS Redshift, Google BigQuery, Azure SQL, or similar.
Technologies
SQL, Python, Apache Airflow, Talend, dbt, AWS Redshift, Google BigQuery, Azure SQL, AWS, Azure, Google Cloud Platform, Hadoop, Spark, Power BI, Tableau, Looker, Git
Preferred qualifications
- Experience with cloud ecosystems such as AWS, Azure, or Google Cloud Platform.
- Knowledge of big data technologies like Hadoop, Spark, or other distributed processing frameworks.
- Exposure to data visualization tools (Power BI, Tableau, Looker) and version control systems such as Git.
- Experience designing automated data workflows or integrating workflow orchestration tools.
Core skills & competencies
- ETL pipeline development and optimization
- SQL and Python for data processing
- Data modeling and profiling
- Understanding of data warehousing concepts
- Cross-functional collaboration
- Problem-solving and root cause analysis
- Ability to document technical processes clearly
- Continuous improvement mindset
Location: Arlington, VA (onsite)
Salary: USD 90,000 per year
Minimum experience: 2 years
Education: Bachelor’s Degree Key