Technical Lead

• Hands-on experience with Snowflake DB
• Ability to handle all DML , DDL , Procedure creation , performance tuning etc is expected.
• Proficient in performing root cause analysis of existing models and proposing a solution
• Identify opportunities to improve, speed up and innovate the data models
• Strong scripting experience with Python scripting language.
• Should be strong in NumPy , Pandas for data Processing
• Ability to build data processes, pipelines, workflows, dependencies, data structures and data transformations
• Experience in working with ETL tools
• Familiar with Snowflake architecture and warehouse implementation and management
• Working experience of cloud computing architecture
• Should be able to write data processing script , connect to source db , join multiple tables and handle data in Python.
• Should be familiar with all data processing libraries.
• Understanding of Deployment process , GIT Tool is expected.
• Strong English communication skills.
• Strong analytical and interpersonal skills
• Ability to prioritize and work on your own

Roles and Responsibilities

• Developing and maintaining data architecture and data models
• Create standardized procedures for data flows using python scripting
• Conduct efficient data integration with other third-party tools and Snowflake
• Write Python scripts embedding the SQL queries for data processing.
• Create and maintain the documentation of the architecture, data models and maintenance activities
• Review and audit existing data models and solutions and propose better processes
• Perform tuning, testing and problem analysis
• Identify, design, implement and deploy new Snowflake based data architecture
• Automate manual processes and optimize the data flows