Data Warehouse Systems and Reporting Team Lead - Banking Industry

Nöord Technologies; Montreal West; On-site; CAD 100,000 - 140,000; Full time

Job summary

Nöord Technologies seeks a Data Warehouse Systems and Reporting Team Lead for its Montreal office. This mid-senior level position involves leading a team, managing DWH & reporting applications, and ensuring compliance with regulatory standards in a dynamic banking environment. Ideal candidates are self-driven, technically strong, and possess excellent stakeholder management skills. They will oversee project scoping and execution while driving improvements in operational practices.

Benefits

Flexibility to work during non-business hours

On-call support including overnight and weekend support

Qualifications

• Minimum relevant experience: 10 years with 3+ years of leading a team.
• Strong analytical thinking and decision-making skills.

Responsibilities

• Lead end-to-end delivery of DWH & Reporting based applications.
• Manage and mentor a team of developers / support members.
• Ensure accuracy of activities related to audits.
• Actively support efforts to enhance information systems.

Skills

DWH design & management

ETL tools

SQL Server

Oracle PL / SQL

Microsoft Suite

Stakeholder management

Analytical thinking

Education

Bachelor’s degree or equivalent

Tools

JIRA

Job description

Data Warehouse Systems and Reporting Team Lead - Banking Industry

Data Warehouse Systems and Reporting Team Lead - Banking Industry

2 days ago Be among the first 25 applicants

Nöord Technologies, a Quebec-based company founded in 2004, specializes in IT and operations consulting, as well as talent recruitment for its clients.

If you are looking to advance your career and seek a new stimulating challenge, join our dynamic and innovative team.

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 SQL / Pl-SQL 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, able to develop and support activities of the Finance and Risk regulatory reports, 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 myriad of business applications across the Americas in the US, Brazil and Canada branches.

It includes applications covered by two IT business lines :

• Corporate & Support Functions IT : Finance, Risk, Referential, Compliance, Transverse applications and corporate systems (HR, Administration, IT for IT ...)
• Corporate Banking IT : Commercial Banking (Front, Middle & Back Office), Payments, Client accounts and Client on boarding

Key Responsibilities :

• 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.
• 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.
• 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 under the direction of the CBTS Lead in Montreal.
• 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
• Oversees proper execution of BCP activities for the domain in scope when necessary

Requirements

Minimal education level : Bachelor’s degree or equivalent

Minimum relevant experience : 10 years with 3 plus years’ experience of leading a team

Required Skills :

• 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.

OTHERS :

• Strong written and verbal communication skills
• Good organizational skills with attention to detail and ability to multi-task is a must
• Comfortable in working with multiple teams across locations with excellent inter-personal skills
• Self-motivated, and autonomous
• Flexibility to work during non-business hours and provide on-call support including overnight batch support (EOD and SOD batches) and weekend support.

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

Referrals increase your chances of interviewing at Nöord Technologies by 2x

Get notified about new Data Warehouse Specialist jobs in Montréal-Ouest, Quebec, Canada .

Data Warehouse Support and Enhancement Specialist

Montreal [Hybrid] Data Warehouse and Reporting Team Lead

DATA ANALYST - CHARGE D'ETUDES SYSTEME D'INFORMATIONS (H / F)

Supply Chain Data Intelligence Analyst - Belron Canada

Junior / Graduate Linux Systems Engineer - Trading - $100,000-$150,000 CAD + Bonus

Data Analyst : Prospect UI Solutions (Remote)

Butcher - Part-time, limited availability

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

J-18808-Ljbffr

Create a job alert for this search