Snowflake developer and Data Architect

Prophecy Technologies Corp; New York (NY); Ibrido; USD 140.000 - 190.000; Tempo pieno

Descrizione del lavoro

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

Competenze

• 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.

Mansioni

• 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.

Conoscenze

Data architecture

Snowflake administration

PostgreSQL administration

Python scripting

Automation (Ansible)

Cloud data platforms

Formazione

Bachelor's degree in CS/Engineering

Master's degree preferred

Strumenti

Snowflake

PostgreSQL

Python

Ansible

Databricks

Power BI

Azure AI Search

Descrizione del lavoro

• 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 Al 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 Al/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.
• Act with integrity, professionalism, and personal responsibility to uphold respectful and courteous work environment.

Qualifications

• -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 Al solutions using Snowflake Cortex Analyst, Search, Al-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 Al 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 regulated and Agile Software Development Life Cycle (SDLC)
• -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.