Position: Data Architect (DBT+ Snowflake)
Purpose of the Position: The Cloud Data Architect will lead the design and implementation of a modern 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
