Business Intelligence Developer

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

Job Description

MRM Worldwide 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.

Agency

Omnicom Precision Marketing

Job Function

Data and Analytics

Job Subfunction

Data Science and Analytics

Job Description

MRM Worldwide 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.

About The Role

The Business Intelligence Developer is responsible for building, maintaining, and explaining the interpretation of Dashboards for a media analytics team serving multiple Brand Marketing Teams. You will be responsible for reporting lifecycle - from ETL work that transforms cloud-based analytics data into dashboard-ready structures, to defining KPI standards, maintaining data quality, and leading stakeholders through the interpretation of results.

You will work closely with our media analytics and market research teams to translate broad business objectives into focused, regularly refreshed dashboards that drive actionable outcomes. You will also collaborate with Global analytics teams to leverage best practices, incorporate new data sources, and build regionally specific views of global dashboards and analyses.

Responsibilities

• Design, build, and maintain Power BI dashboards and report solutions for media performance, and enterprise-wide marketing and business performance.
• Design and maintain robust data models and KPI logic, applying best practices in dimensional modeling, DAX, and Power Query to create clear, governed, and scalable reporting solutions.
• Apply knowledge of paid media KPIs, channel structures, and campaign taxonomies to ensure dashboards accurately reflect business intent and support meaningful performance interpretation.
• Translate analysis and standardized marketing KPIs into visualizations that clearly and succinctly communicate outcomes and context of marketing activities to stakeholders.
• Own end-to-end data QA and reconciliation by validating dashboard outputs against multiple source data and cross functional tools.
• Lead and support stakeholder conversations on how to interpret dashboards, build training and help materials, and document dashboard construction and formulas.
• Drive continuous improvement of team reporting capabilities with the goal of enabling stakeholders to reliably self-serve their own reporting needs.
• Manage dashboard enhancement requests, blockers, and external dependencies, providing clear status updates and prioritization across business and technical partners.

Education And Experience

• Bachelor of Engineering or Science with majors in Business (Analytics), Social Sciences, Mathematics (Statistics), or Computer Science.
• 3+ years of experience in a Business Visualization role.
• Demonstrated expertise in Power BI is required: experience with other Business Visualization tools is an asset.
• Demonstrated experience applying statistical analysis to datasets and communicating results clearly to business stakeholders; ability to story-tell from data is a strong asset.
• Strong SQL experience with a cloud-based or server-based database system (such as Databricks, Oracle, SQL Server, or Postgres) is required. Databricks experience is preferred.
• Demonstrated understanding of ETL processes and data pipeline concepts, with hands-on experience preparing and transforming data for visualization using Power Query, dataflows, or semantic model development within the BI layer.
• Experience with digital media analytics and reporting is an asset.
• Highly accountable self-starter with strong verbal and written communication skills; able to manage multiple priorities simultaneously and adapt as business requirements and technologies evolve.

MRM//McCann is an equal opportunity employer and does not discriminate on the basis of race, color, gender, religion, age, sexual orientation, national or ethnic origin, disability, marital status, veteran status, or any other occupationally irrelevant criteria.

$110,000

Omnicom’s policy requires employees to work in the office for a minimum of three days a week, unless additional in-office days are directed by their agency or manager. Our objective is to increase this requirement over time, and many of our agencies as well as Omnicom’s corporate group already require five days of in-office attendance.

Omnicom is committed to hiring and developing exceptional talent. We agree that talent is uniquely distributed, and we’re focused on developing inclusive teams that can bring the best solutions to everything we do. We strongly believe that celebrating what makes us different makes us better together. Join us—we look forward to getting to know you. We will process your personal data in accordance with our Recruitment Privacy Notice.

Link to Recruitment Privacy Notice: https://www.omc.com/privacy-notice/,
$110,000