Senior Developer responsible for developing and supporting AI platform components at FinTech. Collaborating with multidisciplinary teams and optimizing system performance.
About the role
- Snowflake Developer working on data engineering and deliverables at Medavie. Collaborating to design, build, and maintain data pipelines and architectures within the Snowflake Cloud Data Platform.
Responsibilities
- Ingest Bronze data from ADLS Gen2 into Snowflake and build Silver-layer transformation pipelines: cleansing, deduplication, conforming, and applying agreed business rules
- Design and build Gold-layer data models optimised for Power BI consumption (star schema or as agreed with each business team)
- Implement Snowflake objects including Stages, Snowpipe or scheduled Tasks, Streams, Dynamic Tables, and role/privilege structures for each business team’s workspace
- Develop dbt (or agreed transformation framework) models with appropriate testing, documentation, and lineage
- Collaborate with Power BI developers or business team members to validate semantic layer requirements and ensure Gold models support required reports and dashboards
- Work in a paired or shadowing model with business team data leads, building Snowflake capability so teams can maintain and extend pipelines independently
- Produce handover documentation and conduct structured knowledge-transfer sessions for each stream before contract conclusion
Requirements
- A clear understanding of the software development life cycle (SDLC)
- Experience Building ETL/ELT pipelines to move data into and within Snowflake using Snowpipe, Streams, and Tasks
- Experience designing efficient schema structures and transforming raw data into usable formats for analytics using SQL or Snowpark (Python/Scala)
- Experience with monitoring and optimizing query performance and managing virtual warehouse usage to control costs
- Experience configuring data access controls, encryption, and ensuring compliance with security standards
- Experience managing data migration, cloning, and sharing capabilities within the Snowflake environment
- Experience gathering functional, non-functional, and transitional requirements
- Able to translate and communicate complex business logic requirements
- Experience designing software solution specifications
- Experience supporting Project Management planning, providing estimates and reporting on progress, issues and risks
- Able to manage multiple priorities and activities
- Able to provide supervision, leadership, mentorship and coaching to assigned resources
- Able to plan and co-ordinate simple to complex projects and activities with team members and any stakeholder both internal to Medavie Blue Cross and external clients
- University degree or college diploma in Computer Science or similar program
- Strong Snowflake hands-on experience: data modelling, Snowpipe, Tasks, Streams, Dynamic Tables, RBAC, and query optimization
- Proficiency with dbt Core or dbt Cloud for transformation; experience writing and testing dbt models at scale
- Understanding of how Snowflake integrates with Azure (storage integration, Private Link, Entra ID)
Benefits
- Comprehensive health and dental plan that is 100% employer paid effective on your first day
- Emphasis on work life balance, providing wellness benefits, health resources and fitness center discounts
- 100% employer-matched Defined Contribution Pension Plan
- Annual Incentive Bonus which recognizes your contribution to our success
- Gifted week of vacation in your first year and optional Vacation Purchase Program
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Director of Engineering overseeing Analytics & Data Management programs for marquee clients in Sports & Gaming. Ensuring delivery excellence, stakeholder management, team leadership, and account growth.
LP
Senior Administrative Assistant
LinkedIn Recruiter Post
Senior Administrative Assistant needed for Government of Alberta. Duties include contract admin, procurement, records management, and office support.
LP
Lead Software Engineer – Cryptographic Systems
LinkedIn Recruiter Post
Amyantek is seeking a Lead Software Engineer to join the OpenText Voltage SecureData team building enterprise - grade cryptographic solutions.
LP
Software Engineer Lead / Manager (Full Stack) |
LinkedIn Recruiter Post
Hiring a Software Engineer Lead / Manager (Full Stack) for a Financial Services firm in Toronto. Lead teams and build enterprise apps with Java, Angular, and microservices.
LP
Lead-Delivery Lead
LinkedIn Recruiter Post
J&M Group seeks a Lead - Delivery Lead in Toronto, ON for a contract role with 15+ years of banking and production support experience.
LP
Sr. Full Stack Developers
LinkedIn Recruiter Post
Senior Full Stack Developers needed for digital transformation projects. Must reside in Canada. Email resume to [email protected].
LP
CRM Lead
LinkedIn Recruiter Post
Hiring a CRM Lead with 10+ years SAP CRM experience, SAP IS - U CRM, and utilities background. Hybrid role in Markham, ON.
Developer creating high - quality software solutions for Financeit's financing platform. Collaborating with cross - functional teams to deliver and improve code for retail and home improvement sectors.
Director of Engineering leading Azure modernization initiatives at Manulife. Overseeing cloud migration and operational excellence for Azure services with a focus on collaboration and innovation.