Snowflake Data Warehouse Architect Lead

General Dynamics Information Technology

1d•Remote

About The Position

At GDIT, we deliver clarity with our cloud solutions and provide meaningful work. Your work will be an important part of transforming our clients for the modern age and help them face any obstacle. We are seeking a highly skilled Snowflake Data Warehouse Architect Lead to guide the design, architecture, and technical strategy for our enterprise cloud data environment. This is a senior-level, customer-facing, high-visibility role central to our modernization efforts. You will shape the architecture supporting complex data ecosystems, provide leadership across engineering workstreams, and ensure the platform evolves in a scalable, secure, and high-performing direction. If you excel at solving complex architectural challenges, driving consistency across teams, and influencing data strategy at scale, this role offers the opportunity to make a significant impact.

Requirements

BS/MS degree with 10+ years of general experience in information systems and 8+ years of specialized data warehouse related experience
6+ years of experience in cloud data architecture, data warehousing, or enterprise data modeling
6 + years Snowflake experience required
2+ years direct CMS experience required
Extensive hands-on Snowflake experience, with strong skills in implementing logical and physical models, and leveraging Snowflake tools, including Cortex AI
Proven leadership in large-scale cloud data environments, preferably within AWS
Deep experience with ETL/ELT frameworks and model-driven engineering approaches
Proficiency in SQL, data transformation design, and performance optimization
Experience working with cloud-native architectures, modern data integration patterns and AI solution development
Strong expertise in automation and scripting (e.g., Bash, PowerShell, Python, PySpark)
Excellent communication skills with demonstrated experience delivering presentations to diverse audiences at various levels of an organization
Experience managing, mentoring, and developing engineering staff
Ability to pass CMS background check and meet the residency requirement for having resided in the US at least (3) three out of the last (5) five years in order to obtain a Public Trust

Nice To Haves

Strong proficiency with SQL and data transformation techniques
Familiarity with Agile / Scrum delivery environments
Snowflake SnowPro Advanced: Architect Certified
Data Management Professional (CDMP)
AWS Certified Data Analytics – Specialty

Responsibilities

Architect enterprise-level Snowflake data warehouse solutions, including conceptual, logical, and physical models that support analytics, operational reporting, modernization and AI initiatives
Provide technical leadership across multiple teams, ensuring architectural alignment and model-driven engineering throughout ETL/ELT pipelines
Define data architecture patterns, standards, and best practices to ensure consistency, scalability, and performance across the platform
Lead design decisions related to schema architecture, data distribution, performance optimization, security, governance, and cost management in Snowflake
Collaborate with Program Management, Agile PMO, ETL development, DevSecOps, DBA, user support, and analytics teams to guide solution design and ensure alignment with enterprise and customer goals
Oversee ingestion, transformation, and integration of complex healthcare datasets, ensuring data quality and metadata completeness
Work hands-on in Snowflake, including DDL design, warehouse configuration, performance tuning, and workload optimization
Leverage and advise on usage of related AWS data services (e.g., Lambda, S3, Glue, Step Functions, IAM) to support end-to-end data pipelines
Guide automation approaches for data integration, testing, metadata capture, lineage, and platform operations
Assess and troubleshoot high-complexity issues, providing direction and technical resolutions across teams
Support roadmap planning by providing architectural insight, identifying technical risks, and shaping long-term data strategy
Mentor and develop data engineers, administrators and modelers, setting the technical tone and raising capability across the program
May serve as a technical lead and/or manager over multiple cloud data engineers / teams

Benefits

Full-flex work week
401K with company match
Customizable health benefits packages
Collaborative teams of highly motivated critical thinkers and innovators
Internal mobility team dedicated to helping you own your career
Rewards program for high-performing employees
A variety of medical plan options, some with Health Savings Accounts
Dental plan options
A vision plan
A 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 where possible
A 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 (for new employees, prorated based on the employee’s date of hire)
10 paid holidays per year (prorated based on the employee’s date of hire)
Paid Family Leave program (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