> Markdown version of [/jobs/ext/4503984-snowflake-data-architect](https://www.wearedevelopers.com/jobs/ext/4503984-snowflake-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Snowflake Data Architect

- **Company:** PROLIM Global Corporation
- **Location:** Boston, MA, United States
- **Contract:** Permanent contract
- **Skills:** Third Normal Form, Airflow, Amazon Web Services, Amazon S3, Data Analysis, Microsoft Azure, Cloud Computing, Code Review, Cyber Security, Databases, Continuous Integration, Data Architecture, Data Validation, Extract Transform Load (ETL), Data Security, Data Systems, Data Vault Modeling, Dimensional Modeling, Identity and Access Management, Python (Programming Language), Key Management, Networking Basics, Performance Tuning, Query Optimization, Role-Based Access Control, Simple Data Format, SQL Databases, Snowflake, Git Flow, Star Schema, Software Version Control, Data Pipelines
- **Published:** November 2, 2026
- **Apply:** https://www.careerbuilder.com/job-details/snowflake-data-architect-boston-ma--d228a505-5123-4909-a1fb-8b384fc44fd2

## About the Role

Snowflake Schema, DataArchitect Data Modeling Tool, Database Extract Transform and Load (ETL), Star Schema, Data Modeling, Information/Data Security (InfoSec), Performance Tuning/Optimization, SQL (Structured Query Language), DataArchitect Data Modeling Tool, Use Cases, Must have:

Snowflake (Hands-on Expert):

Warehouses, Databases, Schemas, Roles & Grants (RBAC) Stages (internal/external), File Formats, COPY INTO, Snowpipe, Streams & Tasks Time Travel, Cloning, Zero-Copy Clones, Fail-safe awareness Query tuning (clustering keys, micro-partitions, caching, pruning) Secure data sharing, masking policies, tags, governance features BCR, DR, Storage integration and Parameters Materialized / Semantic Views, Dynamic Tables, Stream Lit, Snowflake Architecture SQL Mastery: Strong, production-grade SQL for large-scale transformations.

Good to have:

Programming: Python (preferred) for ELT utilities, framework integration, data quality checks; dbt for transformation-as-code is a strong plus.

Orchestration: Airflow (preferred) or ADF/Glue/Composer; scheduling, dependencies, retry policies, SLAs.

Data Modeling: Dimensional modeling (Kimball), SCD Type 1/2; normalization/denormalization trade-offs; exposure to data vault is a plus.

Cloud Platforms: Experience with at least one major cloud (AWS/Azure/GCP) for storage (S3/ADLS/GCS), IAM, networking basics, and secrets management.

Version Control & CI/CD: Git workflows, branching, code reviews, packaging, environment promotion.

## Description

We are seeking a hands-on Snowflake Data Architect to design, build, optimize, and productionize data pipelines and data products on Snowflake for enterprise analytics use cases. The role requires deep expertise in SQL, ELT/ETL orchestration, data modeling (3NF/Star/Snowflake), performance tuning, cost optimization, and secure data sharing in Snowflake. You'll collaborate with Product Owners, Data Architects, Analytics Engineers, and Platform teams to deliver reliable, scalable, and well-governed data solutions for TJX.