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.
#J-18808-Ljbffr
