Senior Data Engineer

General Dynamics IT; United States; On-site; USD 120,000 - 170,000; Full time

Job summary

General Dynamics IT is seeking a Senior Data Engineer to support the Case Management Modernization (CMM) program for the AOUS Courts. The role focuses on building a cloud-based data platform, governance, and scalable data pipelines to enable analytics and AI/ML use cases across 204+ federal courts.

The candidate will design, implement, and maintain data pipelines, data models, and reporting solutions while ensuring security, compliance, and auditable processes in a federal modernization context.

Qualifications

• 7+ years of related experience.
• US Citizenship not required.

Responsibilities

• Design and implement a scalable, secure, cloud-based data platform for data, reporting and analytics.
• Engineer data ingestion and ETL/ELT pipelines for near real-time and batch workloads.
• Collaborate with architects to implement logical and physical data models in cloud platforms (Snowflake, Databricks, Redshift).
• Develop and maintain high-quality, testable code using secure coding standards.
• Support data governance, security controls, and CI/CD practices across data projects.
• Produce and maintain comprehensive documentation and runbooks.

Skills

Data Analysis

Data Analytics

Data Lake

Data Warehousing

ETL Design

Tools

Snowflake

Databricks

AWS Redshift

Job description

Job Information

• Type of Requisition: Pipeline
• Clearance Level Must Currently Possess: None
• Clearance Level Must Be Able to Obtain: None
• Public Trust/Other Required: None
• Job Family: Data Science and Data Engineering

Job Qualifications

• Skills: Data Analysis, Data Analytics, Data Lake, Data Warehousing (DW), ETL Design
• Certifications: None
• Experience: 7 + years of related experience
• US Citizenship Required: No

Job Description

Senior Data Engineer

Seize your opportunity to make a personal impact supporting the Case Management Modernization (CMM) Program. The CMM program is an initiative to support the Administrative Office of the US Courts (AO) in developing a modern cloud-based solution to support all 204+ federal courts across the United States.

GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career. The Senior Data Engineer will work as part of the CMM Data Modernization and Governance team responsible for delivering an integrated data governance, engineering, data platform, reporting, analytics, and Artificial Intelligence (AI)/Machine Learning (ML) capabilities that support operational decision-making and fulfill AO's data and analytics objectives in support of the CMM program.

The successful candidate is responsible for designing, building, testing, and maintaining scalable data engineering components and platform services that power the CMM Program. This role delivers high-quality, secure, and performant data pipelines, transformations, ETL/ELT delivery, data management solutions, and system integrations aligned with federal standards and CMM objectives for modernization, analytics, and operational excellence. The Senior Data Engineer partners closely with the Data Architecture, Data Governance, and Migration teams to ensure engineering work is consistent, auditable, and aligned with CMM's cloud-based CI/CD standards.

The Senior Data Engineer will execute the following responsibilities:

Data Platform & Architecture

• Develop and implement a scalable, secure, cloud-based data platform supporting operational data, reporting, and analytics delivering cloud-based architecture (data lake, lakehouse, or data warehouse).
• Ensure alignment with federal security requirements, judiciary architecture standards, data governance policies, and application modernization initiatives.
• Engineer multi-tenant, cloud-based environments supporting hybrid/on-premises systems, enabling SQL, NoSQL, IaaS, PaaS, distributed SQL, multi-modal, and event-driven/streaming databases.
• Produce and maintain dimensional data models that form the basis for the data marts to satisfy the requirements of the data products.
• Develop and maintain downstream data marts and/or consumable data and their corresponding ETL/ELT processes (on a near real-time basis or overnight batch depending on the individual uses case requirements) and their associated reports and dashboards.
• Develop and maintain comprehensive documentation including the STTMs, data models (logical and physical), design documents, testing documents and other related documents.
• Develop, deploy and maintain the data presentation and data reports for each of the data products using visualization or presentation tool(s) selected by the customer.
• Support development of the Data and Technology Enabler Roadmap across data engineering, reporting/analytics, and AI/ML use cases.

Data Engineering & Integration

• Design and develop data ingestion, ETL/ELT pipelines for integrating data from multiple enterprise sources, and transformation logic for near-real-time and batch workloads.
• Implement robust, reusable data services supporting analytics, reporting, and downstream data marts and/or gold layers.
• Collaborate with architects to implement logical and physical data models in cloud-based platforms (e.g., Snowflake, Databricks, or AWS Redshift).
• Develop and maintain high-quality, testable code using secure coding standards and best practices.
• Support the operationalization CMM Data Classification Standards, including workshops, security controls, metadata requirements, and integration into system design, procurement, and training.
• Configure metadata structures, workflows, automation, and security settings; develop ingestion processes and attribute definitions for catalog entries.
• Create training, job aids, and communications to support user adoption.
• Integrate data pipelines with cloud services, messaging, and storage components.
• Implement data quality checks, validations, and error‑handling mechanisms.
• Optimize pipeline performance, scalability, and cost efficiency.
• Support CI/CD-enabled deployments, including automated testing and promotion across environments.
• Participate in code reviews, design reviews, and sprint ceremonies.
• Support incident resolution and root cause analysis for data pipeline failures.
• Produce and maintain technical documentation, runbooks, and workflows.
• Ensure deliverables meet federal security, governance, and audit requirements.
• Operates within