Television Research - Jr. Associate

Job Description

WHO WE ARE

Creative Artists Agency (CAA) is the world’s leading full-service entertainment, media, and sports agency. We represent many of the most successful professionals working in television, film, music, theatre, video games, sports, and digital content. We also provide a range of strategic and marketing consulting services to corporate clients.

THE ROLE

Passionate about television, streaming, data and analytics? Have a natural aptitude toward storytelling through data? Join our growing Global TV Research & Insights team as we provide advanced data solutions and strategic insights to enhance the creation of opportunity for our world-class TV clients.

CAA is seeking an exceptional junior associate to provide multifaceted support across the Global TV Research & Insights team. In this role you will be a member of a highly-motivated and collaborative team responsible for the creation of cutting-edge data and analytics tools, and providing actionable strategic insights to Agents, Executives, and Clients to impact TV department business goals.

RESPONSIBILITIES

• Craft compelling data narratives through the synthesis of multiple data sources to provide actionable insights around the performance of scripted, non-fiction, news, sports, kids, and comedy stand-up content across the full TV ecosystem (streaming, broadcast, and cable)
• Contribute to the maintenance and ongoing development of the TV research database
• Help build and maintain the Microsoft Fabric workspace, including pipelines, dataflows, and stored procedures
• Develop and update Power BI dashboards for TV data analysis, ensuring accuracy and usability
• Write and maintain SQL logic to extract, transform, and analyze TV data
• Assist with data cleaning, validation, and data quality management (DMO) activities
• Create and maintain documentation for tables, data models, dashboards, and analytical logic

QUALIFICATIONS

• BA/BS from an accredited University or College preferred
• Excellent interpersonal and written communication skills; highly collaborative and inclusive team player
• Able to work in a fast-paced agency environment and can easily adapt to change
• Must have the ability to meet deadlines and able to juggle multiple tasks simultaneously
• Strong attention to detail and ability to document processes clearly
• Working knowledge of Power BI, including building dashboards and writing DAX measures
• Experience or exposure to Microsoft Fabric, Azure, or similar data platforms is a plus; Familiarity writing SQL or Python is a plus

LOCATION

On-Site in Los Angeles, CA, United States 

COMPENSATION

The base hourly rate for this position is $28.00. This position also is eligible for benefits and discretionary bonus. Ultimately, wages may vary based upon, but not limited to, relevant experience, time in role, business sector, and geographic location, among other criteria. Please talk with a CAA Recruiter to learn more.

Please provide complete and legible information.  An incomplete application may affect your consideration for employment.

Creative Artists Agency, LLC (the “Company”) is committed to a policy of Equal Employment Opportunity and will not discriminate on the basis of race (inclusive of traits historically associated with race, including hair texture and protective hairstyles), color, religion, creed, gender or sex (including pregnancy, childbirth, breastfeeding or related medical conditions), national origin, ancestry, age, physical disability, mental disability, medical condition, genetic information, family and medical care leave status, military or veteran status, marital status, family status, sexual orientation, gender identity, gender expression, political affiliation, an employee’s or their dependent’s reproductive health decision making (e.g., the decision to use or access a particular drug, device or medical service), or any other characteristic protected by applicable law.

The absence of a permanent address is not a bar to employment. The Company does not discriminate against individuals based on housing status, including the absence of a fixed address.The Company also complies with the Americans with Disabilities Act and applicable state and local laws with regard to providing reasonable accommodation for qualified individuals with disabilities.

CAA does not accept unsolicited resumes from third-party recruiters unless they were contractually engaged by CAA to provide candidates for a specified opening. Any such employment agency, person or entity that submits an unsolicited resume does so with the acknowledgement and agreement that CAA will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity.