Data Engineer

Systech Federal; Chantilly (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

Systech Federal is seeking a skilled Data Engineer to extract, transform, and load data from diverse sources. You will design and optimize ETL workflows, implement data transformations, and ensure data quality across platforms.

The role requires strong Python and SQL abilities, Palantir experience, and a collaborative approach to supporting analytics teams. Expect a technically engaging environment with data-centric challenges.

Qualifications

• 3+ years of data engineering experience.
• Strong Python scripting and SQL skills.
• Experience integrating data from APIs, databases, and file systems.
• Experience with Palantir or similar ETL platforms.
• Strong analytical and problem-solving abilities.
• Excellent teamwork and communication.

Responsibilities

• Write robust Python and SQL scripts to automate data processing tasks.
• Integrate data from diverse sources into centralized systems.
• Implement data transformations, enrichment, and modeling workflows to ensure data quality and usability.
• Ensure data structures are optimized for performance and scalability.
• Provide technical guidance for Palantir tools across teams.
• Implement data quality checks, validation, and monitoring mechanisms.
• Integrate data from diverse sources into centralized systems.
• Maintain and improve data quality through validation and cleansing processes.

Skills

Python

SQL

Palantir

ETL

Data integration

Data quality

Troubleshooting

Education

Bachelor's degree

Tools

Palantir

Airflow

Apache Spark

Hadoop

AWS

Job description

Description

We are seeking a skilled, detail-oriented Data Engineer with expertise in Python, SQL, and Palantir (or other ETL platforms) to extract, transform, and load structured and unstructured data from various sources. The ideal candidate will have a strong background in data engineering and a deep understanding of ETL processes.

Key Responsibilities

• Write robust and efficient Python and SQL scripts to automate data processing tasks.
• Integrate data from diverse sources, such as databases, APIs, and flat files, into centralized systems.
• Implement data transformations, enrichment, and modeling workflows to ensure data quality and usability.
• Ensure data structures are optimized for performance and scalability.
• Provide technical guidance and support to ensure effective use of Palantir tools across teams.
• Implement data quality checks, validation, and monitoring mechanisms to ensure the accuracy and reliability of datasets.
• Integrate data from diverse sources, such as databases, APIs, and flat files, into centralized systems.
• Ensure proper data transformation and curation to meet business and analytics requirements.
• Maintain and improve data quality, consistency, and accuracy through validation and cleansing processes.

Requirements

• Active TS/SCI FSP is required to start*

Required Skills

• 3+ years of experience in data engineering.
• Strong proficiency in scripting and programming with Python.
• Expertise in working with SQL for data querying, transformation, and optimization.
• Experience with data integration from diverse sources such as APIs, relational databases, and file systems.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication and teamwork skills to collaborate with technical and business teams.

Preferred Skills

• Bachelor’s degree in Computer Science, Data Engineering, or a related field.
• Hands-on experience with Palantir.
• Experience with cloud platforms (e.g., AWS, Azure, GCP) and big data technologies (e.g., Apache Spark, Hadoop).
• Familiarity with data orchestration tools such as Apache Airflow, Prefect, or similar.