remote
Senior Software Engineer - Snowflake - TGH Software Solutions Private Limited
Software Engineer
Seasoned engineer to lead Snowflake implementations, optimize performance, and build end‑to‑end data pipelines using dbt, Azure Data Factory, and CI/CD practices for enterprise data transformation projects.
About the role
Key Responsibilities
- Design, develop, and deploy Snowflake solutions for large‑scale data warehousing projects.
- Implement and maintain data models (Star Schema, SCD, Facts & Dimensions) and optimize query performance.
- Build and orchestrate data ingestion pipelines using Azure Data Factory, Airflow, and AWS Glue.
- Leverage dbt for data transformation, version control, and automated testing.
- Collaborate with DevOps to integrate CI/CD pipelines via GitHub and Azure DevOps.
- Provide technical guidance and mentorship to junior team members.
Requirements
- 4–8 years of experience in Snowflake data engineering.
- Proven track record of at least two end‑to‑end Snowflake implementation projects.
- Strong expertise in Advanced SQL and performance tuning.
- Hands‑on experience with dbt, Azure Data Factory, and CI/CD workflows.
- Excellent problem‑solving skills and ability to work independently in a contract environment.