Job details

Snowflake Lead: Architect and Developer

Attain Partners is a mission-driven consulting firm working across education, nonprofit, healthcare, and government to deliver strategy and technology solutions. They are seeking a Snowflake Architect to define and lead enterprise Snowflake data platform architecture, ensure scalability and governance, and enable AI-ready data ecosystems across ingestion, transformation, and serving layers.

Skills

8+ years in data architecture, data engineering, or analytics platforms
Deep, hands-on Snowflake architecture experience
Strong SQL and performance tuning expertise
Experienced designing ELT pipelines, real-time/event-driven architectures
Understanding of data warehousing, lakehouse patterns, dimensional modeling, and Data Vault
Experience integrating with cloud platforms (AWS, Azure, GCP)
Knowledge of security models including RBAC, row-level security, and data masking

Responsibilities

Define and own enterprise Snowflake architecture and overall data platform strategy
Design scalable enterprise, domain, and semantic data models
Architect data ingestion (batch, real-time, streaming) and ELT transformation patterns
Design data serving layers for analytics, AI/ML, and APIs
Establish and enforce data governance, security, RBAC, masking, and access controls
Define integration patterns with iPaaS tools and cloud platforms
Optimize Snowflake performance, cost, and workload management
Advise on CI/CD, DevOps, and automation best practices
Lead stakeholder discussions and translate business needs into technical designs
Support business development, proposal creation, and solution design activities

Education

Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent experience
Advanced degree in a related field preferred but not required

Benefits

Comprehensive health, dental, and vision coverage; HSA/FSA options
Life and disability insurance, fertility and family planning benefits, employee assistance program
11 paid federal holidays and flexible unlimited time off (UTO)
Generous 401(k) matching with immediate vesting
Flexible career tracks, professional growth and mobility
Inclusive culture with focus on wellbeing
Eligible for annual discretionary bonus

To read the complete job description, please click on the ‘Apply’ button

Snowflake Data Architect Data Engineer ELT Dimensional Modeling Data Vault Data Lake Lakehouse SQL dbt Airflow AWS Azure GCP Data Governance RBAC iPaaS Boomi MuleSoft Workato

Average salary estimate

$125000 / YEARLY (est.)

min

max

$120000K

$130000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

Similar Jobs

Analytics Engineer

Loop Hybrid Remote

VIEW

Posted 18 hours ago

Help transform Loop’s large return and exchange dataset into production-quality dbt models and reliable data products that drive merchant insights and outcomes.

Senior Analytics Engineer II - R01564337

Brillio Hybrid Austin, Texas, United States

VIEW

Posted 23 hours ago

Senior Analytics Engineer role to build scalable analytics layers and deliver actionable BI and self-service reporting for Brillio's enterprise clients.

Associate Director, International Market Analytics and Business Intelligence, Parkinson's

AbbVie Hybrid Mettawa, IL

VIEW

Posted 14 hours ago

AbbVie is hiring an Associate Director to lead international market analytics and business intelligence for the Parkinson's franchise, driving data-driven insights to shape global and affiliate strategy.

A Attain Partners

3 jobs

MATCH

Calculating your matching score...

FUNDING

Private

DEPARTMENTS

Data

SENIORITY LEVEL REQUIREMENT

Senior Level

TEAM SIZE

No info