Lead Snowflake Data Warehouse Architect

General Dynamics Information Technology

Snowflake Data Warehouse Architect Lead at GDIT guiding the enterprise cloud data environment architecture and leading technical strategy for complex data ecosystems.

Posted 4/21/2026full-timeRemote • 🇺🇸 United StatesSenior💰 $170,000 - $230,000 per yearWebsite

Tech Stack

Tools & technologies

AWSCloudETLPySparkPythonSQL

About the role

Key responsibilities & impact

Own the opportunity as a Snowflake Data Warehouse Architect and help ensure the mission is never interrupted.
Guide the design, architecture, and technical strategy for our enterprise cloud data environment.
Shape the architecture supporting complex data ecosystems.
Provide leadership across engineering workstreams.
Ensure the platform evolves in a scalable, secure, and high‑performing direction.
Architect enterprise‑level Snowflake data warehouse solutions.
Provide technical leadership across multiple teams.
Define data architecture patterns, standards, and best practices.
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.
Oversee ingestion, transformation, and integration of complex healthcare datasets.
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.

Requirements

What you’ll need

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
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.

Benefits

Comp & perks

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.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Snowflakedata warehousingcloud data architectureETLELTSQLdata transformation designperformance optimizationautomationscripting

Soft Skills

leadershipcommunicationmentoringcollaborationpresentation skills