Senior Analytics Engineer

Job Summary

The Senior Analytics Engineer will be part of our Analytics & Insights team and partner closely with stakeholders and internal data teams to translate business needs into scalable analytics solutions. The role will analyze & integrate data from multiple datasets, write and optimize SQL for analytics & reporting, own end-to-end analytics deliverables, and recommend data and reporting improvements.

Responsibilities

• Partner closely with Finance/Music Ops/Acquisitions, and other business stakeholders to understand reporting needs, data gaps, and analytical requirements
• Collaborate with internal data teams to translate business questions into scalable, well-modeled analytics ready data solutions
• Develop, optimize, and maintain complex SQL queries and reporting tables, including recommending improvements to existing SQL data models
• Analyze & integrate data from disparate data sets to develop niche reporting tables and generate meaningful insights
• Apply software engineering best practices to analytics code (ex: version control, testing, continuous integration)
• Participate in code reviews, optimize SQL for performance (including Sigma-specific optimization), maintain data documentation & definitions.
• Other duties as assigned

Qualifications

• 5+ years of experience in the analytics domain as an analyst/data engineer/data or decision scientist or equivalent
• Bachelor’s degree (master’s degree would be a plus)
• Strong proficiency in SQL
• Demonstrated ability to navigate ambiguous requirements, analyze and integrate datasets and build targeted reporting tables
• Demonstrated expertise in building and owning the analytics semantic layer, including metric definitions, data models, and business logic
• Ability to work independently and collaboratively within a team
• Strong communication and collaboration abilities
• Willingness to adapt and learn new technologies and programming languages as required
• Experience with dashboarding tools is a plus (Sigma)

Pay Scale

• $110,000 - 130,000 (CAD) per year
• The final compensation within this range will be determined based on the candidate’s experience, skills, and overall fit for the role.