Data Architect- Dbt (Pune)

Position: Data Architect - DBT (Snowflake) Location:Chennai/Pune/Bangalore/Nagpur Type of Employment:Full time Key Result Areas and Activities: - DBT Architecture Strategy & Standardization - Define enterprise dbt architecture standards, layering conversions, naming framework, and modular transformation design approaches supporting large scale modernisation programmes. - Code conversion, refinement and optimization - Convert complex SSIS transformations into dbt staging/intermediate/mart models, review and validate tool converted dbt transformations to ensure accuracy maintainability alignment with enterprise modelling standards. - Legacy ETL Migration Enablement Lead transformation strategies of migrating SSIS pipelines to dbt-based ELT framework while ensuring consistency scalability and maintainability. - Reusable Framework & Accelerator Development - Establish micros libraries, reusable template migration accelerator to improve delivery efficiency across multiple transformation streams. - Data Quality & Validation Strategy-Define reconciliation strategies/methodologies, parallel-run validation framework, and transformation testing standard supporting enterprise analytics reliability. - Performance Alignment with Snowflake Platform: - Collaborate with snowflake engineering teams to optimise execution strategy clustering approaches and warehouse utilization. - Governance, CI/CD & Delivery Oversight -Establish version control standards, CI/CD integration practice as, and documentation framework supporting controlled migration execution. - Documentation and lineage support - Maintain transformation documentation, mapping logic, testing evidence, and lineage metadata to support governance and audit readiness. Essential Skills: - Strong experience designing enterprise-scale dbt transformation architecture - Hands-on experience leading legacy ETL modernization programs (SSIS to ELT) - Experience developing reusable macros framework and modelling standards - Exper .