(Junior) Data Engineer/Scientist

Who we are Artefact is a new generation of a data service provider, specializing in data consulting and data-driven digital marketing, dedicated to transforming data into business impact across the entire value chain of organizations. We are proud to say that we’re enjoying skyrocketing growth. Our broad range of data-driven solutions in data consulting and digital marketing are designed to meet our clients’ specific needs, always conceived with a business-centric approach and delivered with tangible results. Our data-driven services are built upon the deep AI expertise we’ve acquired with our 300+ client base around the globe. We have over 2000 employees across 16 offices who are focused on accelerating digital transformation. Thanks to a unique mix of company assets: state of the art data technologies, lean AI agile methodologies for fast delivery, and cohesive teams of the finest business consultants, data analysts, data scientists, data engineers, and digital experts, all dedicated to bringing extra value to every client. Our Opportunity Responsibilities We are looking for a Jr. Data Engineer to join our dynamic team. This role is ideal for someone with understanding of data engineering and a proven track record of working on data projects in a fast-paced environment.  Key Responsibilities * Design, build, and maintain scalable and robust data pipelines using SQL, Python, Databricks, Snowflake, Azure Data Factory, AWS Glue, Apache Airflow and Pyspark. * Lead the integration of complex data systems and ensure consistency and accuracy of data across multiple platforms. * Implement continuous integration and continuous deployment (CI/CD) practices for data pipelines to improve efficiency and quality of data processing. * Work closely with data architects, analysts, and other stakeholders to understand business requirements and translate them into technical implementations. * Oversee and manage a team of data engineers, providing guidance and mentorship to ensure high-quality project deliverables. * Develop and enforce best practices in data governance, security, and compliance within the organization. * Optimize data retrieval and develop dashboards and reports for business teams. * Continuously evaluate new technologies and tools to enhance the capabilities of the data engineering function. Qualifications * Bachelor's or Master’s degree in Computer Science, Engineering, or a related field. * 2+ years of industry experience in data engineering with a strong technical proficiency in SQL, Python, and big data technologies. * Experience with cloud services such as Azure Data Factory and AWS Glue. * Excellent problem-solving skills and the ability to work under tight deadlines. * Strong communication and interpersonal skills. Preferred Qualifications: * * Certifications in Azure, AWS, or similar technologies. * Certifications in Databricks, Snowflake or similar technologies * Experience in the leading large scale data engineering projects Why you should join us We are united by our values and strengthened by our hybrid expertise. * There is always a way: We're from the breed of does, of diggers, of makers. Because ideas are valuable only if executed. * Client trust is won on the field: Addressing client needs flows better hands on at their side. * If not used, it is useless: Our love for technology translates into a steep desire for adoption, true brilliance is about impact. * If not shared, our work is not done: Sharing knowledge is the best way to button up a mission, benefitting clients and colleagues. * We learn everyday: Tech is a land where everything move at the speed of light, you better be ready to challenge yourself.

We’re Hiring! Junior Data Engineer Toronto, ON | Montreal, QC www.socan.com [https://www.socan.com] POSITION TYPE:              Permanent Full-Time HIRING RANGE:               $71,920 to $89,900 REASON FOR HIRING:    New Role WORK MODEL:                Hybrid LANGUAGE:                     English, French is an asset WHO WE ARE 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    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 SOCAN’s commitment to Inclusion & Anti-Racism.    WHY WORK WITH US? * Make a difference by supporting and collaborating with a vibrant and creative community * Enjoy many options for workplace flexibility and work-life balance * Get involved in the rapidly changing creative space * Advocate for and empower the creative community * Together, we’ll help music creators earn more income and make a living WHAT WE OFFER * 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 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 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 WHAT YOU’LL DO / KEY 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  WHAT YOU WILL BRING / QUALIFICATIONS & EXPERIENCE Required: * 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 * Exposure to cloud data platforms (e.g., Databricks, Azure, or similar) is an asset * 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 Have: * Passion & love for music. * Fluency in French COMPETENCIES * Eagerness to learn and develop technical skills in data engineering and modern data platforms  * Strong attention to detail and commitment to data quality and accuracy  * Ability to follow structured processes and contribute to well-documented, repeatable workflows  * Collaborative mindset and willingness to seek guidance and feedback  * Accountability and reliability in completing assigned tasks  * Continuous learning mindset, with interest in evolving data technologies and analytics practices ACCESSIBILITY & ACCOMMODATION SOCAN 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 hr@socan.com and we will make the necessary accommodations. Applications submitted to this email address will not be accepted. EQUAL EMPLOYMENT OPPORTUNITY 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. If you don’t 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 apply HOW TO APPLY If you’re interested in joining us, we’d love to hear from you: http://www.socan.com/careers/ [http://www.socan.com/careers/] Thank you for your interest in our company; we will be in touch with those candidates we wish to interview. To learn more about SOCAN, go to www.socan.com [https://www.socan.com]. You can also follow us on LinkedIn, Twitter, Instagram, and Facebook (@SOCANmusic/@SOCANmusique).