Data Analytics Engineer - Corporate Data Analytics Group

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.

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.

Equal Opportunity Statement

Our organization is committed to employment equity and diversity in the workplace. We actively encourage applications from women, Indigenous Peoples, persons with disabilities, members of visible minorities, and LGBTQ2+ individuals.

We are dedicated to removing barriers and fostering an inclusive workplace that reflects society and we are committed to providing an accessible and inclusive recruitment process in accordance with the Accessibility for Ontarians with Disabilities Act (AODA).

If you require accommodation at any stage of the hiring process, please contact us at recruitment@cbnco.com so that appropriate arrangements can be made.

AI Use in Recruitment Statement

As part of our commitment to transparency and fairness in hiring, we disclose that artificial intelligence (AI) tools may be used at certain stages of our recruitment process. These tools assist in tasks such as resume screening, candidate matching, and interview scheduling. All AI-assisted decisions are subject to human oversight to ensure fairness, accuracy, and compliance with applicable laws.

We are committed to the responsible, transparent, and accountable use of AI, in alignment with Ontario’s Responsible Use of Artificial Intelligence Directive and the requirements under the Working for Workers Four Act. This includes taking steps to mitigate bias, protect candidate privacy, and ensure that AI does not unfairly influence hiring outcomes.

If you have questions or concerns about how AI is used in our hiring process, please contact us at recruitment@cbnco.com .