Jr. Data Engineer

Were Hiring!Junior Data EngineerToronto ON Montreal TYPE: Permanent Full-TimeHIRING RANGE: $71920 to $89900REASON FOR HIRING: New RoleWORK MODEL: HybridLANGUAGE: English French is an assetWHO WE ARESOCAN 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 200000 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 OUR COMMITMENT TO DIVERSITY EQUITY INCLUSION AND ANTI-RACISM 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. Learn more about SOCANs commitment to Inclusion & WORK WITH USMake a difference by supporting and collaborating with a vibrant and creative communityEnjoy many options for workplace flexibility and work-life balanceGet involved in the rapidly changing creative spaceAdvocate for and empower the creative communityTogether well help music creators earn more income and make a livingWHAT WE OFFER35-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 facilityAnnual Performance Incentive bonus (dependent on a personal and company performance)Defined contribution Pension PlanComprehensive health and dental benefits programInclusive and collaborative working environmentABOUT THE ROLESOCAN 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 SOCANs 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 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 QuebecWHAT YOULL DO / KEY RESPONSIBILITIESSupport the development and maintenance of data pipelines in Databricks assisting with data ingestion transformation and loading processesWrite and maintain SQL and Spark code to transform and prepare data for reporting and analytics use casesAssist in building and maintaining structured data layers (e.g. raw refined business-ready datasets) under guidance from senior engineersAssist in ingesting data from external sources including REST APIs and file-based inputsWrite basic API calls and handle JSON data to support data ingestion and transformation workflowsSupport the development of ingestion pipelines by implementing simple extraction parsing and loading logic under guidanceMonitor pipeline execution and data workflows helping identify and resolve data quality issues pipeline failures and performance bottlenecksSupport data validation and reconciliation processes to ensure accuracy and consistency of datasets used in reporting and analyticsAssist with documenting data pipelines datasets and transformation logic to support transparency and maintainabilityCollaborate with Data Analysts to understand reporting requirements and help prepare datasets that support dashboards and analysisSupport Data Scientists by preparing clean well-structured datasets that can be used for forecasting segmentation and modeling use casesFollow 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 environmentsParticipate in team processes such as stand-ups planning sessions and retrospectives contributing to continuous improvement effortsContinuously build knowledge of SOCANs data environment business processes and evolving data platform capabilitiesWHAT YOU WILL BRING / QUALIFICATIONS & EXPERIENCERequired:02 years of experience in data engineering analytics software development or a related fieldWorking knowledge of SQL and basic Python skillsFamiliarity with data concepts such as data transformation relational structures and basic data modeling principlesExposure to cloud data platforms (e.g. Databricks Azure or similar) is an assetBasic understanding of data pipelines ETL/ELT concepts and how data supports reporting and analyticsBasic understanding of REST APIs including how to make API requests and work with JSON data structuresExposure to data ingestion concepts including pulling data from external systems and preparing it for downstream processingStrong attention to detail and ability to work with structured data accurately and consistentlyStrong problem-solving mindset with curiosity and willingness to learn and troubleshoot issuesStrong organizational skills with the ability to manage tasks follow processes and meet deadlinesEffective communication skills with the ability to work collaboratively across technical and business teamsPost-secondary degree in Computer Science Engineering Mathematics or a related field or equivalent practical experienceNice To Have:Passion & love for in FrenchCOMPETENCIESEagerness to learn and develop technical skills in data engineering and modern data platformsStrong attention to detail and commitment to data quality and accuracyAbility to follow structured processes and contribute to well-documented repeatable workflowsCollaborative mindset and willingness to seek guidance and feedbackAccountability and reliability in completing assigned tasksContinuous learning mindset with interest in evolving data technologies and analytics practicesACCESSIBILITY & ACCOMMODATIONSOCAN is committed to providing an inclusive workplace environment that meets the accessibility needs of employees with disabilities. Should you require accommodations please contact us directly at and we will make the necessary accommodations. Applications submitted to this email address will not be EMPLOYMENT OPPORTUNITYSOCAN 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 you dont see yourself fully reflected in every job requirement listed on the posting above we still encourage you to reach out and apply. 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 applyHOW TO APPLYIf youre interested in joining us wed love to hear from you: you for your interest in our company; we will be in touch with those candidates we wish to learn more about SOCAN go . You can also follow us on LinkedIn Twitter Instagram and Facebook (@SOCANmusic/@SOCANmusique).