Data Architect​/Data Modeler

Req : RQ212560

Type of Requisition: Regular

Clearance Level Must Be Able to Obtain: None

Public Trust/Other

Required:

None

Job Family: Data Science and Data Engineering

Database Architecture,Database Modeling,ETL

8 + years of related experience

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 Data Architect/ Data Modeler will work as part of the CMM Enterprise Data Warehouse (EDW) team to deploy a secured cloud-native EDW platform and support the statutory and operational reporting, data cataloging, and other analytical objectives. The Data Architect/ Data Modeler is responsible for defining, implementing, and governing the logical and physical data models that underpin the EDW. This role ensures data structures support secure ingestion, high-quality analytics, performance at scale, and alignment with federal data governance, classification, and compliance requirements defined in the SOW.

• Develop CMM Data Classification Standards for sensitive and high-value data

• Facilitate workshops to define security controls and data handling requirements for sensitive data

• Incorporate classification requirements into case management system design, procurement specifications, and training content

• Develop compliance monitoring methods and resolve operational classification issues

• Align classification outputs with judiciary risk tolerance and operational needs

• Configure metadata structures, workflows, automation, and security settings in the new platform (Qlik/Talend) to support case management metadata requirements

• Integrate classification metadata and labels into catalog structures in line with CMM standards

• Develop ingestion processes for case management metadata, including defining attribute descriptions for catalog entries

• Create and deliver training, job aids, and communications to drive user adoption

• Incorporate classification metadata for case management into the enterprise catalog, monitor system performance and implement optimization updates post-migration

• Design and maintain enterprise logical and physical data models for the EDW and downstream data marts

• Define dimensional, relational, and analytical schemas optimized for reporting and analytics workloads

• Collaborate with business analysts to translate requirements and STTMs into accurate data structures

• Partner with data engineers to ensure model-driven ETL/ELT implementations

• Ensure data models align with data governance standards, classification policies, and security controls

• Implement naming conventions, modeling standards, and version control for all data models

• Support data quality, integrity, and consistency across integrated source systems

• Optimize models for query performance, scalability, and cost efficiency

• Maintain metadata, lineage, and model documentation for inclusion in the metadata catalog

• Participate in architecture and design reviews , providing modeling expertise and recommendations

• Support testing, validation, and reconciliation of data structures and transformations

• Produce and maintain audit-ready documentation for data models and design decisions

• Operates within an Agile federal delivery environment

• Collaborates closely with BI architects, data engineers, and business analysts

• Accountable for data model quality, consistency, and performance

• Expected to maintain continuous audit readiness and documentation accuracy

• BA/BS and 8+ years of experience information systems. or equivalent years of experience

• Experience in data architecture and data modeling roles

• Proven expertise in logical, physical, and dimensional data modeling

• Experience supporting enterprise EDW (Snowflake) and analytics platforms

• Strong SQL skills and deep understanding of relational and analytical databases

• Experience working in regulated or compliance-driven environments

• Ability to produce clear, structured, and audit-ready data documentation

• Experience supporting federal EDW or judiciary data programs

• Hands-on experience with Snowflake data modeling

• Familiarity with data governance, metadata management, and lineage tools

• Experience working with cloud-based data platforms (AWS preferred)

• Experience mentoring junior data modelers or engineers

• MA/MS degree with 10+ years of general experience in information systems and 8+ years of specialized experience

• Certified Data Management Professional (CDMP)

• Snowflake Snow Pro Advanced

• AWS Certified Data Analytics – Specialty

• Excellent presentation and communication (oral and written) skills

• Consultant mindset with the ability to work with high level customer…