Attain Partners · 1 month ago
Snowflake Lead: Architect and Developer
United States
Full-time
Remote
Lead/Staff
$130K/yr - $150K/yr
8+ years expAttain Partners is an innovative consulting firm dedicated to disrupting the status quo to change the world and improve the lives of those we touch. We are seeking a Snowflake Architect to lead the design and implementation of enterprise data platforms built on Snowflake, ensuring scalability, performance, and governance while enabling AI-ready data ecosystems.
ConsultingInformation TechnologyInformation Services
Responsibilities
Define and own the enterprise Snowflake architecture and data platform strategy
Design scalable data models (enterprise, domain, and semantic layers)
Lead architecture for: 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
Qualification
Required
8+ years in data architecture, data engineering, or analytics platforms
Deep hands-on experience with Snowflake architecture
Strong understanding of: Data warehousing and lakehouse architectures, Dimensional modeling and data vault
Experience designing: 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)
Preferred
Experience with: Data governance tools (Informatica, Collibra, Alation), iPaaS platforms (Boomi Platform, MuleSoft, Workato)
Familiarity with AI/ML enablement (feature stores, model inputs)
Experience with dbt, Airflow, or orchestration tools
Industry experience in Higher Ed, Healthcare, Financial Services, or Non-Profit
Snowflake SnowPro Advanced (Architect) Certification
Benefits
Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
11 paid federal holidays and flexible unlimited time off (UTO)
Generous 401(k) matching with immediate vesting
Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
Company
Attain Partners
Based in McLean, Va., Attain Partners is a leading management and technology consulting firm delivering services and solutions to advance client missions across the education, nonprofit, healthcare, and state and local government landscapes.
201-500 employees
H1B Sponsorship
Attain Partners has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
100%
Represents job field similar to this job
Engineering and Development
Trends of Total Sponsorships
*2024 (1)
Funding
Current Stage
Growth StageTotal Funding
$0.25M2015-03-15Seed· $0.25M
Leadership Team
Greg J. Baroni
Chairman and Chief Executive Officer
Phil Agee
President and Chief Operating Officer
Recent News
MarTech Series
2025-05-07
Company data provided by crunchbase