Data Analyst

SOCAN; Toronto; Hybrid; CAD 71,920 - 89,900; Full time

Benefits offered by this job

35-hour workweek

Sick days

Fitness facility

Pension plan

Health benefits

Flexible options

Job summary

SOCAN is hiring a Data Analyst in Toronto and Montreal to turn raw data into actionable business insights. You will work with data engineers, BI analysts, and leaders to drive key initiatives using modern cloud data stacks. English required, French an asset.

The role emphasizes data quality, KPI management, and creating clear dashboards to communicate findings across the organization. Hybrid work model and comprehensive benefits are offered.

Qualifications

• Strong SQL skills and intermediate Python.
• Experience with Databricks or similar (2+ years).
• Ability to document reporting requirements and business processes.
• Degree in quantitative field or equivalent experience.

Responsibilities

• Work directly with data engineers, BI analysts, and leaders to document reporting requirements and business processes.
• Perform exploratory data analysis to clean, transform, and analyze large datasets in Databricks.
• Support data quality by creating data quality tests and plans for reporting and Lakehouse projects.
• Define and document KPIs with department leaders and analyze KPI fluctuations.
• Collaborate on development of interactive Databricks dashboards and reports for stakeholders.
• Curate semantic layers to power natural language querying for business users.

Skills

SQL

Python

Databricks

Spark

Data analysis

Education

Bachelor's in a quantitative field

Tools

Databricks platform

Job description

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

We’re Hiring!

Data Analyst

Toronto, ON | Montreal, QC

www.socan.com

POSITION TYPE: Permanent Full-Time

HIRING RANGE: $71,920 to $89,900

REASON FOR HIRING: Replacement

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 Data Analyst to join our Analytics department. In this role, you’ll be accountable for turning raw data into actionable business insights through various reports and dashboards, driving improvement in our key organizational initiatives. You must be comfortable working closely with data engineers, BI analysts, and business leaders. The ideal candidate has a solid grasp of data fundamentals and is eager, curious, and possesses a drive for continuous learning and self-improvement, especially with modern cloud data stacks.

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

• Work directly with data engineers, BI analysts, other data analysts, and business leaders to document reporting requirements and understand business processes and how they affect data.
• Perform exploratory data analysis to clean, transform, and analyze large datasets within Databricks to identify trends, anomalies, and opportunities to improve our data.
• Support data quality assurance by creating data quality tests and plans for various reporting and Lakehouse projects that can assist in troubleshooting data discrepancies and pipeline issues.
• Work with each department leader to define and document KPIs.
• Perform root-cause analysis on KPI fluctuations to provide actionable insights to department leaders.
• Collaborate on the continuous development of interactive Databricks AI/BI dashboards and reports, designing and maintaining clear dashboards to communicate findings to various stakeholders.
• Curate and document semantic layers to power natural language querying (Genie) for business users.
• Participate in, and contribute towards daily standup meetings, project planning sessions, and retrospectives.
• Manage, prioritize, and respond to ad hoc requests for data analysis.
  
  

Required

WHAT YOU WILL BRING / QUALIFICATIONS & EXPERIENCE

• Strong analytical and quantitative skills with the ability to work on large data sets, while keeping the big picture in mind.
• Strong SQL skills and intermediate Python. An understanding of Spark and distributed compute environments.
• Experience and proficiency performing data analysis using Databricks or similar technologies (2+ years).
• Strong communicator, with the ability to tackle loosely defined problems with a solution oriented mindset.
• Business writing skills as well as the ability to create technical documentation, communicating clearly for both technical and non-technical audiences.
• Degree in a quantitative field (e.g., Computer Science, Stats, Economics, Business Analytics) or equivalent experience.
  
  

Nice To Have

• Passion & love for music.
• Fluency in French
  
  

COMPETENCIES

• Critical Thinking & Problem Solving
• Emotionally intelligent
• Commitment to Continuous Learning
• Process Oriented
  
  

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 [e-mail] 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/

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. You can also follow us on LinkedIn, Twitter, Instagram, and Facebook (@SOCANmusic/@SOCANmusique).