Snowflake Lead Developer

Responsibilities

• Create, test, and implement enterprise-level apps with Snowflake
• Design and implement features for identity and access management
• Create authorization frameworks for better access control
• Implement novel query optimization, major security competencies with encryption
• Solve performance issues and scalability issues in the system
• Transaction management with distributed data processing algorithms
• Build, monitor, and optimize ETL and ELT processes with data models
• Understand and implement the latest delivery approaches based on data architecture
• Project documentation and tracking based on understanding user requirements
• Manage documentation of data models, architecture, and maintenance processes
• Continually review and audit data models for enhancement
• Maintenance of ideal data pipeline based on ETL tools
• Coordination with BI experts and analysts for customized data models and integration
• Code updates, new code development, and reverse engineering
• Performance tuning, user acceptance training, application support
• Perform Risk assessment, management, and mitigation plans
• Regular engagement with teams for status reporting and routine activities
• Migration activities from one database to another or on-premises to cloud

Requirements

At least 5 year's experience in enterprise-level Snowflake applications:

• Data ingestion into Snowflake
• Snowflake modeling roles, databases, schemas
• Performance tuning and setting up resource monitors
• SQL performance measuring, query tuning, and database tuning
• Using ETL tools to build data warehouses
• Managing sets of XML, JSON, and CSV from disparate sources

Knowledge of:

• Snowflake warehousing, architecture, processing, administration
• SQL language and cloud-based technologies, data warehousing concepts, data modeling, metadata management
• SQL-based databases like Oracle SQL Server, Teradata, etc.
• Coding in languages like Python, Java, JavaScript
• Root cause analysis of models with solutions