Senior Data Engineer

Overview

The Data Engineer supports mission-critical data engineering and analytics operations within a classified federal environment, focusing on maintaining and enhancing an Enterprise Data Warehouse (EDW) built on Data Vault 2.0 principles. This position ensures the secure ingestion, transformation, and presentation of corporate data containing Personally Identifiable Information (PII) within a TS/SCI network enclave. The engineer will develop and maintain automated data pipelines from enterprise business systems, implement best practices for secure data handling, and ensure compliance with all applicable DoD and IC data protection policies.

The role requires strong technical skills in data integration, automation, and AWS-based data services, combined with deep experience supporting federal systems.

• Provide adaptive maintenance and development support for the organization’s Enterprise Data Warehouse in a classified TS/SCI environment with PII overlays
• Design, implement, and optimize ETL/ELT processes using SQL Server Integration Services (SSIS), T-SQL, and Python to automate data ingest and transformation from multiple corporate systems
• Develop and sustain automated data pipelines from enterprise applications including People Soft, Momentum, Prism, and Service Plus, ensuring end-to-end data integrity and retention within the classified data warehouse
• Implement AWS-native tools (e.g., Lambda, Glue) to enhance automation and scalability of data ingestion and transformation processes
• Leverage Power Shell scripting and Visual Studio for automation, environment configuration, and integration workflows
• Utilize SharePoint and Nintex workflows to design secure, user-friendly interfaces for presentation of backend SQL database outputs to government and contractor stakeholders
• Support data governance, compliance, and security audits in coordination with information assurance and system security officers (ISSOs) to maintain alignment with DoD and IC directives
• Develop and maintain technical documentation, including Standard Operating Procedures (SOPs), system design documentation, and data lineage tracking
• Provide technical expertise during requirements analysis, solution design, and integration testing phases of ongoing modernization efforts

• Minimum of 4 years of experience performing adaptive maintenance and development of an Enterprise Data Warehouse (EDW) in a TS/SCI environment with PII data
• At least 4 years of experience with the following tools and technologies:
  • Development Tools: SQL Server Integration Services (SSIS), Visual Studio
  • Programming
    
    Languages:
    
    Python, Power Shell, T-SQL
• Demonstrated experience integrating and automating data ingests from People Soft, Momentum, Prism, and Service Plus into a data warehouse
• Hands-on experience developing automated data pipelines using AWS services (e.g., Lambda, Glue) in support of secure data ingestion and retention
• Experience with SharePoint and Nintex workflows for front-end presentation of SQL-based datasets
• Bachelor’s Degree in Computer Science, Information Technology, or related field
• In lieu of degree: an additional 8 years of relevant experience

• Data Vault 2.0 Certified Practitioner (DV 2.0 Certification)
• Master’s Degree in Computer Science, Information Technology, or a related discipline
• Experience working on DoD or Intelligence Community (IC) data warehouse programs
• Familiarity with DoD Cloud Computing Security Requirements Guide (SRG) and NIST 800-53 controls

• Strong understanding of data warehousing principles, data modeling, and ETL automation
• Demonstrated expertise with data security, PII protection, and classified system compliance
• Excellent problem-solving, debugging, and performance optimization skills
• Proven ability to operate effectively in cross-functional government–contractor teams
• Clear and concise technical communication and documentation skills

This role directly contributes to the federal agency’s mission assurance by ensuring the secure, reliable, and automated integration of enterprise data sources within a classified environment. The Data Engineer…