Tech Lead

Job Description: Snowflake Data Engineer Role Overview: We are looking for experienced and hands on Snowflake Data Engineers who have strong expertise in SQL, DBT, and Python, with a solid understanding of data modeling, ELT pipelines, and performance optimization. Candidates with exposure to real time data pipelines and streaming analytics will be preferred. Key Responsibilities: • Design, develop, and maintain data pipelines and ELT workflows in Snowflake using DBT, Python, and other tools. • Implement and optimize data models, Snowflake schemas, and SQL transformations for scalable analytics solutions. • Develop and manage user defined functions (UDFs), stored procedures, and SnowSQL scripts for automation and advanced data processing. • Integrate data from multiple sources (e.g., Oracle, Teradata, APIs, streaming platforms) into Snowflake with high performance and reliability. • Optimize query performance, storage usage, and compute resources in Snowflake. • Implement data quality, monitoring, and governance best practices. • Collaborate with cross functional teams including Data Analysts, Architects, and BI developers to deliver robust end to end data solutions. Required Skills: • 4'¿10 years of overall experience in Data Engineering. • Strong hands on experience in Snowflake '¿ including data load, schema design, performance tuning, and SnowSQL scripting. • Strong programming experience in Python for data ingestion, transformation, and automation. • Proficiency in DBT (Data Build Tool) for modeling, transformations, and workflow orchestration. • Excellent command over SQL (complex queries, optimization, window functions, etc.). • Experience working with large scale data sets and performance optimization techniques. Good to Have: • Exposure to real time data ingestion frameworks (Kafka, Kinesis, Spark Streaming, etc.) and streaming analytics. • Experience with ETL/ELT tools (Informatica, Talend, Airflow, etc.). • Understanding of data warehousing best practices and cloud platforms (AWS, Azure, GCP). • Knowledge of JavaScript for Snowflake stored procedures. Soft Skills: • Strong problem solving and analytical mindset. • Excellent communication and collaboration skills. • Ability to work in a fast paced, customer focused environment.