Lead Snowflake & PostgreSQL Data Architect

Prophecy Technologies Corp; New York (NY); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Prophecy Technologies Corp. in New York seeks a senior data architect to design and manage large-scale, distributed database systems across hybrid cloud environments.

You will lead architecture decisions, optimize Snowflake and PostgreSQL deployments, and drive data governance and security across the stack. Responsibilities include developing automation for provisioning, monitoring, and scaling, mentoring engineers, and collaborating with product and audit leadership to align data strategy with

Qualifications

• Minimum 10 years of experience in data architecture or a related field.
• Hands-on expertise with PostgreSQL and Snowflake administration and performance tuning.
• Strong scripting and automation skills (Python, Ansible, etc.).
• Experience with cloud-based data warehousing platforms and migration patterns.
• Expertise in RAG and vector search design and implementation.
• Bachelor's degree required; master's degree preferred.
• Experience with data governance, SDLC in regulated environments, and cross-functional collaboration.
• Proven ability to lead and mentor engineers and influence architectural decisions.

Responsibilities

• Design, implement, and manage large-scale distributed database systems.
• Lead 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.
• Govern data ingestion, processing, and data quality across systems.
• Drive modernization including cloud-native database adoption and serverless architectures.
• Mentor junior engineers and contribute to cross-training initiatives across database technologies.
• Establish data governance policies and ensure security and reliability of data solutions.

Skills

Data architecture

Snowflake administration

PostgreSQL administration

Python scripting

Automation (Ansible)

Cloud data platforms

Education

Bachelor's degree in CS/Engineering

Master's degree preferred

Tools

Snowflake

PostgreSQL

Python

Ansible

Databricks

Power BI

Azure AI Search

Job description

Prophecy Technologies Corp. in New York seeks a senior data architect to design and manage large-scale, distributed database systems across hybrid cloud environments.

You will lead architecture decisions, optimize Snowflake and PostgreSQL deployments, and drive data governance and security across the stack. Responsibilities include developing automation for provisioning, monitoring, and scaling, mentoring engineers, and collaborating with product and audit leadership to align data strategy with