Senior Snowflake Architect / Developer – Higher Education

4 weeks ago
Full-time
Lead
Software Development
Attain Partners

Attain Partners

Attain Partners is an innovative consulting firm based in McLean, Va., empowering clients in education, nonprofits, healthcare, and government sectors with cutting-edge solutions for digital transformation and organizational improvement.

Media
251-1K
Founded 2009

Description

  • Lead client discovery, requirements, architecture, and technical design workshops.
  • Assess current-state Snowflake environments and develop future-state data architectures and models.
  • Design, develop, troubleshoot, and optimize Snowflake-based data solutions.
  • Build scalable databases, schemas, warehouses, security models, workload management, and data-sharing solutions.
  • Develop ETL/ELT pipelines integrating enterprise applications, databases, APIs, cloud platforms, and files.
  • Translate institutional requirements into architectures, data models, source-to-target mappings, and development specifications.
  • Implement data-quality controls, reconciliation, validation, exception handling, and monitoring.
  • Lead technical workstreams and collaborate with client stakeholders and consulting delivery teams.
  • Mentor developers, data engineers, analysts, and client technical resources.
  • Support sales and business-development activities and build trusted client relationships.

Requirements

  • 8+ years of experience in data engineering, architecture, warehousing, analytics, or related technology roles.
  • 4+ years of hands-on Snowflake architecture and development experience.
  • Advanced SQL skills, including complex queries, views, stored procedures, functions, and transformation logic.
  • Experience designing scalable Snowflake environments, data models, security controls, and performance and cost optimization strategies.
  • Experience developing ETL/ELT pipelines and integrating diverse enterprise data sources.
  • Strong troubleshooting skills across Snowflake performance, queries, data loads, security, integrations, and configuration.
  • Experience delivering data, analytics, warehouse, or cloud-platform solutions for higher education institutions.
  • Strong written and verbal communication skills with technical and non-technical audiences.
  • Preferred experience with higher education data domains, Workday, PeopleSoft, Banner, Salesforce Education Cloud, Slate, or similar platforms.
  • Preferred experience with Snowflake capabilities, orchestration tools, BI platforms, cloud ecosystems, data governance, and legacy warehouse modernization.
  • SnowPro Core or Advanced Architect/Data Engineer certifications are relevant certifications.
  • Ability to travel periodically based on business and client needs.

Benefits

  • $120,000–$188,000 USD base salary plus eligibility for an annual discretionary bonus.
  • Health, dental, and vision coverage; HSA/FSA accounts; life and disability insurance; fertility and family-planning benefits; and employee assistance programs.
  • 11 paid federal holidays and flexible unlimited time off.
  • 401(k) matching with immediate vesting.
  • Career paths supporting advancement, mobility, and professional growth.
  • Benefits begin on the first day of employment.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Senior CMDB / ITOM Architect

PHIZENIX 11-50 information technology & services

Senior CMDB/ITOM Architect role focused on leading ServiceNow CSDM, CMDB governance, Discovery, and Service Mapping initiatives while establishing ServiceNow as the trusted source for enterprise application and service data.

2 hours, 28 minutes ago

Director, Data Platforms and Operations

Apryse 251-1K Internet Software & Services

Apryse is seeking a Director of Data Platform & Operations to lead its data engineering, governance, and BI/analytics functions while building the trusted data foundation for business reporting and Glean-powered AI tools.

Apache Spark AWS Azure Databricks NetSuite Power BI Python Salesforce SQL Tableau
1 day, 2 hours ago

Tech Lead Data Engineer

Cloudbeds 251-1K Internet Software & Services

Cloudbeds is seeking a Tech Lead Data Engineer & Data Architect to shape the architecture, governance, reliability, and AI readiness of its fully remote, Snowflake-based analytics platform serving hospitality operations worldwide.

Agile Apache Airflow CI/CD Dagster dbt Git JIRA MLOps Prefect Python Snowflake SQL
1 day, 3 hours ago

Tech Lead Data Engineer

Cloudbeds 251-1K Internet Software & Services

Cloudbeds is seeking a Tech Lead Data Engineer & Data Architect to define the architecture, governance, and engineering practices for its fully remote, Snowflake-based analytics platform supporting hospitality operations worldwide.

Agile Apache Airflow CI/CD Dagster dbt Git JIRA Machine Learning MLOps Prefect Python Snowflake SQL
1 day, 3 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers