Data/Snowflake Architect

Hierarch Soft Technologies, Inc.
New York, NY, United States
1 day ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source

Tech stack

Agile Methodology Artificial Intelligence Amazon Web Services Architectural Patterns ARM Architecture Microsoft Azure Backup Devices Big Data Databases Data Architecture Information Engineering Data Governance
+34 more
Data Infrastructure Data Systems Software Design Patterns Disaster Recovery Distributed Data Store Graph Database Information Lifecycle Management Python (Programming Language) PostgreSQL Machine Learning Performance Tuning Systems Development Life Cycle Query Optimization Power BI Ansible Search Technologies SQL Databases Talend Transaction Data Unstructured Data Cloud Platform System System Availability Snowflake Apache Spark Generative AI HybridCloud Microsoft Fabric Information Technology Data Analytics Data Management Machine Learning Operations Virtual Agents Serverless Computing Databricks

Job description

  • Design, implement, and manage large-scale distributed database systems using Snowflake and Postgres.

  • Lead the architecture and deployment of database clusters across hybrid cloud environments (AWS, Azure).

  • Develop and maintain automation frameworks for provisioning, monitoring, and scaling database infrastructure.

  • Collaborate with data engineering, platform, and application teams to ensure high availability, security, and performance.

  • Drive adoption of best practices for schema design, query optimization, and data lifecycle management.

  • Implement robust backup, disaster recovery, and compliance strategies.

  • Mentor junior engineers and contribute to cross-training initiatives across database technologies.

  • Govern how both structured and unstructured data is ingested, processed, and engineered for context.

  • Ensure high availability, disaster recovery, and performance tuning across multi-region deployments.

  • Collaborate with senior product, engineering, and audit leadership to influence business strategy and ensure solutions are built on a sound architectural foundation.

  • Architect and oversee the design and development of data and context engineering capabilities using Snowflake and PostgreSQL.

  • Make critical design decisions that enable seamless integration into Data Analytics, Business Intelligence Reporting, and AI agent workflow capabilities.

  • Establish and enforce data governance, quality standards, and validation frameworks.

  • Guarantee the integrity, security, and reliability of all data solutions.

  • Drive modernization initiatives including cloud-native database adoption, serverless architecture, and AI/ML integration.

  • Evaluate and implement emerging technologies to improve platform efficiency and developer experience.

  • Drive the future of audit technology by leading architectural innovation.

  • Champion the evaluation and adoption of next-generation data platforms, knowledge graphs, and advanced data fabrics.

Requirements

  • Minimum 10 years of recent experience in data architecture, data engineering, or a similar field.

  • Hands-on expertise with PostgreSQL and Snowflake administration and performance tuning.

  • Strong scripting and automation skills (Python, Ansible, etc.).

  • Familiar with Cloud Based Architectures /Data-Warehousing Platforms, prior experience / knowledge in Snowflake Design Patterns and migration workflow would be a plus.

  • Prior exposure building ML and generative AI solutions using Snowflake Cortex Analyst, Search, AI SQL, Snowflake ML, and Snowpark Container Services.

  • Proven record of architecting and delivering large-scale data warehouse modeling and reporting solutions for enterprise systems.

  • A bachelor’s degree from an accredited college or university is required. A master’’'’s degree in computer science, engineering, or a related technical discipline is preferred.

  • Expertise in architecting cloud-native data ecosystems using platforms such as Snowflake, Databricks, Talend, SPARK, Power BI, and Microsoft Fabric.

  • Deep knowledge of designing solutions that incorporate Retrieval-Augmented Generation (RAG) and vector search (e.g., Azure AI Search).

  • In-depth understanding of architectural patterns for processing and modeling both structured transactional data and unstructured information.

  • Experience with transactional processing and AI/ML applications.

  • Demonstrated experience defining architectural principles, data governance policies, and technology standards within a large-scale, regulated, and Agile Software Development Life Cycle (SDLC) environment.

  • Exceptional problem-solving, communication, collaboration and leadership skills.

  • Ability to articulate strategic technical vision, influence executive-level stakeholders, and guide solutions for complex business problems.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:42 min

Automating Skupper deployments using Ansible

Alex Soto Alex Soto · WWC 2024

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:19 min

Executing complex workflows using Ansible Automation Platform

Goetz Rieger Goetz Rieger · WWC 2025

3:14 min

Structuring career paths and localized data architectures

Ulrich Wurstbauer +1 · LIVE

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

Videos

See all

Related articles

See all