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