Data Engineer (Snowflake & Analytics Engineering)

Core Mission : Architecting the Modern Data Stack

Primary Engine : Snowflake + dbt / Matillion

Location : Ahmedabad (Strategic Hub)

Availability : Immediate to 30 Days (Critical Path)

Strategic Context :

In an era where "Data is the new Oil," our firm acts as the refinery. We don't just move bytes; we engineer intelligence. As a Data Engineer, you are joining a high-performance consulting squad dedicated to transforming messy, fragmented data into high-fidelity, fact-based assets.

You will be the architect of ELT pipelines that empower global organizations to make multi-million dollar decisions with absolute confidence.

The Technical Sovereignty (What You Own) :

1. The Modern ELT Stack :

- Snowflake Mastery : You are the custodian of the cloud data warehouse. You will optimize warehouse sizing, implement RBAC security, and perform deep-dive query profiling to ensure sub-second response times.

- Transformation Logic (dbt/Matillion) : You will move away from brittle ETL. You will build modular, version-controlled transformations using dbt or Matillion (DPC), following the Medallion (Bronze/Silver/Gold) architecture.

- Hybrid Integration : While we lead with the cloud, you will bridge the gap with legacy systems using SSIS, ensuring a 360-degree data view.

2. Orchestration & Cloud Ecosystem :

- Azure Integration : You will leverage Azure Data Factory and Data Lake Storage to orchestrate complex data movements from APIs, flat files, and on-premise databases.

- Analytics Engineering : You will treat data as codeapplying CI/CD, Git-based workflows, and automated testing (dbt tests) to ensure data quality is never compromised.

Candidate Blueprint (The Pedigree) :

- Experience : 3- 5 years in Data Engineering. You must have "survived" at least 2 years of hands-on Snowflake and dbt/Matillion deployment in production.

Technical DNA :

- Expert-level SQL (The foundation of everything we do).

- Proficient Python (For automation and notebook-driven engineering).

- Deep understanding of Kimball/Dimensional Modeling.

- The Consultant Mindset : You are comfortable with ambiguity, can handle high-pressure client demos, and can explain a "partitioning strategy" to a non-technical stakeholder.

Performance Benchmarks (KPIs) :

- Pipeline Reliability : Ensuring 99% uptime of scheduled dbt/Matillion jobs.

- Performance Optimization : Reducing Snowflake credit consumption through efficient SQL and clustering strategies.

- Data Quality : Implementing automated tests that catch "bad data" before it reaches the client-facing dashboards.

Why This Role?

- The "Joining Bonus" Edge : For candidates who can hit the ground running immediately, we offer a ?1 Lakh joining bonus.

- Consulting Variety : You won't be bored. You will solve different problems for different global clients every quarter.

- Office Synergy : This is a 5-day-a-week collaborative office environment in Ahmedabad, designed for rapid peer-to-peer learning.