RemoteLeaf Logo
Log in Sign up

Snowflake Lead: Architect and Developer

3 weeks, 3 days ago
United States
Full-time
Lead
Data Architect
Software Development
Apache Airflow AWS Azure CI/CD dbt GCP Microservices Snowflake SQL
Apply Now
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
View All Jobs 13

Description

  • Define and own the enterprise Snowflake architecture and data platform strategy.
  • Design scalable enterprise, domain, and semantic data models.
  • Lead architecture for data ingestion, transformation, and serving across analytics, AI/ML, and APIs.
  • Establish data governance, security, and access controls, including RBAC, masking, and policies.
  • Architect multi-domain data models across areas such as customer, product, vendor, and finance.
  • Define integration patterns with iPaaS tools such as Boomi, MuleSoft, and Workato.
  • Partner with data governance teams on cataloging, lineage, and data quality.
  • Optimize Snowflake performance, cost, and workload management.
  • Guide teams on CI/CD, DevOps, and automation best practices.
  • Lead stakeholder discussions and translate business needs into architecture designs.
  • Support business development, proposal development, and solution design for new and expanded client work.

Requirements

  • 8+ years of experience in data architecture, data engineering, or analytics platforms.
  • Deep hands-on experience with Snowflake architecture.
  • Strong understanding of data warehousing and lakehouse architectures.
  • Experience with dimensional modeling and data vault.
  • Experience designing ELT pipelines and data ingestion frameworks.
  • Experience with real-time and event-driven architectures.
  • Strong SQL and performance tuning expertise.
  • Experience integrating with cloud platforms such as AWS, Azure, or GCP.
  • Knowledge of security models including RBAC, row-level security, and data masking.
  • Preferred experience with data governance tools such as Informatica, Collibra, or Alation.
  • Preferred experience with iPaaS platforms such as Boomi Platform, MuleSoft, or Workato.
  • Preferred familiarity with AI/ML enablement, including feature stores and model inputs.
  • Preferred experience with dbt, Airflow, or other orchestration tools.
  • Preferred industry experience in Higher Ed, Healthcare, Financial Services, or Non-Profit.
  • Preferred Snowflake SnowPro Advanced Architect certification.

Benefits

  • Salary range of $130,000 to $150,000 USD.
  • Annual discretionary bonus eligibility.
  • Comprehensive health, dental, and vision coverage.
  • HSA and FSA accounts, life and disability insurance, and fertility and family planning benefits.
  • Employee assistance and discount programs.
  • 11 paid federal holidays and flexible unlimited time off (UTO).
  • Generous 401(k) matching with immediate vesting.
  • Benefits begin on the first day of employment.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Bluelight Consulting

Data Engineer, Azure - Remote, Latin America

Bluelight Consulting 11-50 Internet Software & Services

Bluelight is hiring a remote Data Engineer, Azure to build and optimize data pipelines and warehousing solutions for client projects across Latin America.

Latin America Bolivia Full-time Mid Level Data Engineer
Agile Apache Spark Azure Git Machine Learning Power BI Python REST API SQL Tableau
31 minutes ago
Smile Digital Health

Senior DataOps Engineer- Remote US

Smile Digital Health 251-1K IT Services

Smile Digital Health is hiring a Senior DataOps Engineer to own analytics infrastructure and data processing environments for its remote U.S. clinical intelligence product team.

United States Full-time Senior Data Engineer DevOps Engineer
$130k-$160k
Ansible Apache Airflow Apache Spark AWS Azure CI/CD Databricks GCP GitHub Actions GitLab CI Java Jenkins Kubernetes Linux Prefect Python Scala Terraform
46 minutes ago
CookUnity

Staff Data Engineer

CookUnity 251-1K Hotels, Restaurants & Leisure

CookUnity is hiring a Data Engineer to help rebuild and scale the company’s B2C data foundation by designing production-ready pipelines and data systems for a rapidly growing food marketplace.

Canada Full-time Lead Data Engineer
$190k-$210k
Apache Spark Flink Java Kafka Kubernetes Python Scala Snowflake SQL
3 hours, 9 minutes ago
Nebius

Data Engineering Team Lead (Agentic Search)

Nebius 51-250 Internet Software & Services

Nebius is seeking a Data Engineering Team Lead to own the data platform supporting its agent-native search product, spanning ingestion, warehouse architecture, analytics, and trustworthy datasets for product and business decisions.

Israel Full-time Senior Data Architect Data Engineer
Apache Airflow Apache Spark AWS dbt GCP Kafka MapReduce Python Snowflake SQL
4 hours, 13 minutes 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