Data Analyst / BI Developer

Job Overview

CafeMedia empowers over 2,500 premium publishers, with a collective reach of over 164MM monthly unique visitors (#11 largest Comscore property in May 2020), to make a living doing what they love ? producing great content ? while we manage the advertising for them. From food to home to news and technology and more, we represent the influential voices who make the internet a better place. As the largest exclusive publisher network, with direct access to code-on-page and underlying datasets, we have a unique capability to build innovative products that span across publishers, advertisers and consumers.We?re looking for someone to join the Data Intelligence team to use their quantitative and technical skills to help us develop insights and reporting that make our products stronger, our processes and actions more effective and lead to stronger impact for our publishers. The ideal candidate has both strong technical skills, in SQL and dashboard building, and communication skills, in being able to effectively share findings and recommendation.Data Analyst / BI Developer+ Design and plan BI reports, as well as debug, monitor, and troubleshoot BI solutions.+ Write relational and multidimensional database queries.+ Form productive relationships with internal customers by listening, clarifying, and responding effectively.+ Provide accurate and timely answers to routine questions from customers.+ Act as the first line of support for data questions and issues and strive to become data subject matter expert for the company.+ Responsible for programs that are accurate, efficient and well documented.+ Work collaboratively with peers to develop quality protocols, schema, and reports per agreed timelines.+ Participate on project teams.+ Responsible for writing fundamental documentation in a clear, concise manner, adhering to standards.Skills+ Strong experience with programming in SQL required+ Experience working with Looker+ Command-line experience with shell scripting and software development with python and pyspark skills preferred+ Highly skilled in Excel+ Strong understanding of online media industry preferred+ BA/BS requiredCafeMedia is an equal opportunity employer