MBCC - Developer, Data Management and Visualization

Job Summary  

You will be responsible for designing, developing, and maintaining interactive visualizations in addition to analyzing the data to provide actionable insights into media performance, creative effectiveness, and audience behavior. You will work closely with media planners, and other stakeholders to understand their reporting needs and translate them into compelling and user-friendly dashboards.

Responsibilities:

• Dashboard Development:
• Support existing team in designing, developing, and deploying interactive visual dashboards using tools such as Tableau as a minimum, Power BI, Looker, DOMO, or Datorama are additional extras.
• Support team in optimizing dashboard performance for speed and efficiency.
• Data Integration and Management:
• Connect dashboards to various data sources, including databases, APIs, and cloud storage.
• Develop and maintain data pipelines to extract, transform, and load (ETL) data for use in dashboards.
• Monitor data quality and troubleshoot data integration issues.
• Maintenance & Support:
• Provide ongoing maintenance and support for existing dashboards.
• Troubleshoot and resolve dashboard issues in a timely manner.
• Implement updates and enhancements to dashboards based on user feedback and evolving business needs.
• Documentation & Analysis
• Create and maintain documentation for dashboards, data sources, and data pipelines.
• Conduct analysis using the data provided to help account teams deliver actionable insights to their clients.

Desired Skills & Experience

• Experience:
• 3-5 years of experience in dashboard development and data visualization. 
• Proven experience with data visualization tools Tableau.
• Experience with data warehousing concepts and technologies.
• Experience with SQL, Python or other data manipulation languages.
• Experience with data integration and ETL processes.
• Experience in the media or advertising industry platforms for reporting (Google Analytics, CM360 etc…)
• Skills:
• Ability to problem-solve.
• Ability to communicate clearly and understand briefed tasks.
• Ability to work independently and as part of a team.
• Ability to manage time and multiple projects.

• Bonus Points:
• Experience with cloud-based data platforms (e.g., AWS, Azure, GCP).
• Experience with version control systems (e.g., Git).
• Experience in data science tools (R, Python)

IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its best-in-class brands UM, Initiative, Media Experts, Reprise, MAGNA, Orion, Mediabrands Content Studio, and the IPG Media Lab. IPG Mediabrands clients include many of the world’s most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer packaged goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communications professionals in more than 130 countries. Learn more at www.ipgmediabrands.ca and follow us on LinkedIn: Mediabrands Canada and Instagram: @MediabrandsCanada.

What's in it for you?
•    Generous paid time off with a minimum of 37 paid days off including vacation and monthly wellness days. We also have four-day long weekends, half-day summer Fridays, and meeting-free Friday afternoons year-round.
•    A flexible hybrid work model that works for you.
•    A focus on personal development with formal training opportunities, including mental health training and inclusion education for everyone.
•    A chance to be part of and grow within a global network of agencies.
•    The opportunity to contribute to our company culture by joining one of our many community-based employee groups, such as Black Employee Network, Girls on Fire, Hispanic or Latinx Alliance, Neuro Network, Pan-Asian Network, and Rainbow Lounge.

IPG Mediabrands is an equal opportunity employer, committed to providing equal employment opportunities to all employees and applicants without regard to race, colour, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, disability, or any other basis prohibited by applicable federal, provincial, or municipal law. If you require an accommodation in any aspect of the selection process, please reach out to [email protected]