Haystack
← Back to Jobs
Other

Snowflake Architect

Prudent Technologies and ConsultingHouston, TX🇺🇸United StatesPosted 15 Jul 2026

Quick Overview

Work Type
On Site
Level
Mid Senior

Job Description

Role: Snowflake Architect Location: Houston, Texas, United States (Onsite)
Full Time
Interview 2 Virtual 1 Onsite.
Key Responsibilities
  • Design, build, and maintain scalable data pipelines across structured, semi-structured, and unstructured data sources.
  • Develop data ingestion and extract-load processes using Informatica, aligning with enterprise standards and existing in-house capabilities.
  • Build transformation logic using dbt, including modular models, testing, documentation, and deployment workflows.
  • Design and manage data structures in Snowflake, with Snowflake positioned as the central strategic data platform.
  • Work with AWS-based data services and infrastructure, supporting applications and data products running in the organization s AWS environment.
  • Support data architecture using Iceberg managed tables, including open table formats, interoperability, cataloging, and governed access patterns.
  • Use Snowflake Catalog and Snowflake Horizon to support metadata management, data discovery, governance, lineage, policy enforcement, and trusted data sharing.
  • Collaborate with data architects, governance teams, analysts, application teams, and business stakeholders to define trusted data products.
  • Work with domain experts to understand business concepts, entities, relationships, and terminology.
  • Support ontology-driven modeling, including entity definitions, taxonomies, relationships, business glossaries, and semantic mappings.
  • Translate business and domain concepts into logical data models, physical data models, and reusable data products.
  • Implement data quality checks, validation rules, lineage, observability, and governance controls.
  • Support data products and applications such as news intelligence, asset intelligence, analytics, and AI-enabled use cases.
  • Ensure data solutions meet enterprise requirements for security, privacy, access control, performance, and reliability.

Skills

AWS
Snowflake
dbt

Similar jobs