About the Role
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 eager to build foundational data engineering skills in a modern cloud environment, contributing to reliable, well-structured data assets within SOCAN’s analytics platform.
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.
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.
Skills
- SQL
- Spark
- Python
- REST APIs
- JSON
- Databricks
- Git
Location
- Toronto, ON
- Montreal, QC
Work Type
- Permanent Full-Time
- Hybrid
Experience Level
- Junior
Education Level
- Post-secondary degree in Computer Science, Engineering, Mathematics, or a related field, or equivalent practical experience.
Salary/Compensations
- $71,920 to $89,900
Benefits
- 35-hour workweek schedule (possible flexible work options i.e., 4-day work week (position based))
- 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
- Inclusive and collaborative working environment
About the Company
- SOCAN is a not-for-profit copyright collective dedicated to ensuring music creators and publishers receive what they have rightfully earned for the use of their work.
- SOCAN supports and represents nearly 200,000 songwriters, composers, and music publishers.
- Through licensing, global royalty collection and advocacy, we help creators to keep making the music that entertains, moves, and inspires us.
Equal Opportunity
- SOCAN thrives with a variety of viewpoints, identities, and backgrounds, and we are committed to anti-racism. Everyone is welcome to apply for our wide range of roles, regardless of gender identity, gender expression, ethnicity, race, age, culture, sexual orientation, religious belief, or physical ability.
- SOCAN is an Equal Opportunity Employer. Hiring and other employment decisions at SOCAN are made without regard to race, colour, religion, sex, ancestry, national origin, ethnic origin, age, disability, citizenship, veteran status, sexual orientation, record of offences, marital status, family status, or any other characteristic protected by federal, provincial, or local law, regulation, or ordinance.
- Research has shown underrepresented groups often only apply when they feel 100% qualified. We are committed to creating a more equitable, inclusive, and diverse company and we strongly encourage applicants of all genders, ages, ethnicities, cultures, abilities, sexual orientations, and life experiences to apply.
