Snowflake Data Architect
PROLIM Corporation
Role: Snowflake Data Architect
Location: Boston, MA (Onsite)
Type: Contract
Role Summary:
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.
Required Skills & Experience:
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.
Data Quality: Testing frameworks (dbt tests, Great Expectations) and monitoring/observability.
Location: Boston, MA (Onsite)
Type: Contract
Role Summary:
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.
Required Skills & Experience:
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.
Data Quality: Testing frameworks (dbt tests, Great Expectations) and monitoring/observability.
Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Snowflake Data Architect in Boston, MA vacancy
- ...Snowflake Architect As a Snowflake Architect, you will be responsible for architecting, designing, and overseeing the implementation of a... ...aspects of Snowflake features. Additionally, you will develop data management architectures involving batch, micro-batch, and real...Suggested
Saviance
Boston, MA1 day ago $120k - $202.5k
Role PurposeThe Senior Data Platform Architect is responsible for the end‑to‑end architecture, security design, and governance of SSIM's enterprise data platform spanning Snowflake, Databricks, open data platforms (Iceberg/Parquet/Delta), and data virtualization. Requires...SuggestedFull timeTemporary workFlexible hours- ...Job Description Job Description We are hiring a Snowflake Architect with our Client in Boston, MA (Onsite) Job Details: Job Title... ...Location: Boston, MA Note: Need a snowflake data architect with Azure Cloud Experience and Agentic AI, Senior...Suggested
Appex Innovation
Boston, MA8 days ago - ...Recruiting for this role ends on XX/XX/XXXX.Work you'll doAs a Finance Data & AI Manager specializing in Microsoft Azure and Fabric, you’ll... ...for planning, close, profitability, treasury, and reporting• Architect production ML and generative and agentic AI with Fabric Data...SuggestedVisa sponsorship
$122k - $163k
...WithAt Slalom, we co-create custom software, data, and cloud products with clients who are... ...and move faster.What You’ll DoAs a Data Architect at Slalom, you will work in... ...Platforms & Warehouses — Amazon Redshift, Snowflake, GoogleBigQuery, Azure Synapse Analytics...SuggestedTemporary workLocal area- ...Job Title:- Data Architect Location:- Boston, MA (Hybrid) Duration:- Contract JD Design and govern conceptual... ...standards and modeling best practices aligned with Azure/Snowflake services (ADLS, Azure SQL, Snowflake etc.) Experience in...Contract work
Inficare
Boston, MA1 day ago - ...Data Architect Rate: 85/hr on C2C 80/hr on W2 Location: Durham, NC / Boston, MA Duration: 12+ Months 13-15 years ideally deep knowledge... ..., ETL tools - 5 years AWS - 3 years Nice to have: Snowflake, Snap logic, Databricks, Data Lakes Informatica AWS certs - Associate...
InteliX Systems
Boston, MA1 day ago - ...Data Architect Duration: 12 -24 Months Location: Boston, MA/ Westlake, TX/ Smithfield, RI Candidate should be local or willing... ...Experience working in Analytics Platform, AI/ML integration. Snowflake experience is a plus. ~ Experience in Knowledge Graph and Virtual...Local area
Samprasoft
Boston, MA2 days ago - ...Data Architect Hybrid Mode(5 Days in Month) Durham,NC/Boston,MA Job Description 13-15 yrs ideally Deep knowledge and understanding... ...yrs, PostgreSQL, ETL tools - 5 yrs AWS - 3 yrs Nice to Have: Snowflake, Snaplogic, Databricks, Data Lakes Informatica AWS certs -...
Software Technology Inc
Boston, MA1 day ago - ...Senior Data Architect In 2007, two software engineers and serial entrepreneurs founded our company. We are the world's largest online... ...experience with a Big Data ecosystem using technologies such as Snowflake and/or RedShift ~ Experience implementing data acquisition...Work at office
Roberts Recruiting
Boston, MA1 day ago $105.98k - $143.38k
...Position Summary The Data Architect will help design, build, and evolve our next‑generation enterprise data platform & data integration... ...guide the development of scalable, automated data pipelines in Snowflake. In addition to design of the architecture, this position...Coverys
Boston, MA2 days ago- ...Role Summary: Design and implement ingestion and transformation pipelines (DataStage/Snowflake/SQL Server/Aurora/MySQL), and build Java/Python-backed Data APIs for downstream consumers. Key Responsibilities: Create ELT/ETL pipelines (DataStage, Python) into Snowflake...
Info Way Solutions
Boston, MA14 hours ago - Soni's client is seeking an experienced Data Architect to join a growing Front Office Technology team. This role is ideal for candidates... ...cloud data platforms and modern data ecosystems, including: Snowflake Databricks AWS Expert understanding of: Data...
Soni Resources
Boston, MA2 days ago - ...NessContact: Meghana GorusuCompany: SRI Tech SolutionsData Architect - HR Data & AnalyticsBoston, MA3-4 days onsite a weekRole Overview:The... ...requirements into scalable, governed data solutions built on Snowflake and integrated with Workday and other HR systems. The ideal...Hourly pay
- Principal Data Architect, Healthcare, New England Remote, 160 - 200k base, bonusCompensation Commensurate with experience, bonus, benefits... ..., data management, data streaming, and data analytics (e.g., Snowflake, Talend, Azure/GCP solutions and platforms)· Knowledge and...Permanent employmentRemote work
$168.5k - $206k
General Information Job Title Principal Data Architect Job ID 108701 Work Areas Analytics, Data & Research, Management... ...vendor solutions, and hyperscaler services, including Databricks, Snowflake, Microsoft Fabric, AWS, Azure, and GCP. Translate complex...Permanent employmentFull timeWork at officeLocal area- ...Snowflake Architect Number of Position: 2 Only Fulltime I, Abhishek, would like to share a job opportunity as Snowflake Architect in... ...Description: 1. Minimum 7 years' experience as Solution Architect or data architect. 2. Minimum 4 years working in Snowflake as...Full timeWork visa
Syntricate Technologies
Boston, MA4 days ago - Join to apply for the Data Architect role at Jobright.ai 2 days ago Be among the first 25 applicants Join to apply for the Data Architect... ...enterprise data architecture and engineering. • Experience with Snowflake required. • Expertise in Data and AI, areas like; Data...Full timeH1bRemote workFlexible hours
- ...health ecosystem with technology and human ingenuity. Role: Data Architect Role Summary: We are seeking an experienced Data Architect... .... Guide legacy modernization and migration to cloud-native, Snowflake-aligned architectures. Evaluate platform capabilities and recommend...Worldwide
- ...Job Title: Snowflake Architect Location: Boston, MA Years of Experience: 10 15 Years Job Summary: We are seeking a highly skilled... ...development team. The ideal candidate will have a strong background in data architecture and cloud based data solutions, with a proven...
Yantran LLC
Boston, MA4 days ago $130.95k - $189.87k
...personnel so classified. Job Summary The Senior Data Architect is responsible for architecting Northeastern University's... ...existing systems-including Banner, Workday, Salesforce, ServiceNow, Snowflake, and Azure-and designs future-state structures that support...Work experience placementNortheastern University
Boston, MA2 days ago- ...DescriptionJob Description: Principal, Business Consulting -Solution Architect The vision of the Data &Analytics team is to help our clients become Data/... ...Data Platforms & Tools: Amazon, Google, Microsoft, Snowflake, Databricks. ., Managed Lakehouse Solutions, ETL/ELT...Full timeTemporary workWork experience placementLocal area
- ...We develop bespoke solutions powered by data and technology for several Fortune 100 companies... ...workforce. We are seeking a Data Architect – Patient Services to join our Life... ...with enterprise data warehouses (e.g., Snowflake, Oracle, Teradata) and data lakes. Knowledge...Local areaRemote work
Tiger Analytics Inc.
Boston, MA15 days ago - ...one driver of business reinvention. And data readiness is one of the most important factors... ...and help lead that change.You Are:As a Snowflake Advanced AI Solution Lead, you will... ...representatives, business owners, engineers, architects, and UI designers, to achieve end-to-end...Full timeWork experience placementLive inWork at officeLocal areaShift work
- Play a key role in delivering data-driven interactive experiences to our clientsWork closely with our clients in understanding their... ..., implementing data integration processes, etc)Expertise in Snowflake data modeling, ELT using snowpipe, implementing stored procedures...
- ...the full transformation journey. Solution Architecture & Design: Architect scalable, secure cloud-based solutions for large-scale... ...into practical, high-impact use cases across digital marketing, data, and customer engagement. Client Value Delivery: Work closely with...Full timeLive inWork at officeLocal area
- ...Data Solution Architect _ Boston, MA _ Onsite Job description Minimum of 15 years IT experience in Data BIA solution architecting of which at least 3 years in Azure Snowflake Databricks Good experience in Data architecture data warehousing architecture...
Argyll Infotech, Inc.
Boston, MA5 days ago - ...tomorrow.Ascensus does not provide visa sponsorship now or in the future and does not hire candidates working under OPT.The Data Program Architect is responsible for defining and driving the architecture vision, strategy, and execution of the enterprise data platform...Full timeSecond job
- ...together, we can move faster, dream bigger, and build better tomorrows for all.The Snowflake Center of Excellence (CoE) is focused on building, developing, and delivering holistic data solutions leveraging Snowflake and its evolving data platform. Snowflake’s product roadmap...Temporary workLocal area
- ...Details: Client is seeking a Data Engineer to design, develop, implement discrete data pipelines in support of RAG-based retrieval, inferencing, and reasoning. Self-starter and collaborative mentality is a critical part of this fast-moving team. Experienced-based proficiency...
3B Staffing LLC
Boston, MA4 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Snowflake Data Architect. Be the first to apply!
Related searches