Analytics Engineer for Music Insights & Dashboards

createmusicgroup; Los Angeles (CA); On-site; CAD 90,000 - 110,000; Full time

Job summary

Create Music Group in Canada is seeking an Analytics Engineer to translate business needs into scalable analytics solutions. You will analyze data, integrate multiple datasets, and write and optimize SQL for analytics while owning end-to-end deliverables.

The role blends technical rigor with business acumen to turn data into actionable insights that drive impact. You will partner with Finance, Music Ops, and Acquisitions, building analytics-ready data models, dashboards, and KPIs.

Qualifications

• 2+ years of experience in the analytics domain as a data analyst/data engineer/data scientist.
• Strong proficiency in SQL.
• Proven ability to navigate ambiguous requirements, analyze and integrate datasets and build targeted reporting tables, executive dashboards and KPIs.
• Demonstrated expertise in building and owning the analytics semantic layer, including metric definitions, data models & business logic.
• Understanding of how data insights translate to business value and competitive advantage.
• Programming experience in R, Python, or similar analytical languages is preferred.
• Experience with dashboard development in Tableau or Sigma.

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.
• Analyze and integrate data from disparate datasets to develop niche reporting tables and generate meaningful business insights.
• Develop, optimize, and maintain complex SQL queries and reporting tables.
• Recommend and implement improvements to existing SQL data models.
• Design and build scalable reporting architecture that supports evolving analytics needs.
• Design and develop executive dashboards and KPI frameworks that provide real-time visibility into business performance.
• Apply software engineering best practices to analytics code (e.g., version control, continuous integration).
• Participate in code reviews and optimize SQL for performance, including Sigma-specific optimization.
• Maintain data documentation, definitions, and governance standards.
• Other duties as assigned

Skills

SQL

Cross-functional collaboration

Data storytelling

Education

Bachelor's degree in a quantitative field

Master's degree or advanced certification preferred

Tools

Tableau

Sigma

R

Python

Job description

Create Music Group in Canada is seeking an Analytics Engineer to translate business needs into scalable analytics solutions. You will analyze data, integrate multiple datasets, and write and optimize SQL for analytics while owning end-to-end deliverables.

The role blends technical rigor with business acumen to turn data into actionable insights that drive impact. You will partner with Finance, Music Ops, and Acquisitions, building analytics-ready data models, dashboards, and KPIs.