Sql jobs in Canada

Zenith is the ROI Agency. Our more than 6,000 specialists across 95 markets offer unparalleled capabilities in Media, Data, Technology, Commerce and Content. We put effectiveness at the heart of our work to solve complex challenges, drive successful business outcomes, and grow our clients’ businesses. Zenith is part of Publicis Media, the media arm of Publicis Groupe.

Over the past year, Publicis Media hasbeen transforming the way we do our business. From structuring our investment practice around data and digital to bringing our strategy, data sciences and research practice under one house, we’ve been shaping Publicis Media to be the media network of tomorrow. One that both you and I want to work at.

Publicis Media Canada is proud to be Great Places to Work™ certified and recognized with Best Workplaces™ for Today’s Youth. We provide continuing opportunities for career growth by fostering a diverse work environment that respects and supports individual contributions and opinions.

We also offer our employees market leading benefit and incentive programs. You’ll be provided with 3 weeks minimum vacation to start plus additional long weekend Publicis days, holidays closures, your birthday off, free Headspace memberships, wellness and technology credits, and a market leading savings plan.

We strive to provide what matters to you personally with the ability to choose and modify programs to suit your lifestyle

The Data Activation Senior Specialist will be responsible for utilizing digital platforms and transformingvast data sets into actionable insights that inform targeting and optimization; specifically, connecting or extracting data, tracking, measuring, and analyzing and optimizing digital mediafor improved conversion and business performance. You will be part of a growing team, reporting to the Data Activation Manager and will have the opportunity to learn and grow in the emergingfield of data strategy, data activation and data analysis.

• Ingest disparate digital data sources across Paid, Owned and Earned Digital Media into aconsolidated environment for tracking
• Learn how to set up automated process for data extraction, via API, SFTP, SQL etc.
• Extract, transform and load data for ingestion into business intelligence platforms
• Learn how to build dashboards in business intelligence platforms
• Build and deploy semi-automated Excel and PowerPoint digital reporting solutions suchas campaign performance tracking
• Provide the Planning and Buying teams with analysis, insights and data-informedrecommendations from the aforementioned reporting areas
• Opportunity to work across key business intelligence platforms for digital media, mainlyDatorama
• Translate strategy into implementation tacticsData mapping and enhancement
• Create segments relevant to objectives that can be pushed to relevant destinations foractivation
• Translate objectives into digital media measurement plans
• Analyze and report on campaign performance through standardized ad-server attributionmodels
• Learn how to build simplistic algorithmic attribution models and implement them
• Work alongside data scientists to deploy more complex algorithmic attribution models
• Make data-informed recommendations for optimizing digital media and content
• Opportunity to work on key attribution platforms such as Google’s Data-Driven
• Attribution model with DoubleClick, and proprietary Publicis Media platforms

• 3-4 years’ experience in Digital Media in Planning/Buying and/or 2 years Data Science experience
• Technically competent and capable of working with and learning new digital and tech platforms
• Strong numerical and analytical skills
• Demonstrated ability to convert data analysis into meaningful action for brands
• Experience with or strong knowledge of ad servers and web analytics platforms such as DoubleClick, Adobe Media Optimizer, Sizmek, Google Analytics or Adobe Omniture
• Effective written and verbal communication skills
• Ability to cope under pressure and deliver to tight deadlines autonomously.

Zenith is an equal opportunity employer and we welcome and encourage applications from all interested parties. Accommodations are available, upon request, for all stages of the interview and employment process for those with a disability or medical need during any stage of the recruitment process. We thank all candidates for their interest in Zenith , however, only those candidates selected for an interview will be contacted.