Position: Data Architect (DBT+ Snowflake)

Purpose of the Position: The Cloud Data Architect will lead the design and implementation of a contemporary 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 modelsusing 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

Essential Skills:
- Strong hands-on experience in Snowflake architecture, Data Engineering and data warehouse design:
- Hands-on experience with dbt transformation framework and ELT concepts:
- Experience in SSIS to Snowflake (or legacy ETL to ELT) migration programs:
- Strong SQL and data modelling (dimensional modelling)

📌 Data Architect (Chennai)
🏢 InfoCepts
📍 Chennai