What are the responsibilities and job description for the Snowflake Lead Developer position at Diligent Tec, Inc?
Job Title: Snowflake Lead Developer
Location: Chicago IL Hybrid
Job Type: Contract
Job Summary:
We are seeking a highly skilled and experienced Snowflake Lead Developer to join our team. The ideal candidate will possess a deep understanding of Snowflake Data Warehouse architecture and development and have a strong background in Python programming for data integration and automation. This role involves leading the design, development, and optimization of data pipelines, ensuring the integrity and scalability of our data systems.
Key Responsibilities:
Lead the design, development, and implementation of scalable and secure Snowflake data warehouse solutions.
Collaborate with stakeholders to understand business requirements and translate them into technical solutions.
Develop, optimize, and maintain ETL/ELT processes and data pipelines using Python.
Build and maintain Snowflake database objects, including schemas, tables, views, and stored procedures.
Write and optimize advanced SQL queries for data analysis and transformation.
Ensure performance optimization of Snowflake queries and data models.
Implement data security, governance, and best practices for Snowflake.
Guide and mentor junior developers, ensuring adherence to coding standards and best practices.
Integrate Snowflake with external data sources and applications using APIs and Python-based tools.
Monitor and troubleshoot data pipeline issues, ensuring data accuracy and reliability.
Stay updated with the latest features of Snowflake and emerging trends in cloud-based data warehousing and analytics.
