ON Partners

Lead Snowflake Architect, Developer

ON Partners

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

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