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
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
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
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 StageCompany data provided by crunchbase