Business Intelligence Analyst

Comcast•New York, NY

About The Position

FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we’re making it easier for buyers and sellers to transact across all screens, data types, and sales channels. As a global company, we have offices in nine countries and can insert advertisements around the world. Job Summary FreeWheel is looking for an analyst to join our Global Reporting and Analytics team. The Global Reporting and Analytics team acts as strategic partners across the organization by helping stakeholders make fast-paced, data-driven decisions. This role is a vital component for FreeWheel's Marketplace business, which enables the most premium video inventory owners and buyers - such as TV Programmers, MVPDs, major digital media publishers, advertisers, agencies, and DSPs - to drive successful business outcomes at scale. In this role, you will work cross-functionally with internal teams to uncover growth opportunities, identify product enhancements, and develop robust reporting solutions. The successful candidate will require excellent communication and problem-solving skills, and the ability to think strategically while being analytical and detail oriented. The Analyst II will report directly to: Senior Manager, Global Reporting and Analytics. This position is not eligible for visa sponsorship. Applicants must be authorized to work for Comcast in the United States without a current or potential future need for sponsorship.

Requirements

Bachelor's degree in quantitative field preferred.
1-2 years of experience using data and analysis to drive business outcomes.
Strong knowledge of SQL.
Experience with a scripting language (Python or R).
Experience with Visualization BI tools (Looker and Tableau).
Advanced Excel Skills.
Skilled in synthesizing detailed analysis into clear narratives, facilitating strategic discussions across technical and business stakeholders.

Nice To Haves

Experience in advertising technology is a plus.

Responsibilities

Develop and maintain reporting of Digital TV key business metrics using different BI tools for Freewheel constituents, including internal users, external clients, and executives.
Conduct regular analysis of large-scale data sets to uncover opportunities to improve overall sales, inventory management, and yield strategies.
Prototype and develop automated reporting solutions to monitor the health of the business.
Collaborate with business stakeholders and technology leaders to build out new product features and business processes.
Ensure data quality and cleanliness for consistent and accurate reporting.
Creating ETL processes to accommodate changes in source systems and new business user requirements.
Works with business leaders and stakeholders to understand data and analysis needs and develop technical requirements.
Determines relevancy of data and identifies alternative data sources as needed to ensure analytics requested by business stakeholders can be completed.
Analyzes large, complex data to determine actionable business insights using self-service analytics and reporting tools.
Queries disparate big data platforms such as Teradata, SQL Server, Hadoop, and AWS.
Combines data as needed from disparate data sources to complete analysis.
Identifies key business drivers and insights by conducting exploratory data analysis and hypothesis testing.
Develops forecasting models to predict sales, demand and other key business metrics.
Analyzes the results of campaigns, offers or initiatives to measure their effectiveness and identifies opportunities for improvement.
Communicates findings clearly and concisely through narrative-driven presentations and effective data visualizations to Company executives and decisionmakers.
Promotes and evangelizes a culture of excellence, data driven discussions, healthy skepticism, intellectual curiosity, knowledge sharing, and teamwork.
Stays current with emerging trends in analytics, statistics, and machine learning and applies them to business challenges.
Consistent exercise of independent judgment and discretion in matters of significance.
Regular, consistent and punctual attendance.
Must be able to work nights and weekends, variable schedule(s) as necessary.
Other duties and responsibilities as assigned.
Employees at all levels are expected to: Understand our Operating Principles; make them the guidelines for how you do your job.
Own the customer experience - think and act in ways that put our customers first, give them seamless digital options at every touchpoint, and make them promoters of our products and services.
Know your stuff - be enthusiastic learners, users and advocates of our game-changing technology, products and services, especially our digital tools and experiences.
Win as a team - make big things happen by working together and being open to new ideas.
Be an active part of the Net Promoter System - a way of working that brings more employee and customer feedback into the company - by joining huddles, making call backs and helping us elevate opportunities to do better for our customers.
Drive results and growth.
Support a culture of inclusion in how you work and lead.
Do what's right for each other, our customers, investors and our communities.