What are the responsibilities and job description for the Senior Snowflake Architect position at Hexacorp?
Title: Senior Snowflake Architect
Location: Dublin, CA (Onsite)
Contract to Hire (W2)
Job Summary
We are seeking a Senior Snowflake Architect with strong expertise in Snowflake, Microsoft Azure, and Medallion Architecture to design and implement scalable cloud data platforms. The ideal candidate will have experience building modern data lakehouse solutions and enterprise data warehouses. Retail domain experience is a plus but not mandatory.
Key Responsibilities
- Design and implement enterprise data solutions using Snowflake and Azure Cloud.
- Architect and implement Medallion Architecture (Bronze, Silver, Gold).
- Build scalable ELT/ETL pipelines using Azure Data Factory (ADF) and Snowflake.
- Design data models, optimize Snowflake performance, and implement security and governance best practices.
- Collaborate with business and technical teams to deliver scalable, high-quality data solutions.
- Provide technical leadership and mentor development teams.
Required Skills
- Strong hands-on experience as a Snowflake Architect.
- Expertise with Snowflake, Azure Data Factory (ADF), ADLS Gen2, Azure Synapse, and Azure DevOps.
- Must have a strong understanding of Medallion Architecture.
- Strong SQL, data modeling, ETL/ELT, and performance tuning skills.
- Experience with Python or Spark is preferred.
Preferred
- Retail domain experience.
- Snowflake and Azure certifications.