Snowflake Developer Lead/Architect jobs in United States
cer-icon
Apply on Employer Site
company-logo

Veterans Sourcing Group, LLC · 4 months ago

Snowflake Developer Lead/Architect

Veterans Sourcing Group, LLC is seeking an experienced and visionary Snowflake Lead/Architect who will also perform hands-on development to design, build, and implement their enterprise cloud data platform using Snowflake. This hybrid role combines strategic architectural leadership with active involvement in coding, data pipeline development, and platform optimization.

Human ResourcesRecruitingStaffing Agency
check
Work & Life Balance

Responsibilities

Architect and design end-to-end Snowflake solutions including landing zones, staging layers, DataMarts, and semantic layers based on Medallion architecture principles
Define and enforce data modeling best practices (dimensional, star, snowflake schemas) to ensure performance and scalability
Develop, test, and deploy Snowflake SQL scripts, stored procedures, tasks, streams, and materialized views to implement business requirements
Build robust, scalable ETL/ELT pipelines using Snowflake and transformation frameworks such as DBT
Create and maintain data ingestion workflows integrating sources like Fivetran, Azure Blob Storage, CRM, ERP, and Marketing systems
Perform performance tuning, query optimization, and troubleshoot data issues in Snowflake environments
Drive architectural standards for Snowflake development, data ingestion, transformation, and consumption
Collaborate with data engineering teams to implement the best practices and maintain data pipeline reliability
Provide technical guidance, mentorship, and code reviews for developers and engineers working on the platform
Define and implement data governance, security, and access control strategies leveraging Snowflake RBAC, masking policies, and data sharing capabilities
Ensure compliance with data privacy, lineage, and regulatory requirements
Continuously monitor Snowflake usage and recommend improvements for warehouse sizing, query performance, credit usage, and storage efficiency
Stay current with Snowflake features, cloud data trends, and marketplace offerings to drive innovation
Contribute to the overall data platform roadmap including AI/ML readiness and real-time analytics enablement

Qualification

Snowflake solutionsSQL proficiencyData architectureELT/ETL frameworksData governanceAzure cloud servicesStakeholder influenceLeadershipProblem-solvingCommunicationAdaptability

Required

8+ years in data architecture, engineering, or developer roles
4+ years of hands-on experience architecting, developing, and optimizing Snowflake solutions
Strong SQL proficiency with experience writing complex queries, stored procedures, and performance tuning
Expertise in ELT/ETL frameworks (DBT) and data ingestion tools like Fivetran
Experience with orchestration tools such as Dagster, Airflow, or Prefect
Familiarity with Azure cloud services including Azure Blob Storage and Azure Data Factory
Deep understanding of modern data architecture principles (Medallion architecture, Data Vault, Data Mesh)
Proven ability to implement data governance and security controls on Snowflake platforms

Preferred

Snowflake Certification
Experience with CI/CD for data platforms (Git, Terraform, dbt Cloud)
Knowledge of Power BI integration with Snowflake
Exposure to AI/ML data pipelines and analytics enablement
Familiarity with metadata management and data lineage tools

Company

Veterans Sourcing Group, LLC

twittertwitter
company-logo
Welcome to the Veterans Souring Group company profile. Veterans Sourcing Group (VSG) is a “Service Disabled Veteran Owned Small Business – SDVOSB”.

Funding

Current Stage
Early Stage
Company data provided by crunchbase