Media Data Engineer

MRM McCANN; Toronto; On-site; CAD 120,000 - 190,000; Full time

Job summary

A leading digital marketing agency in Toronto is seeking a Media Data Engineer. This role requires building data ingestion pipelines and developing ETL processes. Ideal candidates will have over 5 years of experience in data engineering, proficiency in SQL, and strong analytical skills. This position offers the opportunity to work collaboratively on innovative data solutions in a fast-paced environment.

Benefits

Collaborative work environment

Opportunity for growth

Innovative projects

Qualifications

• 5+ years of experience in data engineering or database management.
• Experience with media performance data is a plus.
• Ability to manage multiple projects and prioritize effectively.

Responsibilities

• Build and maintain data ingestion pipelines from various media platforms.
• Develop ETL/ELT processes to create structured views of media data.
• Collaborate with cross-functional teams to resolve data discrepancies.

Skills

Problem solving

SQL debugging

Time management

Communication

Analytical skills

Education

Bachelor's degree in Computer Science, Data Science or related field

Tools

Postgres SQL

Spark

Power BI

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)
• Audience segmentation set-up
• 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

Has strong communication skills

Ability to translate business requirements into technical requirements

Is Familiar With

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

Industries

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)

Toronto, Ontario, Canada CA$120,000.00-CA$190,000.00 2 weeks ago

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.

J-18808-Ljbffr