This job has closed.

General Dynamics Information Technology · 1 day ago

Data Architect/ Data Modeler

United States

Full-time

Remote

Senior Level, Lead/Staff

$147K/yr - $199K/yr

8+ years exp

General Dynamics Information Technology is a global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government. The Data Architect/ Data Modeler will work as part of the CMM Enterprise Data Warehouse team to deploy a secured cloud-native EDW platform and support various analytical objectives, ensuring data structures support secure ingestion and high-quality analytics.

Artificial Intelligence (AI)Cloud ComputingConsultingCyber SecurityInformation Technology

H1B Sponsor Likely

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

Qualification

Database ArchitectureDatabase ModelingETLSQLSnowflakeData GovernanceAnalytical SkillsCommunication SkillsProblem-Solving Skills

Required

BA/BS and 8+ years of experience 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

Preferred

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

Benefits

Medical plan options, some with Health Savings Accounts

Dental plan options

Vision plan

401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match

Full flex work weeks

Variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave

15 days of paid leave per calendar year

10 paid holidays per year

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

Company

General Dynamics Information Technology

Glassdoor3.9

General Dynamics Information Technology is an IT consulting company that specializes in cyber security, AI, and quantum computing. It is a sub-organization of General Dynamics.

Founded in 1999

Falls Church, Virginia, USA

10001+ employees

https://www.gdit.com/

H1B Sponsorship

General Dynamics Information Technology has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (32)

2024 (27)

2023 (36)

2022 (19)

2021 (18)

2020 (13)