Position: Data Engineer - Snowflake
Purpose of the Position:
To design, develop, and maintain scalable data pipelines and models using Snowflake and DBT, enabling high-quality data analytics and reporting for pharmaceutical operations, regulatory compliance, and research insights.
Location: Infocepts India Location.
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
Work and Technical Experience:
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) skills
- Experience defining data validation and reconciliation frameworks
- Understanding of performance tuning and workload optimisation in Snowflake
- Familiarity with CI/CD and version control (Git/Azure DevOps)
- Experience in driving team through delivery, UAT, & productionisation (Release planning,
Mandatory Skills:
- Experience in migration accelerators or reusable frameworks
- Exposure to data governance and lineage tools
- Knowledge of Terraform or infrastructure automation
- Experience working with distributed or multi-team migration programs
Qualifications:
- 11+ years of experience in data engineering / data warehousing
- 1 to 2 years in cloud data architecture roles
- Bachelor's or Master's degree in Engineering / IT or related field
