Tech Lead - Snowflake + DBT + SQL + Python
Tech Mahindra View all jobs
- Hyderabad, Telangana
- Permanent
- Full-time
- Data Pipeline Development
- Design and implement ETL/ELT workflows using dbt and SQL.
- Develop efficient data models in Snowflake to support analytics and reporting.
- Optimize queries and transformations for performance and cost efficiency.
- Data Management & Governance
- Ensure data quality, consistency, and lineage across pipelines.
- Implement role based access controls and security best practices in Snowflake.
- Collaborate on data governance initiatives to maintain trusted datasets.
- Integration & Collaboration
- Integrate Snowflake with BI tools (Looker, Tableau, Power BI).
- Partner with analysts, data scientists, and business stakeholders to deliver reliable datasets.
- Support migration projects from legacy systems to Snowflake.
- Automation & Operations
- Automate workflows using dbt Cloud, Airflow, or similar orchestration tools.
- Monitor and troubleshoot data pipelines, ensuring high availability.
- Contribute to CI/CD practices for data engineering projects.
- Strong hands on experience with Snowflake (data modeling, performance tuning, security).
- Proficiency in dbt (data transformations, testing, documentation).
- Advanced SQL skills for complex queries and optimization.
- Familiarity with cloud platforms (AWS, Azure, or GCP).
- Experience with version control (Git) and workflow orchestration tools (Airflow, Prefect).
- Knowledge of BI/analytics tools (Looker, Tableau, Power BI).
- Relevant certifications (e.g., Snowflake SnowPro Core, dbt Fundamentals) preferred.