EngineerJobs.io
← Back to all jobs

Job Description

Arlington, VA onsite role focused on building and operating scalable ETL for structured and unstructured data, with TS clearance required.

Responsibilities

  • Design, develop, and maintain scalable ETL pipelines to ingest, transform, and load structured and unstructured datasets.
  • Analyze complex data structures and source-to-target mappings to find optimization opportunities and automate workflows.
  • Monitor pipelines to ensure data accuracy, consistency, and integrity across systems and platforms.
  • Develop and implement data migration strategies that support application modernization and platform or cloud transitions.
  • Work with analysts, data scientists, developers, and business partners to convert requirements into effective data engineering solutions.
  • Track pipeline performance, troubleshoot operational issues, and improve reliability, scalability, and efficiency.
  • Document data flows, transformation logic, and operational procedures for maintainability and knowledge sharing.

Requirements

  • 2+ years of professional experience; hands-on work with data analysis, ETL development, and data migration.
  • Strong SQL skills, including writing complex queries, performing transformations, and conducting performance tuning.
  • Proficiency with Python for data manipulation, scripting, and workflow automation.
  • Experience using ETL frameworks or orchestration tools such as Apache Airflow, Talend, dbt, or similar.
  • Knowledge of data warehousing concepts, including dimensional modeling and staging architecture.
  • Exposure to cloud data platforms such as AWS Redshift, Google BigQuery, Azure SQL, or similar environments.
  • TS clearance required.

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 AWS, Azure, or Google Cloud Platform ecosystems.
  • Knowledge of big data technologies such as Hadoop, Spark, or distributed processing frameworks.
  • Exposure to data visualization tools such as Power BI, Tableau, or Looker and version control systems such as Git.
  • Experience designing automated data workflows and integrating workflow orchestration tools.

Core Skills & Competencies

  • ETL pipeline development & optimization
  • SQL & Python for data processing
  • Data modeling and profiling
  • Data warehousing concepts
  • Cross-functional collaboration
  • Problem-solving & root cause analysis
  • Clear documentation of technical processes
  • Continuous improvement mindset

Compensation & Location

  • $90,000 per year
  • Arlington, VA (onsite)

Education

  • Bachelor's Degree (Key)

Similar Jobs