Senior Snowflake Architect – Higher Education

Job not on LinkedIn

🕒 September 9

🇺🇸 United States – Remote

💵 $120k - $188k / year

⏰ Full Time

🟠 Senior

🏛️ Architect

👻 Ghost score 2%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

ON Partners

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2006

💼 Consulting

🏥 Healthcare

📦 Logistics

Consulting • Healthcare • Logistics

ON Partners is a pure-play retained executive search firm that specializes in building C-level and board leadership teams across various sectors. Since its inception in 2006, the company has focused on crafting tailored solutions for executive placements, ensuring a seamless experience for both clients and candidates. With expertise spanning technology, consumer products, professional services, life sciences, and industrial sectors, ON Partners is committed to innovative and diversity-focused recruiting practices.

📋 Description

• 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