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

CBC/Radio-Canada•Montreal, QC

1d•Hybrid

About The Position

Behind the scenes, but ahead of the curve: help us develop the next-generation public service media organization. Technology & Infrastructure (T&I) is the backbone and the future-forward arm of CBC/Radio-Canada. Our purpose is to constantly innovate to evolve and maintain the Corporation’s technology and infrastructure. We are the people that make stuff work. We make connections between media content, systems, people and places. We are the space in between. A place with purpose. CBC/Radio-Canada has always been a highly regarded pioneer of media technology — not just in Canada but around the world. Today, we are transforming ourselves into a modern and agile public service media organization. Technology is the driving force, and we are the team making it happen. This is a hybrid position with a mix of in-office and remote work. Work arrangements will be discussed with hiring managers per departmental guidelines. Location: Toronto, Ottawa or Montreal. The Strategic Objective We are orchestrating a large-scale migration of our enterprise data infrastructure. Our goal is to decommission our On-Premise IBM Cognos and Informatica ETL stack, transitioning all data assets into Microsoft Fabric / Power BI. This role is the functional heartbeat of that migration. You will ensure that as we move from Informatica pipelines to Fabric, no business logic is lost, and our users are empowered to transition seamlessly into a Power BI self-service ecosystem.

Requirements

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 the Microsoft Power Platform stack (Power BI, Power Apps, Power Automate) to champion our transition toward user self-service.
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.
Bachelor’s degree in Computer Science, Business Administration, or a related College Diploma with equivalent professional experience.
Exceptional ability to use technical terminology with IT teams while using "everyday language" to gain buy-in and alignment from business partners.
Strong attention to detail and enjoy digging into a legacy mapping to find that one hidden transformation rule that makes the business run.
Thrive in a dynamic environment where processes are evolving. Value change as an opportunity for efficiency and are passionate about helping users embrace self-service analytics.
Highly organized with the proven ability to manage multiple high-priority initiatives simultaneously under tight deadlines.

Nice To Haves

CBIP, IIBA (CCBA/CBAP), or PMI-PBA certifications.

Responsibilities

Analyze existing workflows to extract complex business transformation rules.
Create the Source-to-Target Mappings (STM) that developers will use to build in Microsoft Fabric.
Understand how the Cognos package is constructed to identify how we migrate to Power BI, including legacy Cognos reports.
Use Postman and your understanding of REST APIs to facilitate discussions between the business and developers regarding modern data integrations.
Translate high-level business needs into technical User Stories and Acceptance Criteria in Jira, ensuring developers have a "zero-ambiguity" roadmap.
Lead User Acceptance Testing (UAT) to ensure that the data landing in Fabric matches the legacy Informatica/Cognos outputs perfectly.