Snowflake Data Architect

Acuity Analytics; Gurugram District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Acuity Analytics is seeking a highly skilled Data Engineer in Gurugram to independently design, build, and optimize scalable data solutions. You will own Snowflake databases, the Bronze–Silver–Gold data layers, and robust data pipelines using dbt, Python, and Airflow/ADF for orchestration.

You will ensure data quality, governance, and secure access patterns while collaborating with architects and stakeholders to translate requirements into scalable data solutions.

Qualifications

• Proficient in designing Snowflake databases, schemas, warehouses, and access controls.
• Hands-on experience with Snowpipe, Streams, Tasks, and Time Travel for performant data pipelines.
• Strong data modeling skills (dimensional and normalized) aligned with business needs.

Responsibilities

• Independently design and implement Snowflake architectures and data models.
• Build end-to-end data pipelines using dbt, Python, and Airflow/ADF for orchestration.
• Configure and optimize ETL/ELT processes, CI/CD workflows, and deployment practices.
• Consume and integrate data from REST/SOAP APIs and connect Snowflake to ERP/CRM systems.

Skills

Snowflake

dbt

Python

Airflow

REST APIs

Data modeling

CI/CD

RBAC

Tools

Snowflake

dbt

Airflow

ADF

Job description

We are seeking a highly skilled and Snowflake‑certified Data Engineer to independently design, build, and optimize scalable data solutions across the enterprise. The ideal candidate will have deep hands‑on expertise in Snowflake architecture, data modeling, and end‑to‑end pipeline development, along with a strong understanding of cloud data ecosystems, API integration, and enterprise data platforms. This individual contributor role requires a self‑driven engineer capable of owning complex data engineering initiatives end‑to‑end while ensuring performance, reliability, and alignment with business needs.

• Independently design and implement Snowflake databases, schemas, warehouses, RBAC, and workload management.
• Configure and optimize Snowpipe, Streams, Tasks, Materialized Views, Clustering, and Time Travel.
• Perform performance tuning and troubleshoot issues directly from the Snowflake portal.
• Design robust dimensional and normalized data models aligned with financial domain needs.
• Architect and implement Medallion (Bronze–Silver–Gold) data layers for scalable pipelines.
• Ensure data quality, governance, and secure access patterns.
• Build and manage end‑to‑end pipelines using dbt for transformations Python for automation Airflow/ADF for orchestration.
• Implement and maintain CI/CD workflows, code reviews, and automated deployment processes.
• Consume REST/SOAP APIs for data ingestion and integration.
• Connect Snowflake with enterprise systems (Salesforce, SAP, CRM/ERP, cloud services).
• Integrate Snowflake with cloud‑native services for ingestion, compute, and storage.
• Take complete ownership of design, development, deployment, and support with minimal oversight.
• Work directly with architects, business analysts, and stakeholders to translate requirements into solutions.
• Produce high‑quality documentation, reusable components, and engineering best practices.