Senior Snowflake Architect – Higher Education
Posted 1hrs ago
Employment Information
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



















