RemoteLeaf Logo
Log in Sign up

Snowflake Lead: Architect and Developer

1 month, 2 weeks 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 14

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) in Latin America to design, develop, and maintain ETL and data integration workflows that support accurate analytical data for client projects.

Latin America Uruguay Full-time Mid Level Data Engineer
Agile Apache Spark Azure Git Machine Learning Power BI Python REST API SQL SQL Server Tableau
16 minutes ago
Bluelight Consulting

Data Engineer (Azure) - Remote, Latin America

Bluelight Consulting 11-50 Internet Software & Services

Bluelight is hiring a remote Data Engineer (Azure) to design, develop, and maintain ETL data pipelines that support analytics and decision-making for client projects in Latin America.

Latin America Honduras Full-time Mid Level Data Engineer
Agile Apache Spark Azure Git Machine Learning Power BI Python REST API SQL Tableau
20 minutes ago
qode

Senior Data Engineer

qode Internet Software & Services

Senior Data Engineer role focused on building and optimizing data engineering and analytics pipelines using Informatica and PySpark in a client-facing, cross-functional environment.

United States Full-time Senior Data Engineer
Agile Apache Spark AWS Hadoop HDFS Hive JIRA Kafka Machine Learning MapReduce Python
56 minutes ago
Addepar

Data Solutions Consultant

Addepar 251-1K Capital Markets

Addepar is hiring a Data Solutions Consultant to integrate clients’ portfolio data into its platform and help solve complex data challenges for investment professionals.

United States Full-time Junior Data Engineer Implementation Consultant
$93k-$116k
Python
1 hour, 8 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