ON PartnersRemote
Lead Snowflake Architect, Developer
United States
Full Time
2 hours ago
$120,000 - $130,000 USD
No Visa Sponsorship
Key skills
AWSAzureCloudGoogle Cloud PlatformSQLVaultAIMLELTData EngineeringData WarehousingAnalyticsSnowflakeGCPGoogle CloudCI/CD
About this role
Role Overview
- 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.