Media Analyst

Job Description

The Data and Platform Solutions group is a specialized team within the agency acting as digital data and ad technology experts. Our team is looking for a high-performing Tableau/BI Analyst who will be responsible for the design, development, implementation and on-going support of reports and dashboards published on a Tableau Server platform.

Role Objectives:

• Developing, maintaining, and managing advanced reporting, analytics, dashboards, and other BI solutions
• Custom Design, build, test and publish interactive dashboards on Tableau Server
• Design, build, test, debug, monitor, and troubleshoot published data sources and extracts on Tableau Server
• Advanced Tableau Server site administration including user/group security and roles, and managing project and data source security
• Analyze ambiguous business requirements and partner with product team to provide a strategic solution
• Collaborate with data engineers to design or modify schema for optimal software performance
• Have the confidence to work cross-functionally with various departments including business stakeholders and technical personnel to exchange ideas
• Reviewing and improving existing solutions and collaborating with teams to integrate new solutions
• Recommend solutions to existing or anticipated issues
• Serve as an escalation point for any issues that may arise
• Ability to follow implementation standards, develop documentation and transfer of knowledge

Qualifications

• 1-3 years of experience designing and developing business intelligence dashboards using Tableau
• Media Agency experience preferred with pharmaceutical client experience a plus.
• Able to work independently and balance multiple tasks.
• High competency level in MS Office with specific strengths in Excel (knowledge of VBA a plus) and PowerPoint
• Adheres to deadlines.
• Advanced SQL programming skills, Redshift preferred (creating views, stored procedures, functions, etc.)
• Degree in computer science or quantitative discipline such as statistics, mathematics, or economics. MBA or Advanced Degree a plus
• Excellent data modelling skills and experience working with large data sets.
• Proficient in leading web analytics platforms such as Adobe Analytics and Google Analytics
• Experience with digital media measurement and analytics
• Experience with machine learning principles and applications a plus
• Experience with Python and thorough understanding of a variety of APIs is a plus
• Possession of excellent written, oral communication and presentation skills
• Proven experience managing or mentoring a team.