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.

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

• Bachelors 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.

Additional Information :

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  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 Ontarios 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 .

Remote Work :

Yes

Employment Type :

Full-time