Snowflake Lead Architect and Developer

Attain Partners is an innovative consulting firm dedicated to disrupting the status quo to change the world and improve the lives of those we touch. From strategy to technology and ever y where in between, our experts use their unique skills to advance the important missions of education, nonprofit, healthcare, and state and local government clients.

People are at the center of all we do, and that’s why we empower career growth, provide industry-leading benefits packages, encourage a flexible work environment, and foster a culture of inclusion to support the needs of our team. We share a collective passion for our mission and our people. Guided by our seven core values, The Attain Way, our vision is the foundation of our culture—to be and attain the best.

Job Description

We are seeking a Snowflake Architect to lead the design and implementation of enterprise data platforms built on Snowflake. This role is responsible for defining the overall data architecture, ensuring scalability, performance, governance, and enabling AI-ready data ecosystems. The ideal candidate will bring deep expertise in modern data architectures, including data lakes, warehouses, and lakehouse patterns, and will work closely with integration, governance, and analytics teams to deliver a unified data platform.

Job Responsibilities

• Define and own the enterprise Snowflake architecture and data platform strategy
• Design scalable data models (enterprise, domain, and semantic layers)
• Data ingestion (batch, real-time, streaming)
• Data transformation (ELT patterns)
• Data serving (analytics, AI/ML, APIs) Establish data governance, security, and access controls (RBAC, masking, policies)
• Architect multi-domain data models (Customer, Product, Vendor, Finance, etc.)
• Define integration patterns with iPaaS tools (Boomi, MuleSoft, Workato)
• Partner with Data Governance teams to align on cataloging, lineage, and data quality
• Optimize performance, cost, and workload management within Snowflake
• Guide teams on best practices for CI/CD, DevOps, and automation
• Lead stakeholder discussions and translate business needs into architecture designs
• Lead and/or support business development efforts
• Lead and/or support proposal development and solution design in support of new and expanded client work

Required Skills

• 8+ years in data architecture, data engineering, or analytics platforms
• Deep hands-on experience with Snowflake architecture
• Data warehousing and lakehouse architectures
• Dimensional modeling and data vault
• ELT pipelines and data ingestion frameworks
• Real-time and event-driven architectures
• Strong SQL and performance tuning expertise
• Experience integrating with cloud platforms (AWS, Azure, GCP)
• Knowledge of security models (RBAC, row-level security, data masking)

Desi