Data Manager Architect

Define and implement the target source-to-reporting architecture.

Establish raw, staging, transformation, correction, mapping, and reporting layers.

Lead complex Azure Data Factory, Azure SQL, Power BI, Logic App and Python development.

Establish dynamic source-file selection and remove hardcoded file dependencies.

Define processed-file history, ingestion timestamps, run controls, and audit requirements.

Establish governance for mapping tables, corrections, exceptions, and business-rule changes.

Lead complex troubleshooting and root-cause analysis.

Define acceptance criteria, technical standards, testing requirements, and operational service levels.

Coordinate decisions across Media Operations, Media Effectiveness, Planning, Broadcast, and supporting teams.

Provide technical oversight, code review, and coaching junior team members.

Own production transition, stakeholder acceptance, and the future automation roadmap.

Vacancy: Is this posting for the purposes of filling an existing vacancy [ Y /N]

The salary range for this position is $90k-105k. Actual salary within the salary range will be based on a variety of factors including relevant experience, knowledge, and skills. A range of medical, dental, RRSP, paid time off, and/or other benefits also are available to all permanent employees.

AI Disclosure: [ dentsu ] utilizes artificial intelligence tools as part of its recruitment process, as during the sourcing and screening stages. All other parts of the dentsu application and hiring processes do not utilize artificial intelligence tools.

We know through experience that different ideas, perspectives and backgrounds foster a stronger and more creative work environment that delivers better business results. We strive to create workplaces that reflect the clients we serve and where everyone feels empowered to bring their full, authentic selves to work. We are committed to working with our candidates from all ability levels throughout the recruitment process to ensure that they have what they need to be at their best. If you need accommodation during the application or interview process, please contact Canada.Recruitment@dentsu.com or to begin a conversation about your individual accessibility needs throughout the hiring process.