Role: Snowflake Sr. Developer with Alation experience
Location: Mississauga, ON
Contract
Role Overview:
We are seeking a highly skilled Senior Snowflake Developer to join our team for a dual role in application support and development. The ideal candidate will have extensive experience in Snowflake development, hands-on experience with Alation Data Catalog and Data Products Discovery, including Data Products Catalog/Contract and Data Products Access Details & Process, a strong understanding of Finance Data Layer, Data Marts, and Data Warehousing concepts. This role requires excellent communication skills and proven experience in client-facing engagements.
Key Responsibilities
• Lead Snowflake operations and development efforts, ensuring alignment with onshore and offshore teams.
• Manage Snowflake accounts, roles, and permissions following best practices.
• Implement and manage Alation Data Catalog for metadata governance, data product discovery, and contract management.
• Drive end-to-end technical delivery, ensuring scalable and secure solutions across cloud and data platforms.
• Monitor and optimize compute resources, storage usage, and query performance.
• Implement and maintain security policies, data masking, and compliance standards.
• Design and develop scalable data pipelines using Snowflake features (Streams, Tasks, Procedures).
• Optimize SQL queries and data models for performance and cost efficiency.
• Maintain detailed documentation for processes, configurations, and best practices.
• Provide architectural guidance, mentor engineering teams, and enforce best practices in coding, performance, and DevOps.
• Collaborate with cross-functional teams to gather requirements and deliver scalable solutions.
• Work closely with clients to understand business needs and provide technical guidance.
• Ensure compliance with data security and privacy standards.
• Provide L2/L3 support for Snowflake environments, ensuring high availability and quick resolution of incidents.
Technical Expertise
• Good hands-on experience in Snowflake development and administration
• Experience with Alation Data Catalog, including Data Products Discovery, Catalog/Contract, and Access Details & Process.
• Good understanding of Methods for achieving data quality within Snowflake
• Deep understanding of Snowflake architecture, virtual warehouses, and resource monitors.
• Proficiency in Snowflake-specific features like Time Travel, Cloning, Streams, Tasks, Stored Procedures, and Data Sharing.
• Advanced SQL skills for complex queries and performance tuning.
• Experience with query profiling, caching strategies, and cost optimization.
• Familiarity with data ingestion from APIs, flat files, and streaming sources.
• Integration with cloud platforms (AWS S3, Azure Blob, GCP Storage).
• Expertise in role-based access control, data masking, and encryption.
• Experience with CI/CD pipelines for data solutions.
• Familiarity with scripting languages (Python, Shell) for automation.
Team Lead Skills
• Proven ability to lead and manage larger teams in different GEO regions.
• Should have a clear understanding and working experience in SDLC, CI/CD, Agile & Sprint programs.
• Ability to Co-ordination with Application and Platform teams, Hyper-Care support, Performance optimization, Unit Test & Integration test support
• Mentor and support other colleagues and L2 team for L3 Technical delivery
• Managing services SLAs like availability (proactive monitoring) and incident resolutions as per SLAs
• Strong client-facing role at the customer location or remotely.
Required Skills & Experience:
• 5+ years of hands-on experience in Snowflake development and administration.
• Preferred Snowflake certifications and expertise with ETL\ELT tools (dbt, Informatica, Talend, Matillion).
• Experience with Alation Data Catalog, including Data Products Discovery, Catalog/Contract, and Access Details & Process.
• Strong knowledge of SQL, ETL/ELT processes, and data modeling for cloud data platforms.
• Expertise in Finance Data Layer, Data Mart design, and Data Warehousing principles.
• Familiarity with tools like DLUX for ELT automation and integration with Snowflake (preferred).
• Excellent problem-solving skills and ability to work in a fast-paced environment.
• Strong communication skills with proven client-facing experience.
Nice-to-Have:
• Experience with AWS/Azure cloud services.
• Knowledge of data governance frameworks and performance optimization in Snowflake.
• Exposure to reporting tools like Power BI ,Tableau.