Job Specifications
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.
About the Company
VDart - We are a global, emerging technology staffing solutions provider with expertise in SMAC (Social, Mobile, Analytics & Cloud), Enterprise Resource Planning (Oracle Applications, SAP), Business Intelligence (Hyperion), and Infrastructure services. We work with leading System Integrators in, the private and public sectors. We have deep industry expertise and focus in BFSI, Manufacturing, Energy & Utility, Healthcare and Technology sector. Our scope, knowledge, industry expertise, and global footprint have enabled us to p...
Know more