Initiative - Reporting Analyst, Digital Hub Job at IPG Mediabrands
General information
Agency: Initiative
Function: Data & Analytics
Location: Toronto, Canada
Job Ref#: 15415
Description & Requirements
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
IPG Mediabrands is an equal opportunity employer. We welcome and encourage applications from all interested parties, regardless of their preferred official language. Accommodations are available, upon request, for individuals with disabilities or medical needs at any stage of the recruitment process. We thank all applicants for their interest in IPG Mediabrands. However, only those candidates selected for an interview will be contacted.
About Us
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.
Please Note :
clarksonsquare.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, clarksonsquare.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.