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