*Purpose of the Position:** This role seeks candidate who is passionate about building and optimising cloud\-based data platform that support modern analytics initiatives. You will assist in implementing scalable Snowflake data pipeline building efficient ingestion, transformation workflows, and supporting migration from legacy ETL system to dbt\-driven ELT architectures. The role contributes to improving data accessibility, performance, and consistency across enterprise analytics environment.
**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.
**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.
Experience implementing CI/CD workflow for transformation deployments
Familiarity with version control systems (GIT/Azure DevOps)
*Desirable Skills:**
Exposure implementing dbt mesh architecture
Exposure to metadata driven transformation framework
Experience integrating governance and lineage tooling
Familiarity with terraform based infrastructure automation
Exposure to enterprise data platform modernization programs
Experience collaborating with platform engineer teams for workload optimization
Experience mentoring junior engineers in transformation programs
*Qualifications:**
Experience: 9\+ years of experience in data engineering, ETL/ELT development, hands\-on dbt development.
Education: Bachelor's in computer science, Information Technology, or equivalent.
*Qualities:**
Architecture\-first thinking
Ability to work with cross\-functionally dependent teams and stakeholder alignment
Migration risk anticipation capability
Delivery acceleration mindset
Validation strategy planning and Defect triage prioritization
Detail\-oriented with focus on data accuracy and reliability
Attention to transformation accuracy
Collaboration \& Delivery Support \- Work closely with Snowflake engineers, QA team and client stakeholders to resolve transformation discrepancies and ensure timely migration delivery