Senior Reporting Analyst – 15 Months

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 Strong 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