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

Solid 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

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