Data Architect (Snowflake)

TL;DR

Data Architect (Snowflake): Designing and modernizing enterprise Snowflake data platforms with an accent on governance, performance optimization, cost efficiency, and AI readiness. Focus on assessing complex data estates, building target-state architectures, and guiding multidisciplinary teams through scalable lakehouse, real-time, and Cortex-based solutions.

Location: Remote, onshore; the specific country or region is not stated.

Company

hirify.global is a Snowflake-focused data consulting partner delivering enterprise data migration, engineering, governance, analytics, and AI/ML transformation projects.

What you will do

• Lead assessments, architecture design, and modernization of enterprise Snowflake data platforms.
• Define current-state and target-state architectures for ingestion, transformation, storage, orchestration, governance, security, and data consumption.
• Analyze pipelines, Snowflake telemetry, workload performance, and costs to identify optimization opportunities and anti-patterns.
• Design scalable data models, governed domains, semantic layers, context models, lakehouse platforms, and real-time architectures.
• Provide technical leadership across concurrent projects, supporting planning, estimation, risk management, governance, and delivery execution.
• Lead discovery workshops and present architecture decisions, findings, impact projections, and modernization roadmaps to technical and executive stakeholders.

Requirements

• 10+ years of experience in data architecture, data engineering, or a comparable senior technical role.
• At least 2–4 years of deep Snowflake architecture and implementation experience.
• Expert SQL and strong Python skills, with hands-on experience in Snowpark, Dynamic Tables, Streams and Tasks, stored procedures, and Snowflake usage views.
• Strong experience with dbt and pipeline or orchestration technologies such as Fivetran, Kafka, or Airflow.
• Experience designing batch, streaming, lakehouse, and cloud-native architectures on AWS, Azure, or GCP.
• Strong client-facing communication, presentation, stakeholder-management, discovery, and technical leadership skills.

Nice to have

• Experience with Snowflake Cortex Analyst, Cortex Search, or Cortex LLM functions.
• Experience building governed semantic or context layers for AI and LLM applications.
• Snowflake Iceberg Tables, open lakehouse architectures, Terraform, CI/CD, and infrastructure-as-code experience.
• FinOps, cloud cost governance, business continuity, disaster recovery, or SnowPro certification.
• Consulting, enterprise client delivery, technical delivery lead, Scrum Master, Jira, Confluence, or Lucidchart experience.

Culture & Benefits

• Remote, onshore work arrangement.
• Work across enterprise transformation projects in financial services, healthcare, retail, manufacturing, energy, and other industries.
• Exposure to Snowflake, cloud-native data platforms, AI-ready architectures, and modern data engineering practices.
• Collaboration with multidisciplinary engineering, analytics, QA, and DevOps teams.