Snowflake Sr. Developer with Alation

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.