Snowflake with Alation experience

Mississauga - Canada

Monthly Salary: Not Disclosed

Posted on: 7 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Title: Snowflake with Alation experience

Job Location: Mississauga ON / Vancouver BC

Mode: Contract

Job Description:
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 ETLELT 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.

Job Title: Snowflake with Alation experience Job Location: Mississauga ON / Vancouver BC Mode: Contract Job Description: 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...