IT Finance & Accounting Business Analyst

CGI; Montreal; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading IT consulting firm is seeking a Finance & Accounting Business Analyst in Montreal. This role involves developing reporting specifications and collaborating with the Power BI team. Candidates should have a bachelor's degree in finance or accounting and at least 5 years of experience. Bilingual proficiency in French and English is required, and experience with pension funds is a plus. Join a dynamic team focused on growth and well-being through personalized training and flexible work arrangements.

Benefits

Competitive compensation

Flexible work arrangements

Personalized training programs

Qualifications

• Minimum 5 years of experience in accounting and systems analysis, with a focus on financial applications.
• Experience working with pension funds or asset management firms is highly desirable.
• Proven ability to align business needs with IT solutions.

Responsibilities

• Develop detailed reporting specifications for data aggregation and visualization.
• Collaborate with the Power BI development team.
• Contribute to User Acceptance Testing (UAT) efforts.

Skills

SQL proficiency

Advanced Power BI skills

Excellent communication skills in French and English

Education

Bachelor’s degree in Accounting, Finance, or a related field

Professional accounting certification (CPA)

Tools

Microsoft SQL Server

Job description

Overview

Position Description: Joining CGI means becoming part of a collaborative, innovative, and people-focused organization. As a Finance & Accounting Business Analyst, you’ll have the opportunity to expand your expertise across diverse technologies while advising major clients on the most effective solutions tailored to their needs. We foster a dynamic team culture built on respect, collaboration, and initiative. At CGI, we prioritize your growth and well-being through personalized training programs, competitive compensation, and flexible work arrangements that support a healthy work-life balance. Are you a skilled Business Analyst with a background in Finance and Accounting? We’d love to meet you—our teams are ready to welcome you!

Responsibilities

• Develop detailed reporting specifications, including required data elements, aggregation logic, calculated fields/formulas, and visualizations.
• Identify and define data elements essential for report development, ensuring data availability and integrity.
• Support the configuration of the SimCorp Investment Management Warehouse (IMW).
• Collaborate with the Power BI development team to translate reporting requirements into actionable deliverables.
• Define and execute test cases for reporting, and assist in resolving defects by providing necessary data and insights.
• Coordinate with Safari teams to facilitate data mapping for downstream applications (e.g., Snowflake).
• Contribute to User Acceptance Testing (UAT) efforts.

Qualifications

Education & Certifications

• Bachelor’s degree in Accounting, Finance, or a related field—or an equivalent combination of education and experience.
• Professional accounting certification (e.g., CPA) is a strong asset.

Experience

• Intermediate to Senior-level experience.
• Minimum 5 years of experience in accounting and systems analysis, with a focus on financial applications and/or BI/analytics solutions.
• Experience working with pension funds or asset management firms is highly desirable.
• Proven ability to align business needs with IT solutions, fostering agile, reusable, and sustainable approaches across teams.

Skills & Competencies

• Strong proficiency in SQL for data analysis and mining.
• Advanced skills in Power BI for financial reporting.
• Solid understanding of traditional database infrastructure, including Windows and Microsoft SQL Server.
• Excellent communication skills in both French and English (spoken and written).

Location

Montréal

Language requirements: Bilingualism (French and English) is required for this position due to interactions with domestic and global clients.

What you can expect from us

Together, as owners, let’s turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because you are invited to be an owner from day 1 as we work together to bring our Dream to life. CGI Partners value collective success and actively shape the company’s strategy and direction. Your work creates value by developing innovative solutions and building relationships with teammates and clients while accessing global capabilities to scale ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide opportunities to deepen skills and broaden horizons.

CGI values diversity and is committed to fostering a workplace where everyone belongs. We collaborate with clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, performing your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter. For accessibility information, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our team—one of the largest IT and business consulting services firms in the world.