Enterprise Data Analyst

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

Comcast Effectv’s Advanced Analytics team is growing and is seeking motivated candidates who can mold their passion for data and their innate curiosity in an opportunity that is charged with impact and growth. These newest team members will be joining to support the advancement of our processes and systems to allow for more intuitive data analysis across our organization. As Advanced Analytics Analyst, you will join a newly created data analytics team responsible for enabling data sets that empower real time business decisions across BU’s within Effectv. This team will also assist end users with data troubleshooting or uncovering additional insights.

Job Description

Core Competencies

• 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, complexdata 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.
• 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.

Job Specifications

• Bachelor’s degree or equivalent in related discipline
• Strong analytical background and 3+ years of experience in extracting insights and operating with large data sets to identify trends and actionable takeaways
• Experience integrating data using API or web hooks.
• Familiarity with HTML and JavaScript for data visualization and/or dashboard integration.
• Expertise in SQL and Excel required
• Proficiency in data analysis and visualization tools such as SAS, Python, R, Tableau, Microstrategy, Looker, Power BI and Google Data Studio
• Experience developing data in Looker strongly preferred.
• Experience with digital marketing analytics and/or web analytics
• Ability to identify areas of improvement to enable more efficient data collection and consumption
• Experience in managing analytics/business intelligence datasets in cloud infrastructure (e.g., AWS, GCP, Azure).
• Fluency in SQL dialects (e.g., Presto, TSQL, etc) and distributed SQL systems (e.g., AWS Athena, Redshift, etc.)

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, genetic information, or any other basis protected by applicable law. Comcast will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law, including the Los Angeles Fair Chance Initiative for Hiring Ordinance and the San Francisco Fair Chance Ordinance.

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-5 Years

Salary:

National Pay Range: $50,885.95 USD-$119,263.95 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 compensation and benefits summary on our careers site for more details.