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 SummaryResponsible for working cross-functionally to collect data and develop models to determine trends utilizing a variety of data sources. Imports, cleans, transforms, or manipulates data with the purpose of understanding or making conclusions from the data for decision making purposes. Has in-depth experience, knowledge and skills in own discipline. Usually determines own work priorities. Acts as resource for colleagues with less experience. Job Description Core ResponsibilitiesCollaborates with both the analytic organization and its technology partners to define and publish complex data products.Provides training to and acts as technical resource for team members.Acts as a subject matter expert in one or more data subject areas such as sales, call center, network operation and financial data.Serves as a team leader within a work group or on cross-functional teams; accepts team lead stretch assignments. Presents results, recommendations and business insights to broader senior leadership team.Produces a variety of reports, graphs, summaries and presentations that convey analytic results and align with business needs.Performs basic research on root cause of data anomalies that are uncovered through normal course of analysis.Writes complex SQL to query large data platforms such as Teradata, SQL server, Oracle and Hadoop to obtain data necessary for analysis. Combines data as needed from disparate data sources to complete analysis.Participates in defining business intelligence requirements for projects and data requests.Participates in multiple enterprise wide projects by providing data analysis to project leaders.Follows best practices and established policies in business intelligence data analysis, maintenance and data quality.Creates technical documentation (internal).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. 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 5-7 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 on our careers site for more details.