Senior Fund Analyst overseeing fund accounting, NAV valuation, audits, and financial reporting at Bank of Montreal. Fully remote role supporting accurate regulatory and management reporting.
EC
Senior Reporting Analyst – 15 Months
Posted last week
About the role
- Analyste principal(e) migrant et modernisant les rapports Cognos vers Power BI/Fabric chez EDC, organisme canadien de financement du commerce. Conception de rapports, validation des données et soutien au déploiement.
Responsibilities
- 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
Benefits
- Competitive compensation and benefits package
- Various hybrid work options
- Three to four weeks of vacation
- Organization-wide shutdown period
- Shorter summer Fridays
- Meeting-free Fridays
- Ongoing learning opportunities, training programs and workshops
- Language training
- Diverse and inclusive workplace
- Wellness initiatives
- Mental health support
- Fitness programs
- Volunteer activities and social responsibility programs
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Business Intelligence Manager leading Power BI and Databricks analytics for Apotex, a Canadian pharmaceutical company. Championing AI use cases, automation, and data - driven decision - making.
EC
Senior Reporting Analyst modernizing Export Development Canada’s Cognos reporting ecosystem into Power BI/Fabric. Building governed reports and semantic models for trusted business decisions.
Financial Reporting Analyst supporting Finning Canada’s receivables analytics, forecasting, and reporting. Improving financial systems, KPIs, governance, and automation for business decision - making.
Business Intelligence Student analyzing data and building dashboards for Bird Construction. Supporting KPI monitoring, data validation, and data - driven recommendations during an 8 - month co - op.
Business Intelligence intern developing dashboards, reports, and data visualizations for TD, a global financial institution. Applying Azure, SQL, Tableau, Power BI, and Python to banking analytics.
TD Business Intelligence Associate developing dashboards, reporting automation, and data insights for a leading Canadian bank. Using Python, SQL, Power BI, Azure, and Databricks in a 12 - month program.
Sales Reporting Analyst delivering sales, margin, and profitability insights for Essity, a global health and hygiene company. Supporting financial reporting, distributor data, and business controls.
LP
Intermediate Business Analyst
LinkedIn Recruiter Post
Hiring: Intermediate Business Analyst | Winnipeg, MB | Multiple Openings I’m currently seeking Intermediate Business Analysts for a leading manufacturing organi
LP
Network/Systems Analyst
LinkedIn Recruiter Post
We’re hiring! Looking for a Network/Systems Analyst to join our team in Mississauga, ON. 📍 Full - time | OPSEU represented 💰 $33.83 - $41.64/hr ⏰ 36.25 hours/week I