Who you are

• 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