Snowflake developer and Data Architect

Prophecy Technologies

$150K — $180K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • Minimum 10 years in data architecture or engineering
  • Hands-on experience with PostgreSQL and Snowflake
  • Strong scripting skills (Python, Ansible)
  • Familiarity with cloud architectures and data warehousing
  • Experience in building ML and AI solutions with Snowflake
  • Bachelor's degree required; master's preferred in a related field
  • Expertise in cloud-native data ecosystems and architectural patterns

Responsibilities

  • Design and manage distributed database systems using Snowflake and Postgres
  • Lead architecture and deployment of database clusters in hybrid clouds
  • Develop automation frameworks for database monitoring and scaling
  • Collaborate with teams to ensure performance and security
  • Implement backup and compliance strategies
  • Mentor junior engineers in database technologies
  • Evaluate and integrate emerging technologies to enhance efficiency

Benefits

  • Healthcare and wellness programs
  • Professional development opportunities
  • Flexible work schedule options
  • Retirement savings plan
  • Collaborative team environment
Full Job Description
Job Tittle : Snowflake Developer

Location : New York
  • 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.

Similar Jobs

More Jobs at Prophecy Technologies

More Information Technology Jobs

Find similar Snowflake developer and Data Architect jobs: