Snowflake Data Warehouse Architect Lead

Snowflake Data Warehouse Architect Lead

Req : RQ218639

Type of Requisition: Regular

Clearance Level Must Be Able to Obtain: None

Public Trust/Other

Required:

None

Job Family: Data Science and Data Engineering

Skills:

Cloud Data Architecture,Data Warehousing (DW),Enterprise Data,ETL Development,Modern Data Integration

Experience:

10 + years of related experience

Job Description:

Own the opportunity as a Snowflake Data Warehouse Architect and help ensure the mission is never interrupted. 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 work streams, 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.

As the Snowflake Data Warehouse Architect Lead , you will:

• 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, Dev Sec Ops , 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

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…