Data Architect Lead - Azure & Power BI Expert

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

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