Senior Snowflake Developer

Senior Snowflake Developer

Client is a Toronto-based IT consulting boutique that strives for excellence in customer service and delivery in financial services and fintech industry.
They focus on technology advisory services, application development, cloud computing, integration solutions, and enterprise big data and analytics.
With a team of highly knowledgeable business and technical experts, we provide strategic, mission critical solutions to our clients.
Looking for a senior Snowflake Developer who has hands-on experience in gathering business requirements, designing Snowflake solution and data models, and building data pipelines in Snowflake in business analytics projects in the Greater Toronto Area.

Company location: Downtown Toronto,
Hybrid work environment - mix of home, office and client site
Perm / FTE role: Salary: Market rate + benefits and performance bonus

RESPONSIBILITIES
• Understand business requirements for data and information especially in the financial services industry.
• Communicate with business teams to gather data and analytics requirements.
• Design Snowflake data models and data pipelines as per business requirements.
• Ingest data and transform data in Snowflake for batch or near real-time processing using a variety of tools such as Python or SnowSQL.
• Perform data profiling and data quality audit.
• Design and integrate pipelines with Continuous Integration/Delivery framework as needed.
• Develop design and operational documentation for job schedules and data pipelines.
• Produce estimates for data analysis and mapping, design, development, and testing.
• Ensure compliance with business, data, and technical requirements.
• Ensure that client’s enterprise architecture standards, policies, and procedures are followed.

REQUIREMENTS
• Minimum Bachelors degree in Computer Science or Engineering.
• Minimum 8 years experience in Information Technology, participating in complex projects.
• Minimum Bachelors degree in Computer Science.
• Excellent communication skills in both verbal and written.
• Strong knowledge in data analysis, data modeling, database development, data warehousing life cycle and data integration methodologies (ETL, ELT).
• Strong knowledge of Snowflake features and working experiences in developing data integration solutions using Snowflake.
• Strong programming skills in Python and SQL.
• Working knowledge in one of Oracle or Microsoft SQL databases.
• Knowledgeable in both relational and dimensional data modeling (with both Kimball and Inmon approaches).
• Experience in .NET development and UNIX shell scripting.
• Knowledge in data management and Continuous Integration and Delivery (CI/CD) principles.
• Good overall business knowledge in financial industries (i.e. one or more in retail banking, commercial banking, capital markets, wealth management, insurance, pension fund, and fintech).
• Knowledgeable of Azure computing concepts and services.
• Ability to work independently and excel in a team environment.