Senior Snowflake Architect / Developer – Higher Education

attainpartners; Deutschland; Hybrid; EUR 103.000 - 162.000; Vollzeit

Benefits dieser Stelle

Discretionary bonus

Remote or hybrid work

Comprehensive health coverage

401(k) matching

Zusammenfassung

attainpartners is seeking a senior practitioner to lead architecture, design, development, and optimization of cloud data platforms for colleges and universities. You will blend hands-on engineering with solution architecture, translating institutional requirements into scalable Snowflake environments.

You will engage stakeholders, design future-state architectures, develop ETL/ELT pipelines, and mentor teams while ensuring cost-efficient warehouses and secure data sharing.

Qualifikationen

• 8+ years of professional experience in data engineering, data architecture, warehousing, or analytics.
• 4+ years hands-on Snowflake architecture and development.
• Advanced SQL skills with complex queries, views, procedures, and data modeling.
• Experience designing ETL/ELT pipelines integrating enterprise applications and APIs.
• Delivery of data/cloud data platform solutions in higher education or similar environments.
• Strong communication and ability to lead technical workstreams.

Aufgaben

• Lead discovery, requirements, and technical design workshops with higher education clients.
• Assess Snowflake deployments and design future-state architectures across databases, schemas, and security.
• Build, optimize, and troubleshoot Snowflake solutions and pipelines with data-quality controls.
• Diagnose performance, loading, security, and integration issues and tune warehouses for cost efficiency.
• Translate needs into data models and development specs, mentoring client and delivery resources.

Kenntnisse

Snowflake Architecture

Advanced SQL

Data Modeling

Cloud Data Platforms

Stakeholder Communication

Tools

Snowflake

ETL/ELT Tools

APIs

RBAC / Security

Jobbeschreibung

Role overview

A consulting firm focused on mission-driven institutions is hiring a senior practitioner to lead the architecture, design, development, and optimization of cloud data platforms for colleges and universities. The position blends hands-on engineering with solution architecture, partnering with institutional stakeholders to translate academic, operational, and research requirements into scalable Snowflake environments.

Responsibilities

• Lead discovery, requirements, and technical design workshops with higher education clients, engaging executives, business owners, analytics teams, and application stakeholders.
• Assess existing Snowflake deployments and design future-state architectures spanning databases, schemas, virtual warehouses, security models, workload management, and secure data sharing.
• Build, optimize, and troubleshoot Snowflake solutions, including advanced SQL development, ETL/ELT pipelines, integrations with enterprise applications and APIs, and data-quality controls.
• Diagnose and resolve complex performance, query, loading, security, and integration issues while tuning warehouses, resource monitors, and query plans for cost efficiency.
• Translate institutional needs into data models, source-to-target mappings, and development specifications, mentoring client and delivery team resources throughout delivery.

Requirements

• 8+ years of professional experience in data engineering, data architecture, warehousing, or analytics, including 4+ years of hands-on Snowflake architecture and development.
• Deep Snowflake expertise across databases, schemas, virtual warehouses, RBAC, masking, row-level security, secure views, data sharing, and warehouse sizing.
• Advanced SQL skills with complex queries, views, stored procedures, functions, and transformation logic, plus strong dimensional and analytical data modeling ability.
• Demonstrated experience designing ETL/ELT pipelines that integrate enterprise applications, databases, APIs, cloud platforms, and file-based sources.
• Prior delivery of data, analytics, or cloud data platform solutions within higher education or similar institutional environments.
• Strong communication skills and the ability to independently lead technical workstreams while managing competing technical and business priorities.

Nice to have

• SnowPro Core, SnowPro Advanced: Data Engineer, or SnowPro Advanced: Architect certification.
• Familiarity with higher education domains such as student records, admissions and enrollment, advancement, finance, HR, research, or institutional reporting.
• Experience with platforms like Workday, PeopleSoft, Ellucian Banner or Colleague, Salesforce Education Cloud, Slate, or advancement CRMs.

Benefits and work setup

• Salary range of $120,000 to $188,000 USD plus eligibility for an annual discretionary bonus.
• Comprehensive medical, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and an employee assistance program.
• 11 paid federal holidays, flexible unlimited time off, and immediate-vesting 401(k) matching.
• Flexible career tracks and a culture that supports remote or hybrid work; periodic travel based on client needs.