Senior Snowflake Architect – Higher Education

Posted 1hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Senior Snowflake Architect/Developer building and optimizing Snowflake data solutions for higher education clients. Leading architecture, workshops, troubleshooting, and hands-on implementation at Attain Partners.

Responsibilities:

  • Lead the architecture, design, development, and optimization of Snowflake-based data solutions for higher education clients
  • Lead client discovery and design workshops
  • Assess current-state Snowflake environments
  • Troubleshoot complex technical issues
  • Develop future-state data models and architectures
  • Directly build and optimize Snowflake solutions
  • Engage with executive stakeholders, business users, data and analytics teams, application owners, and technical resources
  • Translate institutional requirements into scalable technical solutions
  • Remain hands-on throughout implementation

Requirements:

  • Strong hands-on experience designing, developing, and supporting Snowflake solutions
  • Ability to serve as both a Snowflake Architect and Snowflake Developer
  • Experience designing scalable Snowflake environments, including databases, schemas, virtual warehouses, security models, workload management, and data-sharing patterns
  • Advanced SQL development skills, including complex queries, views, stored procedures, functions, and data transformation logic
  • Strong experience designing logical, physical, dimensional, and analytical data models
  • Ability to design future-state enterprise data models and architectures
  • Experience developing ETL/ELT pipelines and integrating data from enterprise applications, databases, APIs, cloud platforms, and file-based sources
  • Strong troubleshooting skills for Snowflake performance, query, data-load, security, integration, and configuration issues
  • Experience with Snowflake performance and cost optimization
  • Understanding of Snowflake security capabilities including RBAC, masking policies, row-level security, secure views, and data sharing
  • Experience implementing data-quality controls, reconciliation processes, validation routines, exception handling, and monitoring
  • Demonstrated experience leading client-facing discovery, requirements, architecture, and technical design workshops
  • Ability to translate business requirements into technical architectures, data models, source-to-target mappings, and development specifications
  • Strong written and verbal communication skills with technical and non-technical audiences
  • Prior experience delivering data, analytics, data warehouse, or cloud data platform solutions within higher education
  • Ability to independently lead technical workstreams and collaborate with client and consulting delivery teams
  • 8+ years of professional experience in data engineering, data architecture, data warehousing, analytics, or related data technology roles
  • 4+ years of hands-on Snowflake architecture and development experience
  • Certifications listed: SnowPro Advanced: Architect, SnowPro Advanced: Data Engineer, SnowPro Core
  • Demonstrated ability to build trusted advisor relationships with clients
  • Experience supporting sales and business development
  • Flexibility to travel periodically based on business and client needs

Benefits:

  • Competitive health, dental, and vision coverage
  • HSA and FSA accounts
  • Life and disability insurance
  • Fertility and family planning benefits
  • Employee assistance and discount programs
  • 11 paid federal holidays
  • Flexible unlimited time off (UTO)
  • Generous 401(k) matching with immediate vesting
  • Flexible career paths with advancement, mobility, and flexibility
  • Flexible work environment
  • Industry-leading benefits packages
  • Career growth opportunities