Contract duration: 6 months with possible extension.

Salary: USD - Open as per expectations and experience

Suggestion - Tailor your resume, make it match the JD you're seeing before applying

Role Overview

We are seeking an experienced Snowflake Data Architect to lead the design, implementation, and optimization of scalable cloud-based data platforms. The adecuado candidate will possess deep expertise in Snowflake, modern data architectures, cloud ecosystems, and enterprise data transformation programs.

The candidate will work closely with business stakeholders, data engineering teams, analytics teams, and client leadership to architect robust data solutions that support advanced analytics, reporting, and AI/ML initiatives.

Key Responsibilities

- Design and implement enterprise-scale data platforms using Snowflake.
- Define end-to-end cloud data architecture, including ingestion, transformation, storage, security, and consumption layers.
- Develop scalable data models supporting analytics, BI, and machine learning workloads.
- Architect ELT/ETL solutions using technologies such as DBT, Matillion, Informatica, Azure Data Factory, or similar tools.
- Optimize Snowflake performance through clustering, partitioning strategies, workload management, and cost optimization.
- Establish data governance, metadata management, lineage, and data quality frameworks.
- Lead migration programs from traditional data warehouses (Teradata, Oracle, SQL Server, Netezza, etc.) to Snowflake.




- Collaborate with solution architects, product owners, and engineering teams to define future-state architecture.
- Ensure adherence to security, compliance, and regulatory requirements.
- Provide technical leadership, mentoring, and architecture guidance to engineering teams.
- Conduct architecture reviews, design workshops, and client presentations.

Required Qualifications

- Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or related field.
- 10+ years of experience in Data Engineering, Data Warehousing, or Data Architecture.
- 5+ years of hands-on experience with Snowflake.
- Strong expertise in dimensional modeling, Data Vault, and enterprise data architecture.
- Extensive experience with SQL and performance tuning.
- Experience designing large-scale data lakes and data warehouse solutions.
- Strong understanding of CI/CD, DevOps, and DataOps practices.
- Excellent stakeholder management and client-facing communication skills.

Technical Skills

Must Have

- Snowflake Architecture & Administration
- Advanced SQL
- Data Modeling (Star Schema, Snowflake Schema, Data Vault)
- DBT
- Python
- Git, CI/CD

Cloud Platforms (One or More)

- AWS (S3, Glue, Lambda, Redshift)

Nice to Have

- Databricks
- Kafka
- Airflow
- Power BI
- Tableau

Preferred Certifications

- SnowPro Advanced Architect
- Microsoft Azure Solutions Architect Expert

📌 Snowflake Data Architect (México)
🏢 Natsoft
📍 México