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

Requirements

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)

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata integrationdata modelinganalyticsreportingperformance optimizationsoftware engineering best practicesversion controltestingcontinuous integration

Soft Skills

communicationcollaborationproblem-solvingadaptabilityindependenceanalytical thinkingstakeholder engagementnavigating ambiguityarticulating technical insightscross-functional teamwork

Certifications

Bachelor's degreeadvanced analytics certificationMaster's degree