Tuesday, April 28, 2026

Urgent requirement of Snowflake Data Architect (dbt + AI) for Titusville, NJ

Hi,

This is Diksha Chaudhary working with Novia Infotech. We have the below contract job opportunity with one of our direct clients and would like to check if you have any resources available. Please send across the resume of your consultants along with the contact information at the earliest to diksha.c@noviainfotech.com.

 

Role: Snowflake Data Architect (dbt + AI)

Location: Titusville, NJ (Onsite/Hybrid)

Duration: 12+ Months

 

Description:

We are seeking a highly experienced Snowflake Data Architect with deep expertise in dbt, data modeling, and modern data platforms. This role will lead the design and implementation of scalable, secure, and cost-efficient data architectures, while driving innovation using AI/GenAI capabilities (Cortex AI). The ideal candidate will serve as a technical leader, guiding data engineering teams and aligning data solutions with business objectives.


Key Responsibilities:

Architecture & Design

  • Design and maintain end-to-end data architecture using Snowflake as the cloud data warehouse
  • Define and enforce data modeling standards (Dimensional, Data Vault, Hybrid, Semantic Layers)
  • Architect scalable and cost-efficient Snowflake environments (databases, schemas, warehouses)
  • Establish strategies for data ingestion, transformation, and consumption
  • Review and approve technical designs and data pipelines

Data Modeling & AI Enablement

  • Design data pipelines using CoCo
  • Generate insights using Cortex AI / GenAI capabilities
  • Build scalable and reusable semantic data layers

dbt Development & Governance

  • Lead dbt implementation using Datacoves
  • Define dbt project standards (naming conventions, folder structures)
  • Develop:
    • dbt models, macros, snapshots, and seeds
  • Implement data quality tests (freshness, generic, custom)
  • Enable data lineage and documentation via dbt docs
  • Establish CI/CD pipelines for dbt deployments

Data Engineering & Optimization

  • Optimize Snowflake performance using:
    • Clustering & micro-partitioning
    • Query optimization
    • Warehouse sizing and scaling
  • Monitor and manage Snowflake cost efficiency
  • Implement ELT best practices
  • Collaborate with data ingestion tools and pipelines

Security, Compliance & Reliability

  • Implement Snowflake security frameworks:
    • RBAC
    • Masking policies
    • Row-level security
  • Ensure compliance with data governance and privacy standards
  • Design data quality frameworks, SLAs, and observability mechanisms
  • Enable auditability and monitoring across the data platform

Leadership & Collaboration

  • Act as a technical advisor to data engineers and analytics teams
  • Mentor junior team members
  • Translate business requirements into scalable technical solutions
  • Collaborate with stakeholders to define KPIs and semantic layers
  • Contribute to data platform roadmap and architecture strategy

Required Skills & Experience:

  • 10+ years of overall IT experience
  • 8+ years of experience in data engineering / analytics engineering
  • 8+ years of hands-on Snowflake architecture experience
  • 6+ years of experience with dbt (Core or Cloud)
  • Strong expertise in SQL (advanced transformations & performance tuning)
  • Deep understanding of ELT architectures
  • Experience with cloud platforms (AWS / Azure / GCP)
  • Proficiency with Git-based version control and CI/CD pipelines
  • Strong experience in data modeling methodologies

Technical Skills:

  • Snowflake
  • dbt (Data Build Tool)
  • Python
  • AI / GenAI (Cortex AI)
  • SQL
  • Cloud Platforms (AWS / Azure / GCP)

Preferred Qualifications:

  • Strong communication and stakeholder management skills
  • Experience in building enterprise-scale data platforms
  • Exposure to modern data stack tools and frameworks

 

 

 

'

Diksha Chaudhary
US IT Recruiter

www.noviainfotech.com 

E: diksha.c@noviainfotech.com
A: McKinney, TX, 75070

 

 

 

--
You received this message because you are subscribed to the Google Groups "NoviaJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to noviajobs+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/noviajobs/CAEm%3D8YUW2ttzSKhHAN9S07NA%2B_u0DtBUXt_cJ5pQk4SoL72evg%40mail.gmail.com.

No comments:

Post a Comment

Urgent requirement of Flowable Developer for San Antonio, TX (Onsite)

Hi,   This is Diksha Chaudhary working with Novia Infotech. We have the below contract job opportunity with one of our direct clients and wo...