Advanced Analytics Lead

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

Job Description

Core Responsibilities

• Determines relevancy of data and identifies alternative data sources as needed to ensure analytics requested by business owners and technical associates can be completed.
• Analyzes large, complex data to determine actionable business insights using self-service analytics and reporting tools.
• Performs basic research on root cause of data anomalies that are uncovered through course of analysis.
• Queries large data platforms such as Teradata, SQL server and Oracle to obtain data necessary for analysis.
• Participates in defining business intelligence requirements for projects and data requests.
• Mentors, coaches and provides technical support to junior analysts.
• 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're Looking For:

• Bachelor's degree or equivalent in related discipline.
• Experience integrating data using API, or web hooks.
• Previous experience developing analytics pipelines using Alteryx, Airflow, DBT, or other similar system.
• Familiarity with HTML and JavaScript for data visualization and/or dashboard integration.
• Data visualization platform experience (Looker, Power BI)
• Digital marketing analytics and/or web analytics.
• Experience managing analytics/business intelligence datasets in cloud infrastructure (e.g., AWS, GCP, Azure).
• Fluent in SQL dialects (e.g., Presto, TSQL, etc) and distributed SQL systems (e.g., AWS Athena, Redshift, etc.). Expertise in SQL and Excel required.
• Enthusiasm and experience providing technical guidance and mentoring support for junior team members.
• Blend of strong analytical experience, business acumen and strong communication skills

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

Salary:

Pay Range: This job can be performed in New York City, with a Pay Range of $109,959.93 USD - $164,939.89 USD

Comcast intends to offer the selected candidate base pay within this range, dependent on job-related, non-discriminatory factors such as experience.

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 [Register to View] on our careers site for more details.