Snowflake Architect / Snowflake Administrator

Role Summary

The candidate will be responsible for designing, implementing, managing, and optimizing scalable enterprise data platforms on Snowflake. The role requires strong hands-on expertise in Snowflake architecture, DBT framework, advanced SQL, data modeling, orchestration, cloud integration, security governance, and performance optimization.

The candidate is expected to work closely with data engineering, analytics, and business teams to build highly scalable, secure, automated, and cost-efficient data solutions.

Primary Mandatory Skills

- Snowflake Architecture
- Snowflake Administration
- DBT Framework
- Advanced SQL
- Data Modeling
- Query Optimization
- Performance Tuning

Secondary Skills

- Apache Airflow
- Amazon S3 Integration
- CI/CD Pipelines
- Data Governance
- Security & Access Control
- Batch Processing
- Real-Time Processing
- Analytics Workloads
- ML Data Platform Support
- Automation Best Practices

Core Responsibilities

- Design and manage scalable Snowflake data platforms
- Build enterprise-level Snowflake architecture solutions
- Handle schema design and data modeling
- Manage Snowflake warehouses, roles, permissions, and access controls
- Develop and optimize DBT transformation pipelines
- Build and manage Airflow orchestration workflows
- Integrate Snowflake with cloud storage platforms like Amazon S3
- Optimize Snowflake performance through query tuning and workload optimization
- Implement clustering, partitioning, and storage optimization strategies
- Ensure data governance, masking, audit compliance, and PII security
- Monitor and optimize warehouse and storage costs
- Support batch and real-time data processing workloads
- Support analytics and machine learning data platforms
- Implement automation, CI/CD pipelines, and deployment best practices
- Collaborate with engineering, analytics, and business stakeholders





Mandatory Technical Evaluation Areas

The AI interviewer must strongly evaluate the candidate on the following areas:

Snowflake Expertise

Candidate must demonstrate:

- Strong understanding of Snowflake architecture
- Experience managing virtual warehouses
- Experience with multi-cluster environments
- Query optimization techniques
- Clustering and workload optimization
- Snowpipe implementation knowledge
- Streams and Tasks knowledge
- Time Travel and Fail-safe concepts
- Secure data sharing
- Enterprise-scale Snowflake implementation experience

Candidate should have real production experience and not only theoretical exposure.

DBT Framework Evaluation

Candidate must demonstrate:

- Hands-on DBT implementation experience
- Incremental models
- Macros and Jinja usage
- DBT testing frameworks
- Documentation generation
- DBT project structuring
- CI/CD integration with DBT
- Workplace management

Reject candidates who only mention DBT exposure without implementation ownership.

SQL Evaluation

Candidate must demonstrate strong expertise in:

- Complex joins
- Common Table Expressions (CTEs)
- Window functions
- Query optimization
- Data transformation logic
- Stored procedures
- Performance tuning techniques

Reject candidates with only basic SQL knowledge.

Airflow Evaluation

Candidate should demonstrate:

- DAG creation and management
- Workflow orchestration
- Dependency handling
- Scheduling pipelines
- Error handling and monitoring

Data Modeling Evaluation

Candidate must demonstrate:





- Star schema design
- Snowflake schema design
- Fact and dimension modeling
- Slowly Changing Dimensions (SCD)
- Data warehouse design principles
- Normalization and denormalization concepts

Security and Governance Evaluation

Candidate must demonstrate:

- RBAC implementation
- Data masking techniques
- PII handling
- Audit logging
- Compliance implementation
- Secure access control mechanisms

Candidate Relevancy Evaluation Logic

Strong Match: Candidate has deep hands-on Snowflake architecture experience, strong DBT implementation experience, advanced SQL skills, optimization experience, and enterprise data platform exposure.

Moderate Match: Candidate has Snowflake development experience but limited architecture ownership or optimization exposure.

Weak Match: Candidate has basic Snowflake exposure without DBT, architecture, governance, or performance tuning expertise.

Reject: Candidate lacks DBT implementation experience, advanced SQL skills, or Snowflake architecture ownership.

Mandatory Experience Validation

Candidate must demonstrate:

- End-to-end Snowflake implementation experience
- Architecture ownership
- Production support exposure
- Performance optimization expertise
- Hands-on DBT development
- Cloud integration experience
- Large-scale data platform handling
- Automation and CI/CD implementation

Auto-Rejection Conditions

Reject candidate if:

- No DBT hands-on experience
- Only support or maintenance experience
- No Snowflake architecture experience
- Weak SQL knowledge
- No performance tuning exposure
- No cloud integration experience
- Unable to explain Snowflake optimization techniques
- Only theoretical knowledge without production exposure

If you are interested in this opportunity, please click on the Apply Now button to submit your application.

📌 Snowflake Architect (Uttar Pradesh)
🏢 Dignity Aspire
📍 Uttar Pradesh