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? #J-18808-Ljbffr