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.