Media Data Engineer

MRM McCANN; Toronto; On-site; CAD 80,000 - 115,000; Full time

Job summary

A leading marketing agency in Toronto seeks a Media Data Engineer to manage data ingestion, segmentation, and distribution to media platforms. The ideal candidate thrives in a collaborative team environment, managing multiple projects and ensuring high data quality standards. Experience with SQL and data visualization tools is essential for this mid-senior-level role, offering a dynamic opportunity to impact client strategies.

Qualifications

• 5+ years of experience in data engineering or database management.
• Experience handling large-scale data ingestion and integration projects.
• Strong analytical capabilities and attention to detail.

Responsibilities

• Build and maintain data ingestion pipelines from various platforms.
• Develop ETL/ELT processes for structured media data.
• Collaborate with cross-functional teams to create seamless data flows.

Skills

Analytical

Problem Solving

Collaboration

Time Management

Attention to Detail

Data Quality Issue Identification

Education

Bachelor's degree in Computer Science

Bachelor's degree in Data Science

Bachelor's degree in Information Technology

Bachelor's degree in Engineering

Bachelor's degree in Economics

Bachelor's degree in Mathematics

Bachelor's degree in Business (Marketing focus)

Tools

Postgres SQL

Oracle

Data Visualization Tools

Power BI

Git

Databricks

Spark

Job description

Get AI-powered advice on this job and more exclusive features.

Job Description

MRM / / McCann is committed to being the most relevant, effective, indispensable marketing agency in the digital world. We employ the most innovative talent in the industry to meet each client’s unique challenges with positive, measurable results. Our strategic, creative, and technological expertise – including deep experience with segmentation, targeting, and analytic tools and methodologies – deliver the most effective marketing programs and platforms in the world.

Job Description

MRM / / McCann is committed to being the most relevant, effective, indispensable marketing agency in the digital world. We employ the most innovative talent in the industry to meet each client’s unique challenges with positive, measurable results. Our strategic, creative, and technological expertise – including deep experience with segmentation, targeting, and analytic tools and methodologies – deliver the most effective marketing programs and platforms in the world.

The Media Data Engineer will be responsible for data ingestion, ETL, joins, structure (data schemas), segmentation, management, and distribution to media platforms. Candidates will have the opportunity to collaborate with internal and client teams to enable data strategies, audience segmentation, customer journey orchestration, holistic business and marketing analytics, AI / ML applications, and CDP technologies. A senior employee is expected to be available as a subject matter expert in relevant areas, aiding the team with additional focus on planning and team enablement (training / guidance / standardization). This person must be highly detail-oriented and resourceful, focused on producing on-time solutions for a variety of businesses, and have a passion for driving work products to completion.

Responsibilities

• Build and maintain data ingestion pipelines from various media and Partner platforms into data infrastructure
• Clean, standardize, and validate data and work with Vendor partners to ensure fidelity
• Develop ETL / ELT processes to create structured views of media data that tie into other data sources to feed dashboards, reports, and advanced analytics models
• Collaborate with cross-functional teams (IT, Agencies, Vendors) to create seamless data flows, resolve data discrepancies, and implement best practices for data governance
• Build operational checks and alerts that monitor for data ingestion failures or anomalies
• Database maintenance, including data join validation (via UIDs, other data)
• Media channel destinations set-up and maintenance
• Prioritization and documentation of work within issue trackers
• Effectively communicate status of projects to management
• Effectively communicate roadblocks, and identify ways to mitigate risks, escalating at-risk projects to management

The Ideal Candidate

• Enjoys a team-driven environment
• Is accommodating, cooperative, analytical, heads down and introspective
• Handles pressure gracefully with a willingness to switch from one item to the next as priorities change
• Proficiently manages time with flexibility to support interruptions and concurrent, fluid workflows
• Has an affinity for problem solving
• Ability to debug SQL scripts
• Ability to identify and solve data quality issues
• Ability to translate business requirements into technical requirements
• Data modeling techniques and deliverables
• Relational Database Technology
• Create / update / analyze databases, tables, materialized views, stored procedures
• Ability to create and run ad hoc SQL scripts to view and audit / analyze data
• QA process and documentation practices

Education And Experience

• 5+ years of experience in data engineering, database management, or a similar role
• Experience with media performance data
• Demonstrated experience of handling large-scale data ingestion, processing, and integration projects
• Strong analytical and data capabilities with high attention to detail
• Excellent communication and collaboration skills
• Strong organizational skills and the ability to manage competing priorities to meet deadlines.
• Previous analytics, implementation, or QA experience desired, preferably in a Marketing environment
• Demonstrated experience in the development of strategic, logical and creative technical solutions to challenging problems
• Must be able to handle multiple projects simultaneously
• High sense of awareness with a focus on listening
• Aptitude for new concepts, especially as they relate to technology, data, and analytics
• Highly accountable self-starter with the ability to work well within a group, as well as independently
• Bachelor degree in Computer Science, Data Science, Information Technology, Engineering, Economics, Mathematics, Business (with Marketing focus), or Analytics is preferred; Advanced degree is an asset

Desired Technical Skills

• Experience with Oracle and Postgres SQL databases, data warehouses (e.g., Databricks), and / or distributed analysis & query systems (e.g., Spark), including data system design, schema design and maintenance, and performance tuning
• Demonstrated expertise in SQL
• Demonstrated expertise in scripting languages excellent for ETL and / or automation is required
• Python and R expertise are an asset
• Familiarity with JSON libraries, Pandas (Python) and / or tidyverse (R) is an asset
• Working knowledge of data visualization and reporting tools (e.g., Power BI, matplotlib, Seaborn, etc.) and version control systems (Git) are an asset

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

Advertising Services

Referrals increase your chances of interviewing at MRM by 2x

Get notified about new Data Engineer jobs in Toronto, Ontario, Canada .

Richmond Hill, Ontario, Canada 2 hours ago

Software Engineer, Backend (All Levels / All Teams)

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.