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
Requirements
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).
Tech Stack
AWS
Azure
Cloud
Google Cloud Platform
SQL
Vault
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
A healthy environment where we value unique experiences, and care about everything that makes you, you.
Lead Snowflake Architect, Developer at ON Partners | JobVerse