Assess, streamline, redesign and rebuild existing Cognos reporting assets in Power BI
Collaborate with business users, data teams, technology partners and reporting leads
Identify current reporting needs and document data and business logic
Validate source-to-target mappings
Create Power BI reports and semantic models that comply with EDC standards for governance, performance, usability and maintainability
Analyze Cognos reports, folders, queries, calculations, filters, security requirements and usage patterns
Identify redundant or low-value reports and recommend consolidation, redesign or retirement
Document logic, layouts, data sources, mappings, dependencies and business rules
Design reports, dashboards, paginated reports and semantic models in Power BI
Transform and validate data using SQL, Power Query, DAX and approved data sources
Support user acceptance testing, reconcile Cognos and Power BI, analyze variances and document results
Collaborate with data engineering, architecture, governance and platform teams
Prepare inventory updates, technical documentation, user guides and knowledge transfer materials
Contribute to migration planning, prioritization, status reporting, and issue and risk tracking
Support production deployment, post-implementation validation and transition to ongoing support

Requirements
Bachelor’s degree in business, computer science, management information systems, data analytics, finance or a related discipline, or an equivalent combination of education and experience
At least 7 years of experience in business intelligence, reporting and data analytics, including developing large-scale reporting or analytics solutions on enterprise analytics platforms such as Cognos, Tableau or Power BI
Experience developing reports, dashboards, semantic models or paginated reports in Power BI
Experience with Microsoft Fabric
Experience analyzing,



reverse-engineering or migrating reports from IBM Cognos Analytics to Power BI
Robust SQL skills and experience working with relational databases, data marts, data warehouses or enterprise data platforms
Proven ability to gather requirements, document business logic, validate results and communicate findings to technical and business audiences
Experience supporting report testing, reconciliation, defect resolution and stakeholder sign-off
Candidates must meet government security requirements
Preference will be given to candidates legally authorized to work in Canada at the time of application
Assets: experience in financial services, banking or insurance; data governance; metadata; lineage; report inventory management; Azure DevOps; Agile methodologies; proficiency in both official languages

Core Competencies
Demonstrates expertise in Power BI report development, data transformation using SQL and DAX, and effective collaboration with cross-functional teams to meet business intelligence needs. Proven ability to analyze and migrate reporting assets from Cognos to Power BI while ensuring compliance with governance standards.

Highest-signal resume keywords
Power BI Report Development
SQL Proficiency
Cognos to Power BI Migration
Data Governance
Business Intelligence Solutions

ATS Optimization Keywords
Hard Skills
Power BI
SQL
DAX
Power Query
Cognos Analytics
Data Analysis
Report Development
Semantic Models
Data Validation
Report Testing

Soft Skills
Collaboration
Communication
Documentation
Problem-Solving
Stakeholder Engagement

Industry Keywords
Business Intelligence
Data Analytics
Financial Services
Banking
Insurance
Data Governance
Metadata
Lineage
Report Inventory Management
Agile Methodologies

Tools & Technologies
Microsoft Fabric
Azure DevOps
Enterprise Data Platforms
Data Warehouses
Data Marts

#J-18808-Ljbffr

📌 Senior Reporting Analyst – 15 Months (Quebec City)
🏢 Jobtailor
📍 Quebec City