HHiring Reality
← Attain Partners

Senior Snowflake Architect / Developer – Higher Education

Attain Partners
Location
United States - Remote
Posted
11 days ago
Department
Attain Partners
What they actually want (must-haves)
  • Strong hands-on experience designing, developing, and supporting solutions within Snowflake.
  • Ability to serve as both a Snowflake Architect and Snowflake Developer within the same engagement.
  • 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 based on evolving institutional requirements.
Nice to have
  • Experience working with higher education data domains such as student and academic data, admissions and enrollment, advancement and fundraising, finance, human resources, research, institutional reporting and analytics.
  • Experience with higher education platforms such as Workday, PeopleSoft, Ellucian Banner, Colleague, Salesforce Education Cloud, Slate, Advancement CRM platforms, or similar enterprise applications.
  • Experience modernizing legacy enterprise data warehouses into cloud-based Snowflake architectures.
  • Experience with Snowflake capabilities such as Snowpark, Snowpipe, Streams and Tasks, Dynamic Tables, Secure Data Sharing, Snowflake Marketplace, Cortex or other Snowflake AI capabilities.
  • Experience with orchestration and integration technologies such as Boomi, MuleSoft, Informatica, Azure Data Factory, dbt, Fivetran, Matillion, or similar platforms.
What the job really is

The Senior Snowflake Architect / Developer at Attain Partners will lead the design, development, and optimization of Snowflake-based data solutions specifically for higher education clients. This role combines responsibilities of both a solution architect and a hands-on developer, requiring engagement with various stakeholders to translate institutional needs into scalable technical solutions while also troubleshooting and optimizing existing systems.

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.
Things to weigh
  • Position requires flexibility to travel periodically based on business and client needs.
  • No specific mention of remote work policies beyond the position being remote.
  • The salary range is broad, indicating potential variability based on candidate experience and negotiation.
  • The role requires engagement with executive stakeholders, which may involve high-pressure situations.
Job score3.4/5
Benefits3/5
Freshness5/5
Career value4/5
Role clarity5/5
Pay transparency0/5

Applying to Attain Partners?

See how your résumé matches this role — and tailor it from what actually gets interviews.