Position:
Data Architect (DBT+ Snowflake)

Purpose of the Position:
The Cloud Data Architect will lead the design and implementation of a up-to-date cloud-based data platform by collaborating with stakeholders to migrate existing SQL Server SSIS workloads to Snowflake using dbt-based ELT frameworks.

This role focuses on defining scalable, reliable, and governed data transformation architecture aligned with business requirements. The role is expected to provide architectural oversight, guidance to delivery teams, and ensuring solution alignment across phases.

Location:
Pune/Chennai/Bangalore/Nagpur

Type of Employment:
Full-time

Key Result Areas and Activities:
- Define target architecture for
SSIS to Snowflake + dbt migration
- Establish
Pipeline Architecture
and
dbt-based transformation framework
including staging, intermediate, and mart layers
- Guide and perform conversion of
SSIS packages into dbt models
using




various AI tools
(SnowConvert/Cortex Code AI) with human in loop & manual refactoring
ensuring consistency and scalability
- Define best practices for
naming convention,
data modelling, performance optimisation, and cost efficiency on Snowflake
- Design
data validation, reconciliation, end to end testing and parallel run strategies
for migration assurance
- Provide architectural oversight to ensure adherence to standards and solution design
- Collaborate with stakeholders to align migration approach with business needs
- Support
governance, documentation, and lineage approach
for audit readiness
- Enable CI/CD practices and version control for dbt deployments
- Identify risks and recommend mitigation strategies during migration lifecycle

📌 Data Architect (Chennai)
🏢 InfoCepts
📍 Chennai