Analyze existing workflows to extract complex business transformation rules.
Responsible for creating 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 to migrate to Power BI, including legacy Cognos reports.
Facilitate discussions between the business and developers regarding modern data integrations using Postman and an understanding of REST APIs.
Lead User Acceptance Testing (UAT) to ensure that the data landing in Fabric matches the legacy Informatica/Cognos outputs perfectly.

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).
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.
Certifications (Highly Valued Assets): CBIP, IIBA (CCBA/CBAP), or PMI-PBA certifications.

High visibility: this migration is a top-tier organizational priority with direct impact on decision-making capabilities.
Opportunity for efficiency and helping users embrace self-service analytics.

Senior Business Analyst, Data & Analytics, Data Transformation & Migration

Key skills