Snowflake Architect
Contract W2
Contract Independent
12 Months
No Travel Required
On-site
Depends on Experience
CogniSoft Technologies
Fitment
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Cloud Computing
- Amazon Web Services
- Apache Kafka
- Apache Spark
- Caching
- Clustering
- Collaboration
- Communication
- Continuous Delivery
- Dimensional Modeling
- Extract, Transform, Load
- Global Delivery
- Data Migration
- Data Modeling
- Data Warehouse
- ELT
- Continuous Integration
- Customer Facing
- Good Clinical Practice
- Google Cloud Platform
- Data Governance
- Database
- GitHub
- Informatica
- Performance Tuning
- SQL
- Snow Flake Schema
- Stakeholder Management
- Microsoft SQL Server
- Netezza
- Oracle
- Python
- Information Security Governance
- Leadership
- Microsoft Azure
- Migration
- RBAC
- Storage
- Talend
- Teradata
- Warehouse
- Data Lake
Summary
Position : Snowflake Architect
Location : Boston, MA
Duration: Longterm contract
Role Overview
We are seeking an experienced and certified Snowflake Architect to lead the design, migration, and implementation of scalable data platform solutions. In this role, you will define architecture blueprints, design enterprise data warehouses, optimize data pipelines, and ensure best practices in data modeling, security, and governance on the Snowflake Data Cloud.
Key Responsibilities
Architecture & Strategy: Architect, design, and implement end-to-end modern Data Warehouse and Data Lake solutions on Snowflake.
Data Migration: Lead migration initiatives from legacy databases/warehouses (Oracle, Teradata, Netezza, SQL Server) to Snowflake.
Pipeline & Integration: Design robust ETL/ELT data ingestion and transformation pipelines using tools like DBT, Snowpipe, Matillion, Talend, or Informatica.
Data Modeling: Implement dimensional modeling (Star/Snowflake schemas), Data Vault 2.0, and 3NF models optimized for cloud scale.
Performance Tuning: Optimize warehouse sizing, clustering keys, materialized views, caching strategies, and query performance to minimize compute costs.
Security & Governance: Implement Snowflake security features, including RBAC, masking policies, row-level security (RLS), external tokenization, and integration with enterprise identity providers.
Collaboration & Leadership: Partner with client stakeholders, business analysts, and engineering teams to translate business requirements into technical architectures.
Required Skills & Qualifications
Experience: 10+ years of overall IT experience with 4+ years of dedicated hands-on architecture experience in Snowflake.
Cloud Platforms: Strong knowledge of major cloud ecosystems (AWS, Azure, or Google Cloud Platform) and their native integration with Snowflake (e.g., S3/Blob storage, IAM, Lambda/Azure Functions).
Languages: Advanced proficiency in SQL, Python, or Snowpark.
ETL/ELT: Hands-on experience with modern data stack tools (DBT, Airflow, Kafka, Spark).
Certifications: Snowflake SnowPro Core or SnowPro Advanced Architect certification (highly preferred).
Communication: Excellent client-facing communication and stakeholder management skills.
Preferred Qualifications
Experience working in a global delivery/consulting model.
Familiarity with Data Mesh and modern Data Governance frameworks (e.g., Collibra, Alation).
Experience with CI/CD deployment pipelines for database objects (e.g., Flyway, Liquibase, GitHub Actions).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10527831
- Position Id: 9063538
- Posted 2 days ago
Company Info
CogniSoft Technologies focuses on providing niche Business Intelligence & Data Analytic solutions to businesses across various industries. We are Tableau Alliance Partners. We are also an SAP certified Company.
We are a team of experienced, dedicated, hardworking, and innovative professionals who have had proven their expertise in different business verticals such as Banking and Financial Industry, Healthcare, Supply chain, Insurance, Software Development, IT consulting, Business consulting etc.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs