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.Top Skills
What We Do
Creative Artists Agency (CAA) is the leading entertainment and sports agency, with global expertise in filmed and live entertainment, digital media, publishing, sponsorship sales and endorsements, media finance, consumer investing, fashion, trademark licensing, and philanthropy. Distinguished by its culture of collaboration and exceptional client service, CAA’s diverse workforce identifies, innovates, and amplifies opportunities for the people and organizations that shape culture and inspire the world. The trailblazer of the agency business, CAA was the first to build a sports business, create an investment bank, launch a venture fund, found technology start-up companies, establish a philanthropic arm, build a business in China, and form a brand marketing services division, among other innovations. Named Most Valuable Sports Agency by Forbes for eight consecutive years, CAA represents more than 2,000 of the world’s top athletes in football, baseball, basketball, hockey, soccer, in addition to coaches, on-air broadcasters, and sports personalities and works in the areas of broadcast rights, corporate marketing initiatives, social impact, and sports properties for sales and sponsorship opportunities. Founded in 1975, CAA is headquartered in Los Angeles, and has offices in New York, Nashville, Memphis, Chicago, Miami, London, Munich, Geneva, Stockholm, Shanghai, and Beijing, among other locations globally. For more information, please visit www.caa.com.
