Data Analyst

Were Hiring!Data AnalystToronto ON Montreal TYPE: Permanent Full-TimeHIRING RANGE: $71920 to $89900 REASON FOR HIRING: ReplacementWORK 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 Data Analyst to join our Analytics this role youll 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 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 RESPONSIBILITIESWork 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 quality assurance by creating data quality tests and plans for various reporting and Lakehouse projects that can assist in troubleshooting data discrepancies and pipeline 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 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 YOU WILL BRING / QUALIFICATIONS & EXPERIENCERequired: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 in a quantitative field (e.g. Computer Science Stats Economics Business Analytics) or equivalent To Have:Passion & love for in FrenchCOMPETENCIESCritical Thinking & Problem SolvingEmotionally intelligentCommitment to Continuous LearningProcess OrientedACCESSIBILITY & 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).