<p><p><b>Job Title : Data Engineer DBT | SQL | Snowflake</b><br/><br/><b>Experience : 4+ Years</b><br/><br/><b>Location : Pune / Bangalore / Hyderabad (Hybrid/On-site as per project needs)</b><br/><br/><b>Employment Type : Full-time</b><br/><br/><b>About the Role : </b><br/><br/>We are seeking a skilled Data Engineer with proven expertise in DBT, advanced SQL, and Snowflake.
The candidate will play a critical role in designing, building, and optimizing scalable data pipelines while ensuring data integrity, performance, and availability.
You will work closely with analytics, business, and engineering teams to translate business needs into reliable data solutions.<br/><br/><b>Key Responsibilities : </b><br/><br/>- Design and develop scalable ETL/ELT pipelines using DBT to transform raw data into analytics-ready datasets.<br/><br/></p><p>- Write efficient, optimized, and complex SQL queries for data modeling, reporting, and troubleshooting.<br/><br/></p><p>- Develop and maintain Snowflake data warehouses, ensuring proper schema design, partitioning, and clustering.<br/><br/></p><p>- Collaborate with data analysts and business stakeholders to understand reporting/analytics needs and provide high-quality data solutions.<br/><br/></p><p>- Implement best practices for data governance, testing, and documentation within DBT and Snowflake.<br/><br/></p><p>- Monitor pipeline performance, troubleshoot issues, and drive continuous improvements in data processing efficiency.<br/><br/></p><p>- Work with cross-functional teams to ensure data security, quality, and reliability across all environments.<br/><br/><b>Required Skills & Qualifications : </b><br/><br/>- 4+ years of hands-on experience in data engineering.<br/><br/></p><p>- Strong expertise in DBT (Data Build Tool) for transformations, testing, and modular pipeline design.<br/><br/></p><p>- Proficiency in advanced SQL (window functions, CTEs, query optimization, performance tuning).<br/><br/></p><p>- Practical experience with Snowflake (warehousing, schema design, security, performance tuning).<br/><br/></p><p>- Solid understanding of data modeling techniques (star, snowflake schemas, facts/dimensions).<br/><br/></p><p>- Knowledge of ETL/ELT concepts, CI/CD for data pipelines, and version control (Git).<br/><br/></p><p>- Experience with cloud data ecosystems (Azure/AWS/GCP) is a plus.<br/><br/><b>Good to Have : </b><br/><br/>- Familiarity with orchestration tools like Airflow or DBT Cloud.<br/><br/></p><p>- Exposure to data visualization/BI tools (Power BI, Looker, Tableau).<br/><br/></p><p>- Experience working in agile teams and delivering in a fast-paced environment.<br/><br/><b>Why Join Us?</b><br/><br/>- Opportunity to work with modern cloud-first data stacks.<br/><br/></p><p>- Collaborative and innovative team culture.<br/><br/></p><p>- Growth-oriented role with exposure to advanced data engineering practices.<br/></p><br/></p> (ref:hirist.tech)