Snowflake Data Engineer

Job Title : Snowflake Data Engineer (Contract) Location : Bangalore, Chennai, Hyderabad, Pune, Coimbatore, India Experience : 7 - 10 Years Mode : Contract (6 Months) Required Skillset : Snowflake & DBT Responsibilities : - Design, develop, and maintain robust and scalable data pipelines and ETL/ELT processes within the Snowflake data warehouse. - Utilize DBT (Data Build Tool) extensively for data transformations, data modeling, testing, and documentation within the Snowflake environment. - Write and optimize complex SQL queries within Snowflake to extract, transform, and load data. - Implement and maintain data quality checks and validation processes within Snowflake and DBT. - Collaborate with data scientists, analysts, and other stakeholders to understand their data requirements and provide efficient data solutions. - Monitor and troubleshoot data pipeline performance and resolve any data-related issues within the Snowflake environment. - Implement and enforce data governance policies and best practices within the Snowflake platform. - Optimize Snowflake performance for cost-effectiveness and efficiency. - Create and maintain comprehensive technical documentation for data pipelines, transformations, and data models within Snowflake and DBT. - Adhere to best practices for Snowflake and DBT development, including version control and code management. - Participate in code reviews and ensure code quality and adherence to standards. Required Skillset : Snowflake : Extensive hands-on experience (7 years) in designing, developing, and managing data solutions on the Snowflake Data Cloud platform. This includes : - Data loading and unloading techniques (Snowpipe, COPY INTO). - Writing and optimizing complex SQL queries within Snowflake. - Performance tuning and optimization of Snowflake queries and workloads. - Understanding of Snowflake architecture, security features, and data sharing capabilities. - Experience with Snowflake scripting and stored procedures. DBT (Data Build Tool) : Strong proficiency (3 years) in using DBT for : - Building and managing data transformations within Snowflake. - Implementing data modeling using Jinja templating. - Writing and executing data quality tests. - Generating documentation for data models and transformations. - Managing DBT projects and deployments. SQL : Excellent proficiency in writing complex and efficient SQL queries for data manipulation, transformation, and analysis. Data Warehousing Concepts : Deep understanding of data warehousing principles, dimensional modeling (Star Schema, Snowflake Schema), and ETL/ELT methodologies. Data Quality and Governance : Experience in implementing data quality checks, validation rules, and data governance policies. Problem-Solving : Strong analytical and problem-solving skills with the ability to troubleshoot data-related issues effectively. Communication : Good verbal and written communication skills to collaborate effectively with team members and stakeholders. Good to Have Skills : - Familiarity with Python for scripting and automation tasks related to data pipelines and Snowflake. - Experience with cloud platforms such as AWS, Azure, or GCP and their data integration services. - Experience with other data integration and ETL tools. - Knowledge of data visualisation tools (e.g., Tableau, Power BI). - Experience with version control systems (e.g., Git). - Snowflake certifications. - Experience working in an Agile development environment. Qualifications : - Bachelor's degree in Computer Science, Engineering, or a related field. - Minimum of 7 years of experience as a Data Engineer with a strong focus on Snowflake and DBT. - Proven experience in designing and implementing data solutions on the Snowflake platform. - Significant hands-on experience with DBT for data transformations and modeling. - Ability to work independently and as part of a collaborative team. - Must be available to work on a 6-month contract. (ref:hirist.tech)

Location: in, IN

Posted Date: 4/14/2025