Senior BI Developer (Power BI & Azure)
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
CGI is seeking a Senior BI Developer to support a financial institution's Global Fraud Technology team. The role involves designing and delivering BI solutions using Power BI, Azure, and SQL Server, including ETL pipelines and data models.
Key Skills for This Role
Responsibilities
- Build best in class Business Intelligence solutions that support the Fraud Analytics product roadmap
- Partner with Product Owners, Business Analysts, Scrum Masters, Project Managers, and stakeholders to deliver scalable BI solutions that meet business objectives
- Translate complex business requirements into technical designs and implementation plans
- Design and optimize logical and physical data models for high volume analytical environments
- Develop and maintain ETL processes using SQL Server Integration Services (SSIS), Azure Data Factory, SQL Server, and Azure SQL Managed Instance
- Conduct data profiling, source to target mapping, and data quality analysis
- Develop and support Power BI reports, datasets, and related data pipelines
- Collaborate with Data Architects, ETL Developers, and Data Analysts to deliver high performing enterprise reporting solutions
- Participate in release management, testing, documentation, code reviews, operational readiness, and production support
- Follow Agile delivery practices and established development standards to ensure high quality solutions
Requirements
- Postsecondary degree in Computer Science, Engineering, Information Technology, or a related discipline
- 5 7 years of experience delivering enterprise Business Intelligence solutions using Microsoft technologies
- Strong expertise in SQL Server, SQL scripting, data analysis, profiling, and data mapping
- Extensive experience with SQL Server Integration Services (SSIS), Integration Services Catalog, and project deployment
- Experience developing ETL solutions using Azure Data Factory and Azure SQL Managed Instance
- Strong understanding of dimensional data modeling and data warehouse design
- Working knowledge of Power BI development, report design, datasets, and semantic models
- Experience supporting Power BI production environments and resolving production incidents
- Experience working in Agile Scrum teams and Azure DevOps pipelines
- Excellent communication skills with the ability to work effectively with both technical and business stakeholders
- Highly organized, collaborative, and comfortable working in a fast paced environment
- Business Intelligence certification is considered an asset
Full Job Posting
Job Overview
- CGI is seeking a Senior BI Developer (Power BI & Azure) to support one of Canada's leading financial institutions within its Global Fraud Technology team.
- Working closely with Product Owners, Business Analysts, Data Architects, and stakeholders, you will design and deliver scalable Business Intelligence solutions across the Microsoft ecosystem.
- This role is hybrid and requires you to be at our downtown Toronto office and/or the client office a minimum of two days per week, subject to change at any time.
Your future duties and responsibilities
- Build best in class Business Intelligence solutions that support the Fraud Analytics product roadmap.
- Partner with Product Owners, Business Analysts, Scrum Masters, Project Managers, and stakeholders to deliver scalable BI solutions that meet business objectives.
- Translate complex business requirements into technical designs and implementation plans.
- Design and optimize logical and physical data models for high volume analytical environments.
- Develop and maintain ETL processes using SQL Server Integration Services (SSIS), Azure Data Factory, SQL Server, and Azure SQL Managed Instance.
- Conduct data profiling, source to target mapping, and data quality analysis.
- Develop and support Power BI reports, datasets, and related data pipelines.
- Collaborate with Data Architects, ETL Developers, and Data Analysts to deliver high performing enterprise reporting solutions.
- Participate in release management, testing, documentation, code reviews, operational readiness, and production support.
- Follow Agile delivery practices and established development standards to ensure high quality solutions.
Required qualifications to be successful in this role
- Postsecondary degree in Computer Science, Engineering, Information Technology, or a related discipline. Business Intelligence certification is considered an asset.
- 5 7 years of experience delivering enterprise Business Intelligence solutions using Microsoft technologies.
- Strong expertise in SQL Server, SQL scripting, data analysis, profiling, and data mapping.
- Extensive experience with SQL Server Integration Services (SSIS), Integration Services Catalog, and project deployment.
- Experience developing ETL solutions using Azure Data Factory and Azure SQL Managed Instance.
- Strong understanding of dimensional data modeling and data warehouse design.
- Working knowledge of Power BI development, report design, datasets, and semantic models.
- Experience supporting Power BI production environments and resolving production incidents.
- Experience working in Agile Scrum teams and Azure DevOps pipelines.
- Excellent communication skills with the ability to work effectively with both technical and business stakeholders.
- Highly organized, collaborative, and comfortable working in a fast paced environment.
Nice to Have
- Experience within financial services or fraud analytics.
- Microsoft Power BI, Azure, or Business Intelligence certifications.
- Experience with Windows batch scripting and automation.
- Experience supporting enterprise scale data platforms.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at CGI
Analyste d'affaires sénior
Montreal, CAN
CGI seeks a Senior Business Analyst specializing in Manufacturing Execution Systems (MES) to support the BICEPS platform. The role involves analyzing manufacturing processes, defining business needs, and implementing MES
Workshop Facilitator
Ottawa, CAN
CGI is seeking a Workshop Facilitator to plan, coordinate, facilitate, and document collaborative workshops supporting organizational, business, and technology initiatives. The role requires strong facilitation, stakehol
Senior Financial Analyst
Ottawa, CAN
CGI is seeking a Senior Financial Analyst to support the National Capital Region. The role involves budgeting, forecasting, financial analysis, and partnering with business units. Candidates need a CPA designation and 4-
Sr. Technical Business Systems Analyst (API Integration)
Toronto, CAN
CGI seeks a Senior Technical Business Systems Analyst with API integration expertise. You will gather requirements, design API specs, create JSON schemas, and support testing. Ideal candidates have 6+ years of BSA experi
Sr. Technical Business Systems Analyst (API Integration)
Toronto, CAN
CGI is seeking a Senior Technical Business Systems Analyst with API integration expertise for a hybrid role in downtown Toronto. You will gather requirements, design API specifications, create JSON schemas, and support i
Responsable de produit (PO)
Montreal, CAN
CGI is seeking an experienced Product Owner to guide the development and deployment of technology solutions, with expertise in Microsoft ecosystem (M365, Teams, SharePoint). The role involves defining product vision, man
Expert stratégique en intelligence artificielle
Montreal, CAN
CGI recherche un leader stratégique en intelligence artificielle pour conseiller les directions sur la vision IA, la transformation d'entreprise et l'adoption responsable de l'IA. Le rôle combine stratégie, conseil exécu
Business Systems Analyst- Payments Modernization
Toronto, CAN
CGI is seeking a Senior Business Systems Analyst to lead payment modernization initiatives, including ISO 20022 adoption and legacy system replacement. You will analyze payment flows, define requirements, and collaborate
Analyste d'affaires sénior
Montreal, CAN
Workshop Facilitator
Ottawa, CAN
Senior Financial Analyst
Ottawa, CAN
Sr. Technical Business Systems Analyst (API Integration)
Toronto, CAN
Sr. Technical Business Systems Analyst (API Integration)
Toronto, CAN
Responsable de produit (PO)
Montreal, CAN
Expert stratégique en intelligence artificielle
Montreal, CAN
Business Systems Analyst- Payments Modernization
Toronto, CAN