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- 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
Familiarity with DevOps practices or NoSQL databases (Mongo DB) is considered a definite asset
Exposure to cloud environments (AWS or GCP) and an understanding of data warehousing concepts
Academic or project experience with dbt, Airflow, or Snowflake is highly preferred
Simplicity First: You prefer simple, maintainable solutions over over-engineered abstractions
Incremental Delivery: You understand the value of getting a working version into production quickly and iterating based on feedback
Effective Communicator: You are comfortable asking questions and providing/receiving candid feedback to ensure project success
