Canadian Bank Note Company

Data Analytics Engineer - Corporate Data Analytics Group

Canadian Bank Note Company • $80K — $110K *
Ottawa, ON K1G 3J6In-Person
Information Technology
8 - 10 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Legally eligible to work in Canada.
  • Fluent in English (speak, read, write).
  • Ability to obtain and maintain Government of Canada Secret (Level II) security clearance.
  • Bachelor's degree in Computer Science, Data Science, Information Systems, Engineering, or related field.
  • 8+ years of experience in analytics, BI, or data modeling, including 3+ years with Power BI and SQL.

Responsibilities

  • Partner with business stakeholders to create structured data representations.
  • Design and maintain semantic models to reflect business meaning across data domains.
  • Collaborate with data engineers to refine datasets for clarity and AI use.
  • Develop and optimize Power BI models and datasets for analytics.
  • Implement data governance controls for security and integrity of data.
  • Publish semantic models to support self-service and AI analytics.
  • Monitor and enhance performance of data models for efficiency.

Benefits

  • Flexible remote work model.
  • Participation in a Data & AI Community of Practice for continuous learning.
Full Job Description
Internal Job Title: Data Analytics Engineer

Job Type: Permanent, Full-time

Location: Ottawa, Ontario

Work Model: Remote

Job Status: Existing Vacancy

Position Summary

The Data Analytics Engineer plays a critical role in preparing enterprise data to be AI-ready by designing rich semantic layers and business context that enable advanced analytics, self-service BI, and AI-powered decision-making. This role focuses on transforming curated data into trusted, governed, and reusable data products that can be safely consumed by business users, copilots, and machine learning models across the organization.

Key Responsibilities

Business Partnership & Domain Alignment
  • Partner with business stakeholders to translate domain knowledge into structured analytical and semantic representations.

Semantic Modeling & Data Foundation
  • Design, develop, and maintain enterprise semantic models that represent business meaning, metrics, and relationships across data domains.
  • Collaborate with data engineers to shape silver and gold datasets that support semantic clarity and downstream AI consumption.
  • Build AI-ready data products by enriching datasets with business definitions, hierarchies, metadata, and contextual logic.

BI Development & Metric Standardization
  • Develop and optimize Power BI semantic models, datasets, and metric layers to support BI, Copilot, and AI use cases.
  • Create and manage standardized KPIs and calculations using DAX, ensuring consistency and reuse across analytics and AI workloads.
  • Document business logic, data definitions, and metric context to support discoverability and AI-assisted querying.

Governance, Security & Trusted Data
  • Implement data governance controls including row-level security (RLS), object-level security, sensitivity labels, and certified datasets.

Data Product Enablement & AI Integration
  • Publish trusted semantic models and datasets to enable self-service and AI-assisted analytics at scale.
  • Support integration of analytics models with AI and ML workflows, including retrieval-augmented generation (RAG) scenarios.

Performance Optimization & Reliability
  • Monitor and optimize model performance, refresh reliability, and query efficiency.

Standards & Continuous Improvement
  • Contribute to analytics and AI standards and best practices through the Data & AI Community of Practice.


Qualifications

Mandatory Requirements
  • Legally eligible to work in Canada.
  • Fluent in English (speak, read, write).
  • Able to obtain (in a timely manner) and maintain Government of Canada Secret (Level II) security clearance.

Minimum Qualifications
  • Bachelor's degree in Computer Science, Data Science, Information Systems, Engineering, or a related field.
  • Understanding of the following:
    • Semantic modeling concepts including metrics, hierarchies, and dimensional modeling.
    • Data governance principles and secure data access patterns.
  • 8+ years of relevant professional experience, including:
    • 3+ years of professional experience in analytics, business intelligence, or data modeling roles.
    • 3+ years of hands-on experience with Power BI semantic modeling, DAX, and dataset design.
    • 3+ years of experience working with SQL-based analytical datasets.
    • Ability to translate business concepts into structured analytical and semantic representations.

Preferred Qualifications
  • Microsoft Certifications:
    • Power BI Data Analyst Associate (PL-300) or Fabric Analytics Engineer Associate (DP-600).
  • Knowledge of data catalogs, business glossaries, and metadata management.
  • Experience with the following:
    • Microsoft Fabric semantic models, OneLake, and data products.
    • Preparing datasets for AI/ML or Copilot scenarios (e.g., feature tables, RAG inputs).
    • Manufacturing, software, or regulated environments.

About Canadian Bank Note Company

The Canadian Bank Note Company is a security printing company that produces banknotes, passports, and other secure documents for governments and central banks around the world. The company was founded in 1897 and is headquartered in Ottawa, Canada. Canadian Bank Note Company has a global presence with operations in North America, Europe, Africa, and Asia. The company's products include banknotes, passports, driver's licenses, and other secure documents. Canadian Bank Note Company is known for its high-quality printing and security features, which help prevent counterfeiting and fraud. The company is also involved in the production of lottery tickets and other gaming products.
Learn more about Canadian Bank Note Company
Size
1,500 employees
Industry
Business Services
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Canadian Bank Note Company

More Information Technology Jobs

Find similar Data Analytics Engineer - Corporate Data Analytics Group jobs:

NationwideOttawa, ON