Snowflake Data Warehouse Architect Lead

Snowflake Data Warehouse Architect Lead

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

HOW A CLOUD DATA WAREHOUSE ARCHITECT WILL MAKE AN 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, 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

WHAT YOU’LL NEED TO SUCCEED:

Required Education: BS/MS degree with 10+ years of general experience in information systems and 8+ years of specialized data warehouse related experience

Required 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

Required Technical Skills:

• 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)

Required Skills and Abilities:

• Excellent communication skills with demonstrated experience delivering presentations to diverse audiences at various levels of an organization
• Experience managing, mentoring, and developing engineering staff

Preferred Skills and Experience:

• Strong proficiency with SQL and data transformation techniques
• Familiarity with Agile / Scrum delivery environments

Preferred Certification:

• Snowflake SnowPro Advanced: Architect
• Certified Data Management Professional (CDMP)
• AWS Certified Data Analytics – Specialty

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

Location: Remote

What GDIT can offer you:

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

#GDITFedHealthJobs