Media Data Engineer

MRM • Toronto, Ontario, Canada • 11h ago

Job Description

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

Related Jobs

Project Engineer/ Group manager - Wastewater

Aecom • Mississauga, Ontario, Canada • 23min ago

Engineer

23min ago

Senior Transportation Project Engineer

Chisholm Fleming And Associates • Markham, Ontario, Canada • 7h ago

Engineer

7h ago

AWS Cloud Platform & DevOps Engineer

OnX • Toronto, Ontario, Canada • 8h ago

Engineer

8h ago

Sr. Staff Engineer

Qualcomm • Markham, Ontario, Canada • 8h ago

Engineer

8h ago

Intermediate Drainage Design Engineer

Arcadis • Toronto, Ontario, Canada • 8h ago

Engineer

8h ago

Sr. Engineer, Thermal Design

Tenstorrent • Toronto, Ontario, Canada • 8h ago

Engineer

8h ago

Senior Enterprise Application Engineer, Application Administrator- ITS Digital Identity - PNRK

Humber College • Toronto, Ontario, Canada • 8h ago

Engineer

8h ago

AWS Cloud Platform & DevOps Engineer

OnX • Toronto, Ontario, Canada • 8h ago

Engineer

8h ago

Sr. Engineer, Thermal Design

Tenstorrent • Toronto, Ontario, Canada • 8h ago

Engineer

8h ago

Sr. Staff Engineer

Qualcomm • Markham, Ontario, Canada • 8h ago

Engineer

8h ago