Currently enrolled in a post-secondary co-op program in Computer Science, Software Engineering, Data Science, or a related technical field
Strong foundational knowledge of SQL and Python
Academic or project experience with dbt, Airflow, or Snowflake is highly preferred
Exposure to cloud environments (AWS or GCP) and an understanding of data warehousing concepts
Familiarity with DevOps practices or NoSQL databases (Mongo DB) is considered a definite asset
Simplicity First: You prefer simple, maintainable solutions over over-engineered abstractions
Effective Communicator: You are comfortable asking questions and providing/receiving candid feedback to ensure project success
Incremental Delivery: You understand the value of getting a working version into production quickly and iterating based on feedback
What the job involves
Support the Migration: Assist the engineering team in the migration of data assets from Amazon Redshift to Snowflake, ensuring data integrity and performance
Infrastructure Provisioning: Work closely with lead engineers to provision and configure the Insurance BU data infrastructure, gaining hands-on experience with cloud architecture
Pipeline Development: Build and maintain data pipelines using Airflow and dbt to handle ongoing ad-hoc requests and automate financial data workflows
Data Transformation: Help create clean, modular, and maintainable code by refactoring complex queries into streamlined transformation layers
Cross-functional Collaboration: Partner with both engineering and business teams to understand requirements and deliver data solutions that provide immediate value
