Data Extract, Transform, Load (ETL) Systems Engineer

LV8D Solutions, LLC; Chantilly, Northern (VA, KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

A technology solutions provider is seeking a Data Extract, Transform, Load (ETL) Systems Engineer in Chantilly, VA. This role focuses on designing and implementing data pipelines for analysis by senior decision-makers. Candidates must have a Bachelor's or Master's degree in STEM with relevant experience. Proficiency in API design, data integration, and ETL processes is required, along with a strong background in programming languages such as Python, Java, and SQL. U.S. Citizenship is mandatory.

Qualifications

• Bachelor’s degree in science, technology, engineering, or mathematics (STEM) and minimum 3+ years of relevant experience.
• Master’s degree in science, technology, engineering, or mathematics (STEM) and 1+ years of experience.
• Must be a U.S. Citizen.

Responsibilities

• Demonstrated proficiency in designing and implementing ETL processes.
• Experience with Application Programming Interfaces (APIs).
• Ensure data quality and integrity throughout the ETL process.

Skills

API design

Data pipeline automation

Python

Java

SQL

AWS services knowledge

Tableau

Data integration tools

Education

Bachelor’s degree in STEM

Master’s degree in STEM

Tools

Tableau

AWS Glue

Azure Data Factory

Apache Kafka

MS SQL

MongoDB

Job description

LV8D Solutions has an immediate opening for a Data Extract, Transform, Load (ETL) Systems Engineer in Chantilly, VA to focus on Application Programming Interface design, implementation, and maintenance to extract data from various sources, transform it, and visualize it for analysis and use by Senior decision makers. This role also involves advising on data infrastructure, data quality, and data security while employing a variety of technical tools and solutions.

The successful applicant will exhibit flexibility in task execution and provide technical expertise. As a SETA advisor, candidates will be required to demonstrate value-added judgment to advise the government on program activities. The successful candidate will produce recommendations and deliverables in a thorough, practicable, and consistent manner congruent with the organization’s objectives.

Qualifications

Education / Experience

• Bachelor’s degree in science, technology, engineering, or mathematics (STEM) and minimum 3+ years of relevant experience
• Master’s degree in science, technology, engineering, or mathematics (STEM) and 1+ years of experience
• Must be a U.S. Citizen

Clearance

• TS/SCI with CI Polygraph

Requirements / Responsibilities

• Demonstrated proficiency in designing and implementing data pipelines that automate the Extraction, Transformation, and Loading (ETL) process
• Experience with Application Programming Interfaces (APIs) and implementing “as-is” or “reworking” existing APIs
• Experience with Tableau extract, transform, and load functions
• A strong background in Python, Java, Scala, and/or SQL
• Significant AWS service knowledge
• Comprehensive understanding of data architecture and best practices
• Demonstrated ability to write scripts for data ETL
• Experience with data integration tools and platforms, such as Apache Kafka, Apache Flume, AWS Glue, Azure Data Factory, or Google Cloud Dataflow
• Proficiency in working with RESTful APIs and web services
• Proficiency with relational databases (e.g., MS SQL, MySQL, PostgreSQL, Oracle)
• Experience with NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB)
• Knowledgeable of data warehousing concepts and data warehousing platforms (e.g., Amazon Redshift, Google BigQuery, Snowflake)
• Experienced in documenting project requirements and schedule using agile project management techniques
• Experience with software configuration management techniques
• Experience with Retrieval Augmented Generation (RAG)
• AWS Solutions Architect, Data Analytics, or Developer Associate certification preferred
• Familiarity with data modeling, data cataloging, and/or data governance is desired
• Familiarity with the application and use of Artificial Intelligence (AI) and Machine Learning (ML) services is desired
• Design, develop, and implement ETL processes to extract, transform, and load data from various sources (e.g., databases, flat files, APIs).
• Build, maintain, and optimize data pipelines to ensure efficient and reliable data flow.
• Ensure data quality and integrity throughout the ETL process, addressing data cleansing, validation, and security concerns.
• Design and maintain data warehouse schema and data models, ensuring data consistency and accuracy.
• Provide technical expertise and guidance on data infrastructure, data modeling, and data governance practices.
• Monitor and optimize ETL pipeline performance, addressing bottlenecks and improving execution times.
• Troubleshoot ETL issues, identify root causes, and implement solutions.
• Create and maintain documentation for ETL processes, data mappings, and data models.
• Collaborate with cross-functional teams (e.g., data analysts, business users) to understand data requirements and ensure data quality.

Geographic Locations

Chantilly, Virginia