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 (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 or advanced analytics certification required (Master’s degree is a plus)
- Advanced proficiency in SQL, with experience designing complex queries, optimizing performance, and ensuring data integrity
- 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 in cross functional teams
- Excellent communication skills with the ability to clearly articulate technical insights to non-technical stakeholders
- Willingness to adapt and learn new technologies and programming languages as required
- Experience with dashboarding tools is a plus (i.e. Sigma)
Pay Scale
- $110,000 - $130,000 per CAD year
- The final compensation within this range will be determined based on the candidate’s experience, skills, and overall fit for the role.