Senior Business Analyst, Data & Analytics, Data Transformation & Migration (T & I) (Telework/Hybrid)
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
CBC/Radio-Canada seeks a Senior Business Analyst for a large-scale data migration from IBM Cognos/Informatica to Microsoft Fabric/Power BI. You will deconstruct legacy ETL logic, create source-to-target mappings, and lead UAT.
Key Skills for This Role
Responsibilities
- Analyze existing workflows to extract complex business transformation rules and create Source to Target Mappings for developers
- Understand how the Cognos package is constructed to identify how we migrate to Power BI, including legacy Cognos reports
- Use Postman and understanding of REST APIs to facilitate discussions between business and developers regarding modern data integrations
- Translate high level business needs into technical User Stories and Acceptance Criteria in Jira
- Lead User Acceptance Testing (UAT) to ensure data landing in Fabric matches legacy Informatica/Cognos outputs perfectly
Requirements
- 3+ years of proven experience mapping data logic from legacy ETL (Informatica) to modern cloud data platforms (Fabric)
- 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
- Bachelor’s degree in Computer Science, Business Administration, or related College Diploma with equivalent professional experience
Full Job Posting
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
The Role: Business First, Tech Fluent
- This is a Data & Analytics Business Analyst role with a technical edge
- You are not the one building the pipelines or the reports, but you must 'speak the language' of the developers
- You will spend your time deconstructing legacy ETL logic and documenting the functional requirements that will define our future state data lakehouse
Key Responsibilities
- ETL Functional Mapping: Analyze existing workflows to extract complex business transformation rules. You will be responsible for creating the Source to Target Mappings (STM) that developers will use to build in Microsoft Fabric
- Legacy Deconstruction: Understand how the Cognos package is constructed to identify how we migrate to Power BI, including legacy Cognos reports
- API Validation: Use Postman and your understanding of REST APIs to facilitate discussions between the business and developers regarding modern data integrations
- Requirements Analysis: Translate high level business needs into technical User Stories and Acceptance Criteria in Jira, ensuring developers have a 'zero ambiguity' roadmap
- UAT & Data Integrity: Lead User Acceptance Testing (UAT) to ensure that the data landing in Fabric matches the legacy Informatica/Cognos outputs perfectly
The Technical Toolkit (The 'Translator' Profile)
- Data Migration & Integration: 3+ years of proven experience mapping data logic from legacy ETL (Informatica) to modern cloud data platforms (Fabric)
- Enterprise Data Ecosystems: Functional experience navigating Microsoft Fabric is a strong asset
- Legacy BI: Deep functional understanding of IBM Cognos (Framework Manager) to extract legacy reporting logic
- Low Code & Future State BI: Strong proficiency in the Microsoft Power Platform stack (Power BI, Power Apps, Power Automate) to champion our transition toward user self service
- Technical Validation: SQL Mastery (Joins, Window Functions, querying complex views). Familiarity with Postman/APIs for modern data ingestion sources
- Documentation: Expert level Source to Target Mappings (STM), Data Dictionaries, and translating legacy logic into clear Jira User Stories
Education & Certifications
- Education: 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': You possess an exceptional ability to use technical terminology with IT teams while using 'everyday language' to gain buy in and alignment from business partners
- The Logic Detective: You have a strong attention to detail and enjoy digging into a legacy mapping to find that one hidden transformation rule that makes the business run
- The Change Advocate: You thrive in a dynamic environment where processes are evolving. You value change as an opportunity for efficiency and are passionate about helping users embrace self service analytics
- The Performer: You are highly organized with the proven ability to manage multiple high priority initiatives simultaneously under tight deadlines
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.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at CBC/Radio-Canada
Product Director, OTT (French Services) (Telework/Hybrid)
Montréal, CAN
CBC/Radio-Canada seeks a Product Director to co-lead the OTT product group, aligning strategy for Tou.TV and CBC Gem. The role involves setting product strategy, managing product managers, and collaborating cross-functio
Directeur ou directrice de produits, plateformes de contournement (Services français) (télétravail/hybride)
Montréal, CAN
CBC/Radio-Canada recherche un directeur ou une directrice de produits pour codiriger le groupe de produits liés aux plateformes de contournement (ICI TOU.TV et CBC Gem). Vous serez responsable de la stratégie produit, de
Senior Analyst, Project Manager (French Services) (Telework/Hybrid)
Montreal, CAN
CBC/Radio-Canada seeks a Senior Analyst, Project Manager for French Services to plan and coordinate advertising and promotional campaigns for Radio-Canada's channels and platforms. Requires a bachelor's degree and 5+ yea
Manager, Release Management & Testing, Oracle Fusion Cloud (Finance) (English Services) (Hybrid/Telework)
Ottawa, CAN
CBC/Radio-Canada is seeking a Manager of Release Management & Testing for Oracle Fusion Cloud Finance systems. This two-year contract role leads release planning, testing governance, and digital adoption initiatives. Req
Interactive Designer, Digital Products (French Services) (Telework/Hybrid)
Montréal, CAN
CBC/Radio-Canada seeks an Interactive Designer to create digital experiences for websites, apps, and other platforms. You will analyze project needs, develop UX/UI designs, create prototypes, and collaborate with teams t
Product Director, OTT (French Services) (Telework/Hybrid)
Montréal, CAN
Directeur ou directrice de produits, plateformes de contournement (Services français) (télétravail/hybride)
Montréal, CAN
Senior Analyst, Project Manager (French Services) (Telework/Hybrid)
Montreal, CAN
Manager, Release Management & Testing, Oracle Fusion Cloud (Finance) (English Services) (Hybrid/Telework)
Ottawa, CAN
Interactive Designer, Digital Products (French Services) (Telework/Hybrid)
Montréal, CAN