Snowflake Data Architect
SmallArc, Inc
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Snowflake
- Data modeling
Summary
Role: Snowflake Data Architect
Location : New York NY
Project description: The primary goal of the project is the modernization, maintenance and development of an eCommerce platform for a big US-based retail company, serving millions of omnichannel customers each week.
Solutions are delivered by several Product Teams focused on different domains - Customer, Loyalty, Search and Browse, Data Integration, Cart.
Current overriding priorities are new brands onboarding, re-architecture, database migrations, migration of microservices to a unified cloud-native solution without any disruption to business.
Responsibilities:
- 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.
Skills
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.
Thanks & Regards
Sami | Sr Lead Recruiter
Small Arc Inc.
860 US Highway 1, Suite 103 Edison NJ 08817
Direct:
- Dice Id: 10115873
- Position Id: 9050223
- Posted 2 days ago
Company Info
Our firm was established back in 2000 by a group of consultants with a strong focus on delivering quality services to our clients from the perspective of those who worked in the field. Because of the huge amount of industry experience behind us, we knew that we could provide our clients with a no gimmicks, truly valuable set of solutions that exactly matched all of their IT needs.
In today’s digital world, we’re surrounded by information at all times. The purpose of SmallArc is to provide a cohesive set of information management solutions that organize, optimize and present information in an efficient and informative way.
SmallArc is a premier consulting firm specializing in Business Intelligence, Data Warehousing, and Data Integration. We provide end-to-end services from Data Architecture, Implementation, Project Management, Long Term Support, and Training.
We provide you with a competitive advantage which is derived from our extensive team of business intelligence experts. We recruit and employ only the best and brightest to ensure the highest level of knowledge and competence. We provide you with the most innovative, reliable, and consistent results on every project — no matter the scope or scale. We have earned a solid reputation for client success due to our unique ability to deliver business intelligence solutions on time, and under budget.
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