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.