Job description

POSITION SUMMARY: Support team conducting data analytics and related projects. Collect requirements, conceive, design, and create reports/dashboards regarding music use and other market share metrics. Provide results and insights from various modeling and analysis exercises in response to timely and as-needed questions from various business users within BMI. Leverage strong analytical and critical thinking skills. FUNCTIONS OF THE JOB: Essential Functions: which may be representative but not all inclusive of those commonly associated with this position. Data Analysis: • Designs standard and custom reports/dashboards that are prepared for use by Distribution & Admin Services, Creative, Licensing, Legal, Senior Management, and external customers (audio and a/v sources). • Uses various technologies to mine complex, voluminous, and different varieties of data sources and platforms to support effective business decisions and/or processes. • Assists in detailed analyses of music share processing, performance metrics, distribution analytics, and applications. • Assists in developing, creating, testing, and generating routine analytical reports and custom business analysis using Business Intelligence tools and SQL. • Works closely with departments throughout the organization to produce actionable analysis related to music usage, performance data, and historical trending of key business metrics. • Develop improved methods and recommendations for music use analysis. • Converts files from various computer platforms such as mainframe, UNIX and PC. • Maintains databases that are used by this department for music use and statistical research and analysis. • Conducts research to gather information from a variety of sources, including BMI internal databases, the Internet and 3^rd party data providers. Additional: • Other duties as assigned. • Regular attendance. • Supports our BMI Core Values and cultivates a culture of diversity and inclusion. Marginal Functions: • Attend meetings. • Assist in department projects in areas outside of regular workload. Physical/Visual Activities or Demands: Physical/visual activities or demands that are commonly associated with the performance functions of this job. • Sitting, talking, hearing, walking. • Concentrated mental and visual attention with normal hand-eye coordination. • Clarity of vision at 20 inches, corrected or uncorrected. • Generally negligible physical effort, but occasional moving of 1 to 10 lb. items. Environmental/Atmospheric Conditions: Environmental and atmospheric conditions commonly associated with the functions of this job. Normal office conditions. POSITION QUALIFICATION REQUIREMENTS Education: Bachelor’s degree with a relevant major or minor in Business Information, Economics, Finance, Computer Science, Mathematics, or similar discipline required. Advanced degree preferred. Experience: Minimum of three yearsrelated experience performing business analysis, data analysis, or other quantitative/qualitative research work. Skills and Abilities: which may be representative but not all inclusive of those commonly associated with this position. • Experience writing queries in SQL, creating reports using Business Intelligence software and using spreadsheets and databases to conduct analysis and improve business processes. • Experience conducting research and analysis with large data sets and third party resources. • Analytical thinker and problem solver. • Good communication skills, both written and verbal. • Adaptable to shifting priorities with strong organization, time management and multi-tasking skills. • Must have knowledge of data processing concepts, basic statistics, and database concepts. • Ability to write reports and business correspondence. • Ability to effectively present information and respond to questions. • Mathematical, statistical, and analytical aptitude. • Ability to establish and maintain positive working relationships at all levels. • Think strategically to identify new opportunities with a strong aptitude for problem solving. • Good at identifying and solving problems. • Above average ability with BI reporting tools such as Cognos, PowerBI, QLIK, Tableau, MS SSRS; advanced preferred. • Above average proficiency with Microsoft Office Suite applications and other applicable technology. Expert Excel level skills. • Solid SQL query writing skills Machines, Tools, Equipment and Work Aids: Personal computer and associated software. Normal office equipment. License(s)/Certifications Required: None. This job description in no way states or implies that these are the only duties to be performed by the employee occupying the position. Employees may be required to follow other job-related instructions and perform other job-related duties as requested, subject to all applicable state and federal laws. “Commonly associated” is not intended to mean always or only. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Requirements