Data Analytics Engineer - Corporate Data Analytics Group

## Company Description [Canadian Bank Note Company (CBN)](https://cbnco.com/) is a leader and trusted provider of secure document and adjacent enterprise-level system solutions across the following domains: border security, civil identity, driver licence/identification and vehicle information, excise control, currency, lotteries and charitable gaming. Our [Corporate Philosophy](https://cbnco.com/CBN_booklet.pdf) and 7 Core Principles shape and guide our corporate behaviours and underpin the sense of community you will experience at CBN. We seek long-term relationships with our employees and offer a competitive compensation package that includes health, medical and life insurance benefits and a defined contribution pension plan with company matching. ## 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 expe…