
Lead Snowflake Architect, Developer
ON Partners
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $120,000 - $130,000 per year
Job Level
About the role
- 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).
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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Snowflake architecturedata modelingdata ingestiondata transformationELT patternsSQLperformance tuningdimensional modelingdata vaultreal-time architectures
Soft Skills
leadershipstakeholder managementcommunicationcollaborationproblem-solving