Company

Position Summary

This role provides a unique opportunity to stretch and grow your reporting analytics skills in the marketing industry. We are looking for a passionate analyst with a love for using their technical skills to produce accurate reports for our internal teams. The role of a Reporting Analyst is to provide data governance and quality assurance so that clients can rely on this data for decision making. Some of the data you’ll be working with include social media data, display & video programmatic buys, and site data. You will play a key role in driving an ongoing learning agenda and fostering a data driven decision making process, working collaboratively with various internal partners and client teams.

Key Responsibilities

• Provide data quality audits on our SQL database on an ongoing basis
• Provide data quality audits on our Tableau and Data/Looker Studio dashboards
• Update executive summaries for various clients 
• Highly leverage the use of technology for data processing and workflow automation 
• Create and maintain client dashboards in Tableau, Datorama, Domo, Data Studio or Excel
• Support and update dictionary mapping as needed
• Site served / vendor data collection support
• Analyze data to recommend campaign execution and visualization improvements, based on data and observed trends 
• Automate ETL processes with Tableau Prep, python, App Script, or other scripting tools
• Work closely with Business Intelligence, to ensure timely and accurate maintenance of internal dashboards and data management

Desired Skills & Experience

• 1-2 years of experience in an analytics-based role 
• 1-2 years of experience in marketing and/or media performance (digital experience desired)
• Demonstrated proficiency in Microsoft Excel, SQL, or VBA 
• Proficient in SQL queries and views.
• Strong familiarity with using Tableau, Google Data Studio, DOMO or other reporting visualization platforms 
• Familiarity with social media marketing and programmatic media channels
• Strong communication skills (verbal & written); ability to provide concise and clear reporting
• Proven ability to self-check work to ensure results are error-free 
• Keenness to learn new skills, platforms, and technologies
• Nice to haves: exposure to any DSP, DV360, CM360, GA/GA4

Employment Transparency

We’re a global media agency designed to grow brands through culture. Over the last three years, we’ve been named as the fastest growing media agency in the world by independent media ratings agency, RECMA. Key to our success is the fact most media agencies are built for brand awareness, with a bias for paid media. We’re a little different. We’re built for brand relevance, with a bias for Cultural Velocity. We believe the brands that succeed move and adjust with consumers at speed, showcasing their relevance and meaningfully contribute to their lives. We call this Cultural Velocity™ - a measure for the speed at which a brand moves through culture to drive relevance. The faster a brand can move with culture, the more relevant they become and the greater the growth. Operating in over 90 countries, Initiative employs 4,000 of the smartest and most diverse talent in the industry.