Data Engineer

JANSON is seeking a Data Engineer (Engineer IV) to support a U.S. Department of Defense (DoD) initiative focused on data pipelines, data warehouses/lakes, integration, validation, metadata, and compliance/security.

Responsibilities

• Extract, transform, and load (ETL) data from sources including DoD Advana and Army Vantage into data warehouses or data lakes
• Clean, normalize, and enrich data during transformation
• Configure automated workflows to move data between systems using Apache Airflow, AWS Glue, or Azure Data Factory
• Optimize pipelines for scalability and reliability
• Implement real-time data processing via streaming pipelines
• Build streaming pipelines using Apache Kafka, Apache Flink, or Spark Streaming
• Process and analyze data in real-time for applications such as fraud detection or IoT analytics
• Design and implement relational databases (e.g., MySQL, PostgreSQL) or NoSQL databases (e.g., MongoDB, Cassandra) based on project requirements
• Ensure efficient schema design and indexing for performance
• Build and maintain data warehouses using Snowflake, Amazon Redshift, or Google BigQuery
• Optimize storage and query performance for analytical workloads
• Support management of data lakes and integration within existing organizational policies
• Interpret policies to support long-term sustainability when integrating products into existing data lakes
• Integrate data from APIs, databases, flat files, and third-party systems
• Handle diverse data formats including JSON, XML, CSV, and Parquet
• Migrate data between systems during upgrades or transitions (e.g., on-premises to cloud)
• Configure APIs to expose data for consumption by other systems or applications
• Manage data quality and governance at the 21st TSC level per USAEUR-AF policies and guidance
• Implement checks to ensure accuracy, completeness, and consistency
• Identify and resolve data anomalies or errors
• Document data lineage, definitions, and transformations for traceability
• Implement and manage compliance and security measures for data systems
• Support regulatory compliance including GDPR, HIPAA, or CCPA
• Apply security controls such as encryption, access control, and auditing
• Partner with internal teams to help rectify or mitigate data quality issues in analyses and tool configuration
• Work with PEOs and PMs of Systems of Record to understand and correct data issues feeding multiple data platforms

Requirements

• 18 years of recent specialized experience
• OR: Major IT Certification plus 14 years of recent specialized experience
• OR: Associate’s degree in computer science, information management, or related discipline plus 14 years of recent specialized experience
• OR: Bachelor’s degree in computer science, information management, or related discipline plus 10 years of recent specialized experience
• OR: Master’s degree in computer science, information management, or related discipline plus 7 years of recent specialized experience
• IA Technical Level II certification or higher
• CCNA-Security
• CompTIA CySA+
• Global Industrial Cyber Security Professional (GICSP)
• GIAC Security Essentials (GSEC)
• CompTIA Security+ CE
• EC-Council Certified Network Defense (CND)
• (ISC)² Certified System Security Practitioner (SSCP)
• Bachelor’s degree (required)
• Recent specialized experience: 10 years (required)
• IAT Level II or higher (required)

Technologies

• Apache Airflow, AWS Glue, Azure Data Factory
• Apache Kafka, Apache Flink, Spark Streaming
• MySQL, PostgreSQL, MongoDB, Cassandra
• Snowflake, Amazon Redshift, Google BigQuery
• APIs, JSON, XML, CSV, Parquet
• GDPR, HIPAA, CCPA
• Encryption, access control, auditing

Location and Work Details

• Work location: Kaiserslautern, Germany
• Clearance: Secret
• Job type: Full-time
• Work location: In person
• Position: Data Engineer (Engineer IV)

Compensation

• USD 135,000 per year

Application Questions

• Do you have a issue living in Kaiserslautern, Germany for 1-2 years.
• What is your salary range?