Data Engineer

Fantom Corporation is a mission-focused organization supporting critical programs across the defense and intelligence community. We partner with our customers to deliver high-impact technical solutions while fostering a culture built on trust, expertise, and long-term career growth.

We are seeking a Data Engineer to support the development and optimization of enterprise data pipelines and ETL workflows. This role is responsible for extracting, transforming, and loading structured and unstructured data from a variety of sources into centralized data platforms. The ideal candidate has strong experience with Python, SQL, and Palantir or similar ETL platforms, along with a passion for building scalable, high-quality data solutions.

This position offers the opportunity to work on mission-critical data initiatives, collaborating with technical and business stakeholders to deliver reliable, high-performance data products that drive operational and analytical decision-making.

• Design, develop, and maintain scalable ETL pipelines using Python, SQL, and Palantir or similar data integration platforms
• Extract, transform, and load structured and unstructured data from databases, APIs, flat files, and other enterprise data sources
• Develop robust Python scripts and SQL queries to automate data ingestion, transformation, and processing workflows
• Design and implement data models that support analytics, reporting, and operational requirements
• Optimize data structures, queries, and pipelines for performance, scalability, and reliability
• Perform data cleansing, validation, and quality assurance to ensure data accuracy and consistency
• Develop data enrichment and transformation workflows to improve data usability
• Monitor ETL processes and implement automated quality checks and error handling
• Collaborate with engineers, analysts, and business stakeholders to gather requirements and deliver data solutions
• Provide technical guidance and best practices for data engineering tools and platforms, including Palantir
• Document data pipelines, workflows, and technical processes to support ongoing operations and maintenance

• Must be fully cleared with a recent polygraph
• Must be willing and able to work fully onsite at the location listed in this posting
• 3 years of experience in Data Engineering or a related technical field
• Strong programming experience with Python
• Advanced SQL skills, including query development, optimization, and data transformation
• Experience with ETL development and data integration platforms such as Palantir or similar technologies
• Experience integrating data from APIs, relational databases, flat files, and other enterprise data sources
• Strong understanding of structured and unstructured data processing
• Experience implementing data quality, validation, and monitoring processes
• Excellent analytical, troubleshooting, and problem-solving skills
• Strong communication and collaboration skills with both technical and non-technical teams
• #CJ

• Bachelor's degree in Computer Science, Data Engineering, or a related technical discipline
• Hands-on experience with Palantir Foundry or other Palantir platforms
• Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP)
• Experience with big data technologies such as Apache Spark or Hadoop
• Experience with workflow orchestration tools such as Apache Airflow, Prefect, or similar platforms
• Experience building scalable enterprise data pipelines and analytics platforms
• Familiarity with modern data engineering best practices and cloud-native architectures

Fantom Corp is a Software Development, Agile Cloud, Software Development, Cyber Security (Risk Management, Assessments & Authorization (A&A)), Data, AI Platform (Computer Vision Models), Podcasting Media Services, and IT Services provider. Established in 2015, Fantom Corp serves Federal customers with top-notch Cybersecurity Architects, Data Scientists/Analysts, Software Engineers/Developers, DevSecOps Engineers, Project Managers, Identity, Credential Access Management (ICAM) services , and Cloud-certified practitioners. We excel in delivering emerging technologies such as Artificial Intelligence (AI) and Machine Learning (ML) with a focus on identifying trends, object detection, and classification of structured and unstructured data. Fantom Corp possesses mastery in all aspects of digital audio production. We lead in the ideation and creation of efforts for clients who want to harness the power of podcasting. We guide them in selecting the right show format for their needs and goals. As a Small Business, we possess the innovation, speed and flexibility to meet your requirements.