Snowflake Lead: Architect and Developer

1 hour, 40 minutes 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

  • 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

Data 360 Architect

Margo Bank Professional Services

Data 360 Architect for a global commerce media company in Warsaw, focused on building AI-driven commerce intelligence and decisioning capabilities across digital commerce.

1 hour, 25 minutes ago

Senior Data Engineer (4 Months Contract ) Remote - Octopus by RTG

Robusta Technology Group 51-250 Professional Services

Senior Data Engineer role focused on designing and delivering enterprise data architecture and scalable data pipelines that support analytics, reporting, and AI/ML initiatives across cloud and on-prem environments.

AWS Azure GCP Java Kafka Looker Power BI Python Scala SQL Tableau
1 hour, 25 minutes ago

Senior Data Engineer

Xometry 251-1K Industrial Conglomerates

Xometry is seeking a Senior Data Engineer for its Marketplace Services team to build and scale core data pipelines, models, and cloud data infrastructure that support business performance across global operations.

AWS CI/CD Dagster dbt GitHub JavaScript Looker Python Snowflake
1 hour, 25 minutes ago

[Job-28697] Engenheiro de Dados Senior (tech lead), Brazil

CI&T 5K-10K Internet Software & Services

CI&T is hiring a Senior Data Engineer Tech Lead in Brazil to lead a strategic cloud migration of on-premise data warehouses to Databricks while turning data into reliable business insights.

Agile Apache Airflow Apache Spark Azure Databricks Power BI Python SQL Tableau
1 hour, 25 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