Business Intelligence Analyst

Job Description

Paramount+, a direct-to-consumer digital subscription video on-demand and live streaming service from Paramount Global, combines live sports, breaking news, and a mountain of entertainment. The premium streaming service features an expansive library of original series, hit shows and popular movies across every genre from world-renowned brands and production studios, including BET, CBS, Comedy Central, MTV, Nickelodeon, Paramount Pictures and the Smithsonian Channel. The service is also the streaming home to unmatched sports programming, including every CBS Sports event, from golf to football to basketball and more, plus exclusive streaming rights for major sports properties, including some of the world's biggest and most popular soccer leagues. Paramount+ also enables subscribers to stream local CBS stations live across the US in addition to the ability to stream Paramount Streaming's other live channels: CBSN for 24/7 news, CBS Sports HQ for sports news and analysis, and ET Live for entertainment coverage.

Division Overview:

We are the Marketing Performance & Audience Acquisition Analytics team, part of the ViacomCBS Streaming Data & Insights Group (DIG) Business Intelligence team! DIG is a key connector between the ViacomCBS Streaming verticals. This group of subject matter experts prototype, build, and scale data infrastructure and products; assess, aggregate, and analyze data; and craft qualitative and quantitative-based narratives and insights, providing decision makers 8,with decision support, performance clarity and business-driving recommendations.

We provide useful, data-driven solutions to address marketing challenges. We work closely with digital and corporate teams across the company portfolio, including Paramount+, Brand Tune In Initiatives, Marketing Strategy & Corporate Communications, and Distribution & Business Development.

Role Details:

Interest and ability to tackle highly technical analyses, which require researching, reporting, communicating and ultimately providing decision support services and useful insights. Sources of data include marketing delivery and performance data including, but not limited to marketing platforms (Facebook, Google Marketing Platform), Adobe tools (Omniture, Audience Manager), mobile measurement partner (Kochava).

The ability to interpret data and provide context to explain marketing performance, industry shifts, and usage across multiple platforms will be key to success in this role. The ideal candidate will possess strong communication skills, an inquisitive nature, attention to detail, and a love of media.

Your Day-to-Day:
• Build and handle reports to provide various teams with an understanding of how our marketing efforts drive audience acquisition (sign-ups, trial-to-paid conversions, traffic growth, CPA, ROAS), retention (trial-to-paid-conversions, retention percentage, average tenure and churn, ROAS), SVOD sign-us (trial starts, winbacks, traffic to sign-up funnels, ROAS, LTV), tune-in/view thru (video views, video minutes, re-engagement - streams/minutes, ROAS), and any other applicable critical metrics.
• Work closely across the media strategy, media activation, and research teams to develop KPIs and reporting methodologies and approaches that are aligned to campaign and brand goals
• Partner closely with the Data Integration team to automate data sources and reporting
• Build ad-hoc dashboards and reports that provide in-depth, digestible, and visual campaign analysis by audience and creative holistically and by marketing channel. Make recommendations to the business from the data
• Leverage improved attribution and modeling on marketing platforms to understand the consumer journey and efficient pathway to conversion. Socialize and present findings to the media strategy and activation teams to aid in their efforts
• Write SQL to aggregate and analyze marketing data over time for QBRs. Uncover data stories and insights and present your findings to the executive team

Key Projects:

Build dashboards (using Tableau, Python and other BI tools) that illustrate how key performance indicators (KPIs) and metrics are changing over time. Provide ''color'' and insights from the findings and make recommendations.

Build a pathway analysis report by signup month cohort for a paid online content subscription product in order to optimize media budget to acquire new customers

We build an audience-based analysis to understand how different segments contribute to overall revenue. The ultimate goal is to be able to use this analysis to optimize media budget to segments with higher lifetime value (LTV)

Qualifications:

BA/BS. 2+ years experience in digital marketing and analytics, web analytics, online media industry.

Strong experience in social and programmatic measurement

Understanding of web, native app, video measurement technology and standards

Proficient with analytical tools and languages supporting data analysis, reporting, and visualization - Excel, Microsoft Office, Google Collaborative Apps (Docs, Sheets, Slides), Tableau, R, Python

Experience extracting data from databases using SQL

Strong detail-orientation with a penchant for data accuracy and good grammar

Exceptional communicator across all levels of the organization; able to effectively tell stories with data and present findings to a non-technical audience

You might also have:

Strong mathematics, statistics background

Experience using project management tools like those from Atlassian (JIRA, Confluence)

Experience using Google Cloud Platform (BigQuery)

Paramount is an equal opportunity employer (EOE) including disability/vet.

Jobcode: Reference SBJ-rb5bb6-3-133-154-106-42 in your application.