Data Engineer
Company Overview:
OMG Canada’s Capabilities Group delivers market-leading programmatic media technologies and solutions to Omnicom clients globally.
Our wide range of products and services includes programmatic media buying for all digital channels, audience segmentation and measurement, and media insights derived from rigorous statistical analysis.
Position and Responsibilities
This role is responsible for the creation and ongoing support for diagnostic-based reports to communicate ad delivery, media quality, and tracking advertiser objectives across all of OMG’s roster of advertisers including, but not limited to McDonald’s, Volkswagen, Scotiabank, and Disney.
You will use manual and automated strategies to extract and visualize data from a variety of digital media databases from Google, Facebook, Amazon, YouTube, and The Trade Desk to name a few.
You will identify gaps in reporting to provide compelling recommendations and leverage different technologies to improve efficiency and optimize results for Activation, Operations, Finance, and Media Investment teams.
You must be able to work independently and as part of the OMG Capabilities team to coordinate efforts, collaborate, and build strong relationships with internal stakeholders.
Key Skills and Experience:
- BA or College degree in Business, Computer Science, or Mathematics
- Advanced SQL query skills
- Experience working with REST API to extract, manipulate, and automate data reporting from various databases
- Practical knowledge of visualization tools (Alteryxor Tableau or Power BI or Looker)
- Experience with Python/R/Scala
- Familiarity with cloud computing platforms (AWS or GCP or Azure)
- Expertise in Data analysis in Microsoft Excel and preferably VBA exposure
- Familiarity with Datorama(preferred)
- Experience in digital media (preferred)
This position reports directly to the Lead Engineer on the Capabilities team. The successful candidate will have the opportunity to collaborate across the Capabilities team, with colleagues in inactivation, ad operations, engineering, marketing science and data science.
Diversity & Inclusion:
Omnicom Media Group Canada is committed to having a workplace that respects diversity and inclusion as reflected in the various designated groups. This respect must be demonstrated by our team members, our leadership, our client services and within our employment practices and relationships with all stakeholders.