Senior Analytics Engineer

Create Music Group; Remote; CAD 110,000 - 130,000; Full time

Job summary

A leading music and entertainment company is seeking a Senior Analytics Engineer to join their Analytics & Insights team remotely in Canada. The role involves analyzing data, optimizing SQL queries, and collaborating with stakeholders to deliver insightful analytics solutions. Candidates should have over 5 years of experience in analytics, a bachelor's degree, and strong SQL proficiency. Compensation ranges between $110,000 and $130,000 CAD annually based on experience and skills.

Qualifications

• 5+ years of experience in the analytics domain as an analyst/data engineer/data scientist.
• Advanced proficiency in SQL for designing and optimizing queries.
• Excellent communication skills to articulate insights to non-technical stakeholders.

Responsibilities

• Partner with stakeholders to understand reporting needs and data gaps.
• Develop and maintain complex SQL queries and reporting tables.
• Analyze data from various datasets to generate insights.
• Apply software engineering best practices to analytics code.
• Participate in code reviews and optimize SQL for performance.

Skills

SQL

Data analysis

Collaboration

Data visualization

Communication

Education

Bachelor’s degree or advanced analytics certification

Master’s degree

Tools

Dashboarding tools (Sigma)

Job description

Established in 2015, Create Music Group is a leading music and entertainment company. The company operates as a record label, distribution company, and entertainment network which generates over 15 billion music streams each month on DSP’s. Named #2 on the Inc 5000 Fastest Growth Companies in America in 2020, the company has grown exponentially by leveraging its owned IP with its media and technology platform. The company works with superstar artists, major and independent record labels, and global media brands. It operates a number of companies including Label Engine, one of the largest independent music distribution platforms in the world, with over 75,000 artists and 5,000 label clients; and Flighthouse, a digital entertainment brand focused on Gen Z, which has more than 300 million followers across social media. Create Music Group is based in Hollywood, CA and has 400 employees worldwide.

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.

Analytics & Insights

Remote (Canada)