Data Manager Architect

Dentsu Aegis Network Ltd.; Toronto; Hybrid; CAD 90,000 - 105,000; Full time

Job summary

Dentsu Aegis Network Ltd. is seeking a Manager, Data Architect in Toronto to lead end-to-end data architecture, governance, and delivery of enterprise data solutions.

You will guide the team in designing, building, debugging, and optimizing data platforms using Azure, Power BI, and Python while ensuring production readiness and stakeholder alignment. The role demands hands-on leadership, strong analytics focus, and exceptional communication with executives and cross-functional partners to drive

Qualifications

• 5+ years in data engineering, analytics engineering, BI architecture, or related roles.
• Proficient in Advanced SQL, Azure Data Factory, Azure SQL, Power BI, DAX, Python, Databricks.
• Experience delivering production data platforms under compressed timelines.
• Strong data modelling, governance, reconciliation, lineage, and operational-control experience.
• Strong executive communication and stakeholder-management capabilities.

Responsibilities

• Define and implement the target source-to-reporting architecture.
• Lead complex Azure Data Factory, Azure SQL, Power BI, Logic App and Python development.
• Establish governance for mapping tables, corrections, exceptions, and business-rule changes.
• Own production transition, stakeholder acceptance, and the future automation roadmap.
• Coordinate decisions across Media Operations, Media Effectiveness, Planning, Broadcast, and supporting teams.
• Provide technical oversight, code review, and coaching junior team members.

Skills

Advanced SQL

Azure Data Factory

Azure SQL

Power BI

DAX

Python

Databricks

Executive communication

Stakeholder management

Tools

Azure Data Factory

Azure SQL

Power BI

Databricks

Job description

Our mission is to Drive Business Performance. We use data to create personalized and connected experiences that deliver transformative business outcomes. Our role is to ensure our clients meet their quantifiable business goals every day, consistently, in every market. We are entirely focused on delivering better business results through optimization, creation and analysis across all digital platforms. Our scope ranges from recommending how to use content more effectively to optimizing daily media channel performance and maximizing visibility in eCommerce platforms.

The Manager, Data Architect is accountable for the end-to-end architecture, technical direction, governance framework, delivery execution, and production readiness of the enterprise data solution. This is a highly hands-on technical leadership role that requires deep expertise in data engineering, analytics, and business intelligence platforms. The successful candidate will actively design, build, troubleshoot, and optimize solutions while providing technical leadership to the broader team.

Accountabilities

• 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.

Qualifications

• 5+ years in data engineering, analytics engineering, BI architecture, or related roles
• Advanced SQL, Azure Data Factory, Azure SQL, Power BI, DAX, Python, Databricks
• Experience delivering production data platforms under compressed timelines
• Strong data modelling, governance, reconciliation, lineage, and operational-control experience
• Strong executive communication and stakeholder-management capabilities

Additional information

• Salary range: $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

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.

Accessibility Statement

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 [e-mail] or to begin a conversation about your individual accessibility needs throughout the hiring process.

Location, Brand and Contract

• Location: Toronto
• Brand: Dentsu Media
• Time Type: Full time
• Contract Type: Permanent

About dentsu

For over 120 years, innovation has been a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Be a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way.