Jr. Data Engineer

SOCAN - The Society of Composers, Authors and Music Publishers of Canada • Toronto, ON

1d • CA$71,920 - CA$89,900 • Hybrid

About The Position

SOCAN is seeking a Junior Data Engineer to support the development and maintenance of data pipelines and curated datasets that power reporting, analytics, and future advanced analytics use cases. This role is ideal for someone who is eager to build foundational data engineering skills in a modern cloud environment. Working closely with Data Engineers, Data Analysts, and Data Scientists, the Junior Data Engineer will contribute to building reliable, well-structured data assets within SOCAN’s analytics platform. The individual will contribute to core data engineering practices, including data transformation, pipeline support, data quality validation, and documentation, with exposure to how data supports analytics, reporting, and AI-driven use cases. The knowledge of English is required for this position as the position requires to interact on a constant and regular basis with English-speaking stakeholders outside of Quebec.

Requirements

• 0–2 years of experience in data engineering, analytics, software development, or a related field
• Working knowledge of SQL and basic Python skills
• Familiarity with data concepts such as data transformation, relational structures, and basic data modeling principles
• Basic understanding of data pipelines, ETL/ELT concepts, and how data supports reporting and analytics
• Basic understanding of REST APIs, including how to make API requests and work with JSON data structures
• Exposure to data ingestion concepts, including pulling data from external systems and preparing it for downstream processing
• Strong attention to detail and ability to work with structured data accurately and consistently
• Strong problem-solving mindset, with curiosity and willingness to learn and troubleshoot issues
• Strong organizational skills, with the ability to manage tasks, follow processes, and meet deadlines
• Effective communication skills, with the ability to work collaboratively across technical and business teams
• Post-secondary degree in Computer Science, Engineering, Mathematics, or a related field, or equivalent practical experience

Nice To Haves

• Exposure to cloud data platforms (e.g., Databricks, Azure, or similar) is an asset
• Passion & love for music.
• Fluency in French

Responsibilities

• Support the development and maintenance of data pipelines in Databricks, assisting with data ingestion, transformation, and loading processes
• Write and maintain SQL and Spark code to transform and prepare data for reporting and analytics use cases
• Assist in building and maintaining structured data layers (e.g., raw, refined, business-ready datasets) under guidance from senior engineers
• Assist in ingesting data from external sources, including REST APIs and file-based inputs
• Write basic API calls and handle JSON data to support data ingestion and transformation workflows
• Support the development of ingestion pipelines by implementing simple extraction, parsing, and loading logic under guidance
• Monitor pipeline execution and data workflows, helping identify and resolve data quality issues, pipeline failures, and performance bottlenecks
• Support data validation and reconciliation processes to ensure accuracy and consistency of datasets used in reporting and analytics
• Assist with documenting data pipelines, datasets, and transformation logic to support transparency and maintainability
• Collaborate with Data Analysts to understand reporting requirements and help prepare datasets that support dashboards and analysis
• Support Data Scientists by preparing clean, well-structured datasets that can be used for forecasting, segmentation, and modeling use cases
• Follow established engineering standards and best practices for coding, documentation, data handling, version control, and deployment practices, including contributing to Git-based workflows and supporting pipeline promotion across development and production environments
• Participate in team processes such as stand-ups, planning sessions, and retrospectives, contributing to continuous improvement efforts
• Continuously build knowledge of SOCAN’s data environment, business processes, and evolving data platform capabilities

Benefits

• Twelve paid sick days annually (including five personal days)
• Access to SOCAN fitness facility
• Annual Performance Incentive bonus (dependent on a personal and company performance)
• Defined contribution Pension Plan
• Comprehensive, health and dental benefits program

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Associate degree