AnaVation

ETL Software Engineer

AnaVation
Apply
2 months ago
Chantilly, VA, USASenior

Base Salary

$90k - $202k/yr

Responsibilities

  • Build ETL/ELT data pipelines.
  • Optimize SQL queries and work with relational databases.
  • Develop Python-based ETL processes.
  • Perform data transformation, cleansing, normalization, validation, and integration.
  • Work with Elasticsearch or OpenSearch and enterprise source systems.
  • Use version control and collaborative coding practices in an Agile Scrum environment.
  • Work with scripting, containerization, and Linux environments.
  • Apply data quality, monitoring, governance, metadata management, and data lineage best practices.

Requirements

  • Active Top Secret clearance and SCI eligibility with the ability to pass a CI polygraph.
  • Bachelor’s degree in computer science, Information Systems, Engineering, or a related field, or equivalent experience.
  • 5+ years of experience in data engineering.
  • 3+ years of Python development experience focused on ETL processes.
  • Experience with SQL query optimization and relational databases such as Oracle, PostgreSQL, MySQL, or MSSQL.
  • Experience with Elasticsearch or OpenSearch.
  • Experience with version control systems such as Git and collaborative coding practices.
  • Experience with scripting languages such as Bash, containerization technologies such as Docker, and Linux environments.
  • Preferred experience with data quality, validation, monitoring, data governance, metadata management, data lineage, data warehousing, big data frameworks, and API-based data integration.
  • Strong problem-solving skills and attention to detail.

Benefits

  • Medical insurance with company cost sharing for employees and dependents.
  • Company-paid dental, vision, short-term disability, and long-term disability insurance.
  • 401(k) plan with a generous match and immediate vesting.
  • Paid leave and holiday package.
  • Tuition and training reimbursement.
  • Life and AD&D insurance.
  • Competitive pay.

Tech Stack

BashC#DockerElasticsearchGitJavaLinuxMicrosoft SQL ServerMySQLPostgreSQLPythonSQL

Categories

Data Engineering
AnaVation

About AnaVation

51-200 employees

AnaVation provides cybersecurity, software, cloud, and data engineering services to U.S. government customers, particularly the federal intelligence community. The company builds and supports cyber collection and processing systems, SOC/incident response capabilities, and big-data and cloud infrastructure used across multiple agencies, including AWS-based environments. Founded in 2013 and headquartered in Chantilly, Virginia, AnaVation is a private partnership focused on complex government programs.

Contact me