Data Architect/ Data Modeler

General Dynamics • Amelia Court House, VA

4d • Remote

About The Position

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.

Requirements

• 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

Nice To Haves

• MA/MS degree with 10+ years of general experience in information systems and 8+ years of specialized experience
• Certified Data Management Professional (CDMP)
• Snowflake SnowPro 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 stakeholders and build excellent customer relationship
• Experience identifying and applying industry tools, solutions, methods best practices, and emerging technologies
• Strong analytical skills and problem-solving skills with the ability to formulate and communicate recommendations for improvement
• Demonstrated ability to work effectively, independently, and as part of a team

Responsibilities

• 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

Benefits

• Comprehensive benefits and wellness packages
• 401K with company match
• Competitive pay and paid time off
• Full flex work weeks where possible
• Vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave
• Paid leave and paid holidays are prorated based on the employee's date of hire
• The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees
• Short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees