RemoteLeaf Logo
Log in Sign up

Solution Architect / Sr. Solution Architect - Snowflake

1 month ago
United States
Full-time
Senior
Solutions Architect
Software Development
Agile AWS Azure Databricks dbt Kafka Machine Learning Pandas Python Scikit-learn Snowflake SQL
Apply Now
Alpha FMC

Alpha FMC

Alpha FMC is a prominent global consultancy that offers specialized consulting, benchmarking, and implementation services tailored to the asset management, wealth management, and insurance sectors within the financial services industry.

Professional Services
251-1K
Founded 2003
View All Jobs 21

Description

  • Design, build, and optimize enterprise-scale Snowflake environments, including database architecture, schema design, data modeling, and performance tuning.
  • Serve as the Snowflake subject matter expert for internal teams and clients, defining standards, best practices, and governance frameworks.
  • Lead the design and delivery of end-to-end data pipelines into and out of Snowflake, including ingestion, transformation, and consumption layers.
  • Architect Snowflake data sharing, data marketplace, and cross-cloud or cross-region replication strategies.
  • Define and enforce Snowflake security architecture, including RBAC, data masking, row-level security, and network policies.
  • Lead Snowflake performance optimization efforts, including clustering keys, materialized views, query profiling, warehouse sizing, and cost governance.
  • Translate business and technical requirements into Snowflake-first solution designs, including work packages, resourcing, and delivery approach.
  • Define technical approaches for Snowflake implementations, including data migration strategies, SDLC standards, and integration patterns.
  • Lead and mentor a team of data engineers through technical direction and code/design review.
  • Present solution designs, architecture options, and delivery recommendations to business and technology stakeholders.
  • Contribute to internal Snowflake intellectual property, accelerators, and proposition development.
  • Collaborate with internal and client stakeholders across peers, architects, analysts, project managers, and technology teams.

Requirements

  • Bachelor's degree in a related field.
  • At least 5 years of data engineering experience.
  • Minimum 3 years of hands-on Snowflake implementation experience.
  • SnowPro Core certification at minimum.
  • SnowPro Advanced: Data Engineer or Architect certification strongly preferred.
  • Familiarity with Snowflake features including Virtual Warehouses, Snowpipe, Streams & Tasks, Dynamic Tables, Data Sharing, Marketplace, Time Travel, Fail-safe, Zero-Copy Cloning, and Snowflake Cortex.
  • Proven experience designing and implementing Snowflake security models, including RBAC, data masking, row-level security, and network policy configuration.
  • Strong Snowflake performance tuning experience, including query optimization, clustering strategy, materialized views, warehouse rightsizing, and credit cost management.
  • Experience integrating Snowflake with orchestration and transformation tools, especially dbt, which is strongly preferred.
  • Experience with Snowflake-compatible ingestion and pipeline tools such as Snowpipe, Kafka connectors, Fivetran, or Airbyte.
  • Advanced SQL proficiency and Python experience for data engineering workflows, with Snowpark preferred.
  • Experience with cloud platforms, preferably Azure or AWS.
  • Experience managing delivery using Agile or similar methodologies.
  • Ability to lead cross-functional teams and manage senior stakeholder expectations.
  • Previous experience at a global consulting firm is preferred.
  • Experience with Snowflake AI/ML capabilities such as Cortex, ML Functions, or Document AI is a plus.
  • Familiarity with Snowflake Native Apps and Streamlit-in-Snowflake is a plus.
  • Exposure to modern data stack tools such as Databricks, Azure Data Factory, or AWS Glue is a plus.
  • Experience with governance platforms that integrate with Snowflake, such as Alation, Collibra, or Atlan, is a plus.
  • Python-based ML/AI experience with tools such as scikit-learn or pandas is a plus.

Benefits

  • Base salary range of $124,000 to $160,000.
  • 25 days of annual paid time off, plus paid holidays.
  • 5 days of paid training time for continuing education or professional certifications.
  • Reimbursement for commuting, mobile phone, and home internet expenses.
  • Supplemented medical, dental, and vision coverage.
  • 401(k) matching.
  • Eligible for additional variable and non-variable benefits.
  • Inclusive workplace commitment with accessible recruitment and work practices.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Nice Côte d'Azur

Senior Solutions Architect

Nice Côte d'Azur Hotels, Restaurants & Leisure

NiCE is hiring a Solutions Architect to support CXone enterprise customers on custom deployment projects from pre-sales through onboarding, with the goal of translating customer needs into effective cloud-based solution designs.

Canada Senior Solutions Architect
NLP
1 hour, 59 minutes ago
RemoteWoman

Senior Solutions Architect

RemoteWoman 1-10 Internet Software & Services

Upsun is hiring a Senior Solutions Architect to help launch its new AI-native software development platform by leading technical discovery, solution design, and early customer adoption.

United States Canada Full-time Senior Solutions Architect
CI/CD
2 hours, 28 minutes ago
Databricks

Solutions Architect - Field Engineering (GCC)

Databricks 1K-5K IT Services

Databricks is hiring a Senior Solutions Architect to partner with strategic global enterprise customers on data and AI architecture, delivery, and adoption within its Global Capability Center field engineering team.

India Full-time Lead Solutions Architect
Apache Spark AWS Azure Databricks GCP Generative AI Java Machine Learning MLflow Python R Scala SQL
2 hours, 29 minutes ago
Zendesk

Senior Cloud Architect, Field Engineering (GenAI Focus)

Zendesk 5K-10K Professional Services

DoiT is hiring a remote Senior Cloud Architect, Field Engineering (GenAI Focus) to lead customer-facing AWS AI delivery engagements that move customers from exploration to production while strengthening product adoption, partner motions, and repeatable field execution.

United Kingdom Estonia Ireland Netherlands Portugal Sweden Israel Full-time Senior Solutions Architect
AWS AWS CDK Azure GCP Generative AI JIRA Kubernetes MLOps OpenSearch
2 hours, 59 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