Snowflake developer and Data Architect
prophecy technologiesNew York (NY)
Snowflake developer and Data Architect
Posted 2 days ago
prophecy technologiesNew York (NY)
SENIORITY
Manager
About the role
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.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.