Lead Analyst Customer Data Analytics- REMOTE

Profile

Job Information

Comcast

Lead Analyst, Customer Data Analytics- REMOTE

in

Philadelphia

Pennsylvania

Effectv, the advertising sales division of Comcast Cable, helps local, regional and national advertisers use the best of digital with the power of TV to grow their business. It provides multi-screen marketing solutions to make advertising campaigns more effective and easier to execute. Headquartered in New York with offices throughout the country, Effectv has a presence in 66 markets with nearly 35 million owned and represented subscribers. We're dedicated to helping our clients meet their business goals by connecting them with their customers through multiscreen television advertising. Working with companies from local startups to nationwide corporations, we provide support to help each business reach its target customers. By applying data to television advertising in new ways, we're able to bring our clients the best of digital media, coupled with the power of TV. To learn more, check out www.effectv.com.

Job Summary

Effectv, the advertising sales division of Comcast Cable, helps local, regional and national advertisers use the best of digital with the power of TV to grow their business. We provide multi-screen solutions to make advertising campaigns more effective and easier to execute. Effectv has a presence in 66 markets with nearly 35 million owned and represented subscribers. Collaborating with companies from startups to muti-national corporations, we empower customers to reach and connect with their targeted customers.

Job Description

Who We Are

EffecTV enables advertisers to find their unique audience. We help our clients connect with their customers wherever they are with EffecTV's custom ad solutions for multiscreen TV, powered by Comcast aggregated viewership data.

We accomplish this by bringing together high-quality inventory with the best audience delivery technology. We drive innovation to create the world's best audience delivery platform.  

As part of a Fortune 50 company, we set the pace in a variety of innovative and interesting businesses, which creates career opportunities across a wide range of locations and disciplines. We are at the forefront of change and move at an amazing pace. Thanks to our remarkable people, we bring cutting-edge products and services to life for thousands of customers every day. If you share in our passion for teamwork, our vision to revolutionize advertising and our goal to define the future, we want you at EffecTV.

Core Responsibilities

Code -Write efficient SQL or Pythion code against very large datasets

Document - Write clear Wiki pages and related documentation

Guide - Partner with employees to make sure they understand our data sufficiently to accomplish their goals

Profile Data - Profile our customer and prospect data

Data Quality - Deduplicate customer data and refine process to keep our data clean

Best Practices - Help define and implement data quality and governance best practices

Data Engineering - Build data pipelines that enrich and aggerate data to be used by partners

Leverage Tools - Use tools like Data Bricks, Azure Synapse, AWS Athena/Glue/Lambda

Visualize - Use visualization tools like Looker and Python (Matplotlib, Seaborn) to show data in context

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) and overtime as necessary.

Other duties and responsibilities as assigned.

What We Need

Knowledge and Experience

Customer data - Worked with large customer data sets, ideally business to business, but direct to consumer is also sufficient

Advertising or media entertainment industry experience - familiar with how advertisers leverage media to reach their customers

Data modeling - Ability to understand and contribute to a data model design with entity relationship diagrams

Data Governance - Familiar with data quality, governance and stewardship principals.

Skills and Abilities

SQL - Ability to write SQL queries - able to use filters, group by, having, sum and rank functions

Python - Ability to write python code in notebooks using Pandas

Data Profiling - Ability to explore, understand and describe complex data sets

Data wrangling and data cleansing - reorganizing, checking and transforming data from one format into another to make it easier to use

Additional tools - Scala, Data Bricks, Customer Data Platform, CRM Platform (Sales Force or Dynamics) experience a plus

Education - Bachelor's Degree

While possessing the stated degree is preferred, Comcast also may consider applicants who hold some combination of coursework and experience, or who have extensive related professional experience.

Relevant Work Experience

2 Years professional experience

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.

Respect and promote inclusion & diversity.

Do what's right for each other, our customers, investors and our communities.

Disclaimer:

This information has been designed to indicate the general nature and level of work performed by employees in this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications.

Comcast is an EOE/Veterans/Disabled/LGBT employer.

Comcast is proud to be an equal opportunity workplace. We will consider all qualified applicants for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other basis protected by applicable law.

Education

Bachelor's Degree

While possessing the stated degree is preferred, Comcast also may consider applicants who hold some combination of coursework and experience, or who have extensive related professional experience.

Relevant Work Experience

7-10 Years

Base pay is one part of the Total Rewards that Comcast provides to compensate and recognize employees for their work. Most sales positions are eligible for a Commission under the terms of an applicable plan, while most non-sales positions are eligible for a Bonus. Additionally, Comcast provides best-in-class Benefits. We believe that benefits should connect you to the support you need when it matters most, and should help you care for those who matter most. That's why we provide an array of options, expert guidance and always-on tools, that are personalized to meet the needs of your reality - to help support you physically, financially and emotionally through the big milestones and in your everyday life. Please visit the compensation and benefits summary (https://jobs.comcast.com/life-at-comcast/benefits) on our careers site for more details.

Company info

Comcast
Website : http://corporate.comcast.com