Power BI Dashboard Engineer for Marketing Analytics

Omnicom Precision Marketing Group; Toronto; On-site; CAD 99,000 - 121,000; Full time

Job summary

Omnicom Precision Marketing seeks a Business Intelligence Developer to build and maintain dashboards for a media analytics team. You will transform cloud-based data into dashboard-ready structures and define KPI standards.

Collaborate with global analytics teams to create region-specific views, ensure data quality, and support stakeholders with insights through Power BI and SQL-based models.

Qualifications

• Bachelor degree in Engineering/Science with analytics focus; 3+ years in a business visualization role.
• 3+ years of experience in a Business Visualization role.
• Power BI expertise required; knowledge of other BI tools is an asset.
• Strong SQL experience with cloud or server databases; Databricks preferred.

Responsibilities

• Design, build, and maintain Power BI dashboards for media performance.
• Design and maintain robust data models and KPI logic using DAX and Power Query.
• Apply knowledge of paid media KPIs and campaign taxonomy to dashboards.
• Translate analytics into visualizations that clearly communicate outcomes to stakeholders.
• Own end-to-end data QA and reconcile dashboard outputs across sources.
• Lead stakeholder conversations and develop training materials on dashboards.
• Drive continuous improvement of team reporting capabilities for self-serve analytics.
• Manage dashboard enhancement requests and dependencies with clear prioritization.

Skills

Power BI

SQL

Data Visualization

ETL

Data Modeling

Education

Bachelor's degree in Engineering or Science

Tools

Databricks

SQL Server

Postgres

Power Query

Job description

Omnicom Precision Marketing seeks a Business Intelligence Developer to build and maintain dashboards for a media analytics team. You will transform cloud-based data into dashboard-ready structures and define KPI standards.

Collaborate with global analytics teams to create region-specific views, ensure data quality, and support stakeholders with insights through Power BI and SQL-based models.