Montreal [Hybrid] Data Warehouse and Reporting Team Lead
About the role
About the Company:
As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specializing in Banking, Finance, and Financial Services. Guided by our core values of closeness, teamwork, diversity, and excellence, our team of 1,000 expert consultants, representing 35 different nationalities, collaborates across 10 international offices: Paris, Lyon, New York, Montreal, London, Brussels, Geneva, Lisbon, Porto and Casablanca.
We are looking for a Data Warehouse System andReporting Team Lead for one of our clients, an investment bank set in Montreal
Role Overview :
The role will be based in Montreal with both local (Montreal) and functional (New York) reporting lines. The candidate should be self-driven, accountable, and technically strong .NET Developer lead who can independently manage a team of developers/support members, own operation delivery, and act as the bridge between business users and IT. The candidate should be hands-on, confident in making decisions, skilled in setting and managing expectations, and experienced in operating within a controlled, audited IT environment. This role demands minimal oversight and high ownership.
The team leverages technical expertise and business knowledge to support a different set of business applications across the Americas in the US, Brazil and Canada branches.
It includes Finance, Risk, Referential, Compliance, Transverse applications and corporate systems (HR, Administration, IT for IT ...) as weel as Corporate Banking IT (Commercial Banking, Front, Middle & Back Office, Payments, Client accounts and Client on boarding)
Key responsabilities :
The responsibilities of this role include, but are not limited to :
-Lead end-to-end delivery of DWH & Reporting based applications, covering both development and support functions, without requiring regular managerial direction.
-Manage and mentor a team of developers/support members, ensuring high productivity, code quality, and on-time delivery.
-Coordinate with internal and external resources required to support transverse applications and associated interfaces. This includes the application vendors and internal Infrastructure/security teams.
-Contribute to key initiatives related to technical/functional IT and business projects to meet and support business objectives.
-Responsible for production support:
-Resolution of production issues, including RCA, defect remediation and incident reporting.
-Lead troubleshooting of issues and provide guidance to the support team members.
-Track internal and vendor compliance with support SLAs.
-Report on domain status to internal stakeholders and management.
-Actively support all efforts to simplify and enhance the information systems.
-Understands ETL operations and performance tuning the complex SQL and DML queries.
-Responsible for project deliverables:
-Work with project stakeholders and contributors to gather requirements and develop solution strategies.
-Coordinate with technical teams and provide clarifications and guidance on requirements.
-Create required documentation for requirements, solution design, and implementations.
-Develop test strategy, test plans and execute functional/technical test scripts
-Facilitate and manage unit, integration and user acceptance testing.
-Train and support staff members.
Management and leadership capability:
-Lead and manage teams, providing guidance, support and direction during critical times
-Exercise the duties of a manager with respect to supervision of all personnel within the team including staffing, training and development, performance appraisals (if needed)
-Liaise with the business (Compliance, Operations, and commercial business lines) to understand and support their requirements
-Evaluate current procedures and processes for accomplishing department objectives and continuously design and implement improved practices.
-Ensure accuracy and expediency of any activity related to audits
-Able to create and present KPI/KRI of the team on various committees.
Technical aptitude
-Ability to provide input to general architecture - including hardware, network, tools, software, etc.
-Assist in the gathering of business requirements and define specifications
-Propose and approve solution designs
-Assist with development teams to ensure proper implementation of requirements in the information system
-Be familiar with technology tools to confirm data quality and investigate questions
-Ensure the respect of policies and procedures of the Bank, as well as regulatory requirements
-Support and assist in the functional testing on major projects or complex changes
Project Management capabilities:
-Engage and support project management activities which includes, approving change management activities (including roles and responsibilities, creation of service level agreements, reviewing current processes, and defining target processes for the organization
-Oversee project scoping, planning and monitoring; managing risks, on the different IT activities involved in the IT projects; and ensuring organization of training as well as User Acceptance Testing
-Ensure adherence to the System Project Life Cycle (SPLC) across all IT practices
-Ensure that all system implementations meet US regulatory standards and are done in accordance with the Bank’s policies and procedures
-Ensure successful execution of projects under the domain, including review, remediation, risk mitigation for delivery on time, with quality and within budget
Required Qualifications and Skills:
-Bachelor’s Degree or equivalent
-10+ years of experience with at least 3 years in a management role.
-Strong expertise in DWH design & management, ETL tools, SQL Server, Oracle PL/SQL, and shell scripting, Microsoft Suite (Excel, Word, PowerPoint, Visio, etc.).
-Experience with development of Federal Reserve Bank Financial and Risk reports.
-Proven experience in handling teams, driving delivery independently, and working directly with business users.
-Excellent stakeholder management and communication skills – able to handle challenging discussions and align priorities.
-Solid understanding of ITIL frameworks and experience in managing production support in a controlled environment.
-Experience with Incident/Problem/Change management, RCA documentation, and audit compliance.
-Knowledge of project management and project life cycle (Agile and Waterfall Methodologies).
-Strong analytical thinking, decision making skills and a proactive attitude.
-Comfortable working under pressure and managing competing priorities in a dynamic environment.
-Experience with development of technical architectures and solution designs to meet business requirements
-Working knowledge of JIRA is added advantage.
Language:
English : mandatory
French : a strong asset
About QUANTEAM - North America (RAINBOW PARTNERS Group)
Quanteam is labeled "Best Workplace Experience 2021" by Speak & Act!
Part of Rainbow Partners Group, Quanteam is an independent Financial Markets consulting company based in France, the UK, the USA, Canada, Switzerland, Belgium, Portugal, Morocco, Spain or Singapore. Our teams support Corporate and Investment Banks, Asset Management Companies, Insurance and Corporate for their projects in financial engineering, quantitative research, regulatory implementation, SI transformation, and technology innovation.
We are currently looking for talented Consultants in New York, Chicago, Dallas, Miami and Montréal. If you seek new career opportunities, please send us your application by mail (hiring@quanteam.us) or visit our Career section on LinkedIn. For more information on our expertise, please visit our website.
Quanteam is positioned as a unique multi-specialist in the Financial, Insurance, and Digital Transformation sectors. We have the ability to manage complex projects involving Front, Risk, R/D, Regulatory, Compliance, and IT teams. We rely on a team of +850 employees based in Europe, North America and Africa. Finally, we recorded 88M€ of turnover in 2024.
Montreal [Hybrid] Data Warehouse and Reporting Team Lead
About the role
About the Company:
As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specializing in Banking, Finance, and Financial Services. Guided by our core values of closeness, teamwork, diversity, and excellence, our team of 1,000 expert consultants, representing 35 different nationalities, collaborates across 10 international offices: Paris, Lyon, New York, Montreal, London, Brussels, Geneva, Lisbon, Porto and Casablanca.
We are looking for a Data Warehouse System andReporting Team Lead for one of our clients, an investment bank set in Montreal
Role Overview :
The role will be based in Montreal with both local (Montreal) and functional (New York) reporting lines. The candidate should be self-driven, accountable, and technically strong .NET Developer lead who can independently manage a team of developers/support members, own operation delivery, and act as the bridge between business users and IT. The candidate should be hands-on, confident in making decisions, skilled in setting and managing expectations, and experienced in operating within a controlled, audited IT environment. This role demands minimal oversight and high ownership.
The team leverages technical expertise and business knowledge to support a different set of business applications across the Americas in the US, Brazil and Canada branches.
It includes Finance, Risk, Referential, Compliance, Transverse applications and corporate systems (HR, Administration, IT for IT ...) as weel as Corporate Banking IT (Commercial Banking, Front, Middle & Back Office, Payments, Client accounts and Client on boarding)
Key responsabilities :
The responsibilities of this role include, but are not limited to :
-Lead end-to-end delivery of DWH & Reporting based applications, covering both development and support functions, without requiring regular managerial direction.
-Manage and mentor a team of developers/support members, ensuring high productivity, code quality, and on-time delivery.
-Coordinate with internal and external resources required to support transverse applications and associated interfaces. This includes the application vendors and internal Infrastructure/security teams.
-Contribute to key initiatives related to technical/functional IT and business projects to meet and support business objectives.
-Responsible for production support:
-Resolution of production issues, including RCA, defect remediation and incident reporting.
-Lead troubleshooting of issues and provide guidance to the support team members.
-Track internal and vendor compliance with support SLAs.
-Report on domain status to internal stakeholders and management.
-Actively support all efforts to simplify and enhance the information systems.
-Understands ETL operations and performance tuning the complex SQL and DML queries.
-Responsible for project deliverables:
-Work with project stakeholders and contributors to gather requirements and develop solution strategies.
-Coordinate with technical teams and provide clarifications and guidance on requirements.
-Create required documentation for requirements, solution design, and implementations.
-Develop test strategy, test plans and execute functional/technical test scripts
-Facilitate and manage unit, integration and user acceptance testing.
-Train and support staff members.
Management and leadership capability:
-Lead and manage teams, providing guidance, support and direction during critical times
-Exercise the duties of a manager with respect to supervision of all personnel within the team including staffing, training and development, performance appraisals (if needed)
-Liaise with the business (Compliance, Operations, and commercial business lines) to understand and support their requirements
-Evaluate current procedures and processes for accomplishing department objectives and continuously design and implement improved practices.
-Ensure accuracy and expediency of any activity related to audits
-Able to create and present KPI/KRI of the team on various committees.
Technical aptitude
-Ability to provide input to general architecture - including hardware, network, tools, software, etc.
-Assist in the gathering of business requirements and define specifications
-Propose and approve solution designs
-Assist with development teams to ensure proper implementation of requirements in the information system
-Be familiar with technology tools to confirm data quality and investigate questions
-Ensure the respect of policies and procedures of the Bank, as well as regulatory requirements
-Support and assist in the functional testing on major projects or complex changes
Project Management capabilities:
-Engage and support project management activities which includes, approving change management activities (including roles and responsibilities, creation of service level agreements, reviewing current processes, and defining target processes for the organization
-Oversee project scoping, planning and monitoring; managing risks, on the different IT activities involved in the IT projects; and ensuring organization of training as well as User Acceptance Testing
-Ensure adherence to the System Project Life Cycle (SPLC) across all IT practices
-Ensure that all system implementations meet US regulatory standards and are done in accordance with the Bank’s policies and procedures
-Ensure successful execution of projects under the domain, including review, remediation, risk mitigation for delivery on time, with quality and within budget
Required Qualifications and Skills:
-Bachelor’s Degree or equivalent
-10+ years of experience with at least 3 years in a management role.
-Strong expertise in DWH design & management, ETL tools, SQL Server, Oracle PL/SQL, and shell scripting, Microsoft Suite (Excel, Word, PowerPoint, Visio, etc.).
-Experience with development of Federal Reserve Bank Financial and Risk reports.
-Proven experience in handling teams, driving delivery independently, and working directly with business users.
-Excellent stakeholder management and communication skills – able to handle challenging discussions and align priorities.
-Solid understanding of ITIL frameworks and experience in managing production support in a controlled environment.
-Experience with Incident/Problem/Change management, RCA documentation, and audit compliance.
-Knowledge of project management and project life cycle (Agile and Waterfall Methodologies).
-Strong analytical thinking, decision making skills and a proactive attitude.
-Comfortable working under pressure and managing competing priorities in a dynamic environment.
-Experience with development of technical architectures and solution designs to meet business requirements
-Working knowledge of JIRA is added advantage.
Language:
English : mandatory
French : a strong asset
About QUANTEAM - North America (RAINBOW PARTNERS Group)
Quanteam is labeled "Best Workplace Experience 2021" by Speak & Act!
Part of Rainbow Partners Group, Quanteam is an independent Financial Markets consulting company based in France, the UK, the USA, Canada, Switzerland, Belgium, Portugal, Morocco, Spain or Singapore. Our teams support Corporate and Investment Banks, Asset Management Companies, Insurance and Corporate for their projects in financial engineering, quantitative research, regulatory implementation, SI transformation, and technology innovation.
We are currently looking for talented Consultants in New York, Chicago, Dallas, Miami and Montréal. If you seek new career opportunities, please send us your application by mail (hiring@quanteam.us) or visit our Career section on LinkedIn. For more information on our expertise, please visit our website.
Quanteam is positioned as a unique multi-specialist in the Financial, Insurance, and Digital Transformation sectors. We have the ability to manage complex projects involving Front, Risk, R/D, Regulatory, Compliance, and IT teams. We rely on a team of +850 employees based in Europe, North America and Africa. Finally, we recorded 88M€ of turnover in 2024.