> Markdown version of [/jobs/ext/1994018-snowflake-data-architect](https://www.wearedevelopers.com/jobs/ext/1994018-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:** Small Arc Inc - **Location:** New York, NY, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Microsoft Azure, Bash Shell, Big Data, Unix, Cloud Computing, Cloud Database, Databases, Data Architecture, Extract Transform Load (ETL), Data Transformation, Data Systems, Data Vault Modeling, Data Warehousing, Database Queries, Dimensional Modeling, Python (Programming Language), PostgreSQL, SQL Azure, Performance Tuning, Queueing Systems, Windows Shell, Azure Data Lake, Shell Script, SQL Databases, Informix, Data Storage Management, Cloud Platform System, Azure Data Factory, Snowflake, Data Lakes, Pyspark, Cosmos DB, Data Management, Physical Data Models, Azure Synapse Analytics, Data Pipelines, Databricks - **Published:** August 8, 2026 - **Apply:** https://www.dice.com/job-detail/fbe1fb3a-43b9-4fde-adac-cf4dfd690310 ## About the Role Must have: * Overall years of experience required 12+ (at least 5+ years in an Architect position) * Strong, recent hands-on expertise with Azure Data Factory and Synapse is a must (6+ years). * Strong expertise in designing and implementing data models, including conceptual, logical, and physical data models, to support efficient data storage and retrieval. * Strong knowledge of Microsoft Azure, including Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, and Azure Databricks, pySpark for building scalable and reliable data solutions. * Extensive experience with building robust and scalable ETL/ELT pipelines to extract, transform, and load data from various sources into data lakes or data warehouses. * Ability to integrate data from disparate sources, including databases, APIs, and external data providers, using appropriate techniques such as API integration or message queuing. * Proficiency in designing and implementing data warehousing solutions (dimensional modeling, star schemas, Data Mesh, Data/Delta Lakehouse, Data Vault) * Proficiency in SQL to perform complex queries, data transformations, and performance tuning on cloud-based data storages. * Experience integrating metadata and governance processes into cloud-based data platforms * Certification in Azure, Databricks, or other relevant technologies is an added advantage * Experience with cloud-based analytical databases. * Experience with Azure MI, Azure Database for Postgres, Azure Cosmos DB, Azure Analysis Services, and Informix. * Experience with Python and Python-based ETL tools. * Experience with shell scripting in Bash, Unix or windows shell is preferable. * Demonstrated ability to lead cross-functional engineering teams, define technical strategy and architecture, drive delivery of complex data platforms, mentor engineers, and effectively communicate with stakeholders at all organizational levels. ## Description * We are looking for a Snowflake Data Architect who will be responsible for designing a solution for a big retail company. The main focus is to support processing of big data volumes and integrate solutions to current architecture. ## Related Videos - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [WeAreDevelopers LIVE - Node and Package Security](https://www.wearedevelopers.com/videos/2138-wearedevelopers-live-node-and-package-security) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)