We’re Hiring: Senior Data Architect – Snowflake & dbt

Company: Claidroid Technologies Pvt. Ltd.

Location: Trivandrum / Pune – Hybrid

Experience: 10–12 years

Mandatory Core Skills: Data Architecture | Snowflake | dbt | Data Modelling | SQL | Python

Claidroid Technologies is looking for an accomplished Senior Data Architect to join an enterprise data transformation initiative in Trivandrum / Pune under a hybrid working model.

We are looking for an architect with deep expertise in modern enterprise data architecture, particularly Snowflake and dbt, who can define robust architectural solutions, guide engineering teams and help establish scalable, governed and future-ready data platforms.

About Claidroid Technologies

Claidroid Technologies is a global digital transformation and technology services partner with strong leadership experience and presence across India, Europe and the USA.

We partner with leading enterprises in regulated industries to deliver scalable, high-quality technology solutions through deep domain expertise, strong governance, rigorous quality assurance and business-aligned delivery.

Role: Senior Data Architect – Snowflake & dbt The successful candidate will play a key role in defining and steering the end-to-end data architecture strategy, ensuring alignment with enterprise standards, scalability requirements and long-term business objectives.

The role requires someone who can operate as a hands-on individual contributor and architectural leader, working closely with stakeholders and engineering teams to translate business requirements into practical, scalable architecture.

Key Responsibilities

- Define and own the end-to-end enterprise data architecture strategy.
- Design reference architectures and solution blueprints for cloud-based, Snowflake-centric data platforms.
- Architect data solutions covering ingestion, transformation,



storage and consumption layers.
- Guide teams towards agreed architecture and ensure adherence to enterprise architecture standards.
- Develop Conceptual, Logical and Physical Data Models and associated architectural artefacts.
- Design enterprise data warehouse solutions using established patterns including:
- Data Vault 2.0
- Dimensional Modelling / Kimball
- SCD Type 1 & Type 2
- Persistent Staging Areas
- Change Data Capture – CDC
- Design repeatable and industrialised ETL/ELT frameworks using dbt for transformation orchestration.
- Define integration patterns for ingesting data from heterogeneous source systems.
- Establish architectural principles, design patterns, naming conventions and data standards.
- Conduct architecture reviews and ensure compliance across delivery teams.
- Evaluate and recommend cloud-native data technologies and tooling.
- Drive architectural decisions through properly documented Architecture Decision Records – ADRs.
- Identify business and platform inefficiencies and recommend approaches for improving data processing, handling and cleansing.
- Contribute innovative ideas towards the development of future data products.
- Ensure appropriate consideration of data privacy, GDPR and sensitive-data historisation.
- Collaborate effectively with business, engineering and technology stakeholders.

Technical Skills

Strong expertise in

- Snowflake
- dbt
- Enterprise & Solution Architecture
- Data Architecture
- Data Warehouse Architecture
- Azure and/or AWS
- SQL




- Python
- ETL / ELT concepts and frameworks
- Data Vault 2.0
- Dimensional Modelling
- OLAP & OLTP
- SCD Type 1 / Type 2
- Change Data Capture – CDC
- Conceptual, Logical & Physical Data Modelling
- Cloud-native data platforms and modern data architecture

Ideal Candidate Profile

We are particularly interested in candidates who:

- Have 10–12 years of overall experience with robust depth in Data Architecture.
- Possess proven expertise in enterprise and solution architecture.
- Have strong hands-on knowledge of Snowflake and dbt.
- Understand the broader modern data landscape and can evaluate technologies pragmatically.
- Can architect scalable data platforms while remaining closely engaged with delivery teams.
- Are comfortable operating as an individual contributor while influencing senior stakeholders and engineering teams.
- Can balance architectural rigour, governance and practical delivery.

Why Join Claidroid Technologies?

- Work on large-scale global enterprise data transformation programmes.
- Gain exposure to Snowflake, dbt, Cloud Data Platforms, Data Engineering and modern Data Architecture.
- Influence the design and evolution of complex enterprise data platforms.
- Work alongside experienced engineering, architecture and business professionals.
- Grow in a culture focused on quality, ownership, accountability, innovation and continuous learning.

Work Location

Trivandrum / Pune – Hybrid

Candidates should be comfortable working from the office as required under the hybrid model.

If you are an experienced Data Architect with strong Snowflake and dbt expertise and are looking for an opportunity to shape modern enterprise data platforms, we would be delighted to hear from you.

Apply now and be part of Claidroid Technologies’ growth journey.

📌 Senior Data Architect – Snowflake & dbt (Pune)
🏢 Claidroid
📍 Pune