{bc}
Apply
linkedin

Senior Business Analyst, Data & Analytics, Data Transformation & Migration (T & I) (Telework/Hybrid)

Radio-Canada
Montreal, CAN
Contract
Senior
Hybrid
5 days ago
Data MigrationETL MappingMicrosoft FabricPower BIIBM CognosInformatica
Free

Job Fit Check

Base Career helps you apply smarter for this job.

?%
Ready to Scan

Key skills for this role

Data MigrationETL MappingMicrosoft Fabric
Smart Apply

Full Job Posting

Position Overview

  • Senior Business Analyst, Data & Analytics, Data Transformation & Migration (T & I) (Telework/Hybrid)
  • Contractee Long Term (Durée déterminée) position at CBC/Radio Canada
  • Language requirement: English and French

About CBC/Radio Canada

  • CBC/Radio Canada creates content that informs, entertains and connects Canadians on multiple platforms.
  • Technology & Infrastructure (T&I) is the backbone and future forward arm of CBC/Radio Canada.

Work Arrangement

  • Hybrid position with a mix of in office and remote work.
  • Location: Toronto, Ottawa or Montreal.

Strategic Objective

  • Orchestrating a large scale migration of enterprise data infrastructure from On Premise IBM Cognos and Informatica ETL to Microsoft Fabric / Power BI.
  • This role is the functional heartbeat of that migration.

Key Responsibilities

  • ETL Functional Mapping: Analyze existing workflows to extract complex business transformation rules and create Source to Target Mappings (STM) for Microsoft Fabric.
  • Legacy Deconstruction: Understand how the Cognos package is constructed to identify migration to Power BI, including legacy Cognos reports.
  • API Validation: Use Postman and REST APIs to facilitate discussions between business and developers regarding modern data integrations.
  • Requirements Analysis: Translate high level business needs into technical User Stories and Acceptance Criteria in Jira.
  • UAT & Data Integrity: Lead User Acceptance Testing (UAT) to ensure data in Fabric matches legacy Informatica/Cognos outputs.

Technical Toolkit

  • 3+ years of proven experience mapping data logic from legacy ETL (Informatica) to modern cloud data platforms (Fabric).
  • Functional experience navigating Microsoft Fabric is a strong asset.
  • Deep functional understanding of IBM Cognos (Framework Manager) to extract legacy reporting logic.
  • Strong proficiency in Microsoft Power Platform stack (Power BI, Power Apps, Power Automate).
  • SQL Mastery (Joins, Window Functions, querying complex views).
  • Familiarity with Postman/APIs for modern data ingestion sources.
  • Expert level Source to Target Mappings (STM), Data Dictionaries, and translating legacy logic into clear Jira User Stories.

Education & Certifications

  • Bachelor’s degree in Computer Science, Business Administration, or a related College Diploma with equivalent professional experience.
  • Certifications (Highly Valued Assets): CBIP, IIBA (CCBA/CBAP), or PMI PBA certifications.

Who You Are

  • The 'Bridge': Ability to use technical terminology with IT teams while using everyday language with business partners.
  • The Logic Detective: Strong attention to detail and enjoyment in digging into legacy mappings.
  • The Change Advocate: Thrives in a dynamic environment and passionate about helping users embrace self service analytics.
  • The Performer: Highly organized with proven ability to manage multiple high priority initiatives simultaneously under tight deadlines.

Why This Role?

  • Cutting Edge: Be at the forefront of a Microsoft Fabric implementation.
  • High Visibility: This migration is a top tier organizational priority with direct impact on decision making capabilities.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today