Data Analyst & Reporting Lead

SOCAN - The Society of Composers, Authors and Music Publishers of Canada • Toronto, ON

2d • CA$84,480 - CA$105,600 • Hybrid

About The Position

SOCAN is seeking a Data Analyst & Reporting Lead to join the Analytics department and play a critical role in advancing enterprise analytics capabilities and enabling data-driven decision-making. You will collaborate closely with data engineers, BI analysts, and business leaders to deliver reporting solutions and actionable insights that support key organizational initiatives. This role combines hands-on analysis and reporting with leadership, governance, and cross-functional influence, serving as a primary lead for analytics and reporting within assigned domains. The Data Analyst Lead will be accountable for delivering reports and dashboards that provide high-impact insights that influence business and operational outcomes, leading analytics workstreams and junior analysts within key initiatives, establishing data quality, KPI, and reporting standards across domains, and driving adoption of SOCAN’s modern data stack (Databricks Lakehouse, dashboards, and semantic layers). The ideal candidate has a strong foundation in data fundamentals, business intelligence, and reporting, and thrives in a dynamic environment. You are curious, proactive, capable of operating independently while guiding others and partnering with senior stakeholders. 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.

Requirements

• 5+ years of experience in data analytics or a related field, with demonstrated ownership of end-to-end analytics or reporting initiatives
• Advanced proficiency in SQL and strong Python skills, including experience working with large-scale datasets in distributed compute environments (e.g., Spark)
• Hands-on experience with modern cloud data platforms (e.g., Databricks or equivalent), including data exploration, transformation, and performance optimization
• Proven ability to design and deliver scalable reporting solutions, including dashboards and data models aligned to business needs
• Strong experience working with complex, ambiguous business problems, with the ability to translate requirements into structured analytical approaches and measurable outcomes
• Demonstrated experience defining and governing KPIs, as well as implementing data quality, validation, and monitoring frameworks
• Experience leading analytics initiatives or mentoring analysts, with the ability to provide technical guidance, enforce standards, and ensure quality of outputs
• Strong collaboration skills, with experience partnering across data engineering, business intelligence, and business teams to deliver integrated data solutions
• Excellent communication and stakeholder management skills, including the ability to present insights and recommendations to senior leadership
• Strong business writing and documentation skills, with the ability to clearly communicate complex technical concepts to both technical and non-technical audiences
• Strong analytical mindset, with the ability to synthesize large datasets, identify trends and anomalies, and drive actionable insights while maintaining a big-picture perspective
• High level of ownership, accountability, and attention to detail, with a focus on delivering accurate, reliable, and scalable data products
• Degree in a quantitative field (e.g., Computer Science, Statistics, Economics, Business Analytics) or equivalent practical experience

Nice To Haves

• Passion & love for music.
• Fluency in French

Responsibilities

• Lead the end-to-end delivery of analytics and reporting initiatives, from requirements definition through to insight generation and executive-level communication
• Serve as the primary analytics partner to business stakeholders, translating strategic priorities into actionable data solutions and influencing decision-making
• Lead, mentor, and provide quality oversight to Data Analysts, while remaining hands-on in delivering complex analytical and reporting outputs
• Manage and prioritize multiple concurrent workstreams, balancing project delivery with ad hoc analysis in a fast-paced environment
• Design and implement scalable reporting and analytics solutions by collaborating with Data Engineering, BI, and business teams to define requirements and align on data models
• Perform advanced analysis on large, complex datasets using modern cloud data platforms, identifying trends, anomalies, and opportunities for improvement
• Lead root-cause analysis of KPI and operational performance issues, delivering clear and actionable recommendations
• Define, standardize, and govern enterprise KPIs, ensuring alignment and consistency across reports, dashboards, and datasets
• Establish and enforce data quality frameworks, validation rules, and monitoring processes to ensure trusted and reliable data assets
• Partner with Data Engineering to enhance data pipelines, resolve discrepancies, and improve overall data integrity
• Own the design and governance of semantic layers and business-facing data models to enable scalable reporting and self-serve analytics
• Lead the development of executive-ready dashboards and reporting assets, ensuring outputs are intuitive, scalable, and aligned to business needs
• Drive adoption of self-serve analytics by enabling stakeholders with accessible, well-documented data products
• Translate complex technical analysis into clear, concise, and actionable insights for both technical and non-technical audiences
• Facilitate alignment across business, analytics, and engineering teams to ensure integrated and effective data solutions
• Establish and promote best practices for analytics development, documentation, reproducibility, and auditability
• Provide ongoing technical support and guidance for reporting solutions to ensure stability, usability, and continuous improvement

Benefits

• Twelve paid sick days annually (including five personal days)
• Access to SOCAN fitness facility – Include only for positions in Toronto
• 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
• 35-hour workweek schedule (possible flexible work options i.e., 4-day work week (position based))

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level