Data Warehouse Systems Expert – Banking & Capital Markets

At Nöord Technologies, we empower top-tier financial institutions with exceptional talent in banking and capital markets. We are currently seeking, on behalf of one of our clients, a high-caliber Data Warehouse Systems Development & Support Consultant to join their strategic CBTS team in Montreal.

This is a unique opportunity to play a pivotal role in supporting and enhancing the infrastructure of a major Commercial Banking application. You will be at the heart of the bank's risk and reporting streams, ensuring the integrity of financial data across the Americas, including the US, Brazil, and Canada.

The Mission: Drive Excellence in Data & Operations

As a key member of the team, you will balance complex development projects with high-stakes production support. Your mission includes:

• Architecting the Future: Design application architectures and develop sophisticated procedures in Oracle and Sybase databases.
  

• Mastering the Batch: Lead the design and implementation of critical Unix/Linux batch processes using Shell scripting and Perl.
  

• Ensuring Seamless Operations: Manage the full lifecycle of DWH interfaces, from ETL performance tuning to complex SQL optimization.
  

• Guardian of Stability: Lead troubleshooting efforts, perform Root Cause Analysis (RCA), and ensure prompt resolution of queries for financial users.
  

• Strategic Compliance: Ensure all implementations meet rigorous US regulatory standards and internal bank policies.
  

Key Responsibilities:

• Support all DWH upstream and downstream interfaces.
  

• Coordinate with internal and external resources required to support DWH applications and associated interfaces.
  

• Contribute to key initiatives related to technical/functional IT and business projects to meet and support business objectives.
  

• Train and support team members.
  

• Responsible for production support:
  

• Support day to day production needs:
  

• Resolution of production issues, including RCA, defect remediation and incident reporting.
  

• Ensure prompt addressing of financial user’s query
  

• Resolution of batch issues by coordinating with other cross functional teams within the prescribed timelines and make aware of the impact to the business users.
  

• Lead troubleshooting of issues and provide guidance to the support team members.
  

• To comply ITIL processes (Incident, Problem and Change management).
  

• Coordinate and execute maintenance activities including business continuity and critical application failover tests, market infrastructure mandatory tests and releases, system/security patching.
  

• ETL operations and performance tuning the complex SQL and DML queries.
  

• To leverage the automations for repetitive manual tasks/interventions.
  

• Responsible for project deliverables:
  

• Ensure the respect of development procedures as per the internal system project life cycle procedures
  

• Perform enhancement on the business requirements which includes batch jobs configuration in Control-M, creating/modifying DB objects, shell scripts.
  

• Design application architecture and develop procedures in database (Oracle/Sybase).
  

• Batch designing and implementation in Unix/Linux using shell scripting and Perl etc.
  

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

• Ensure that all system implementations meet US regulatory standards and are done in accordance with the Bank’s policies and procedures
  

Requirements

Minimum relevant experience: 5 - 9 years

Required Skills:

FUNCTIONAL

• Domain knowledge of DWH systems in a banking environment.
  

• Experience as part of an IT production support team responsible for supporting production, enhancements and maintenance.
  

• Experience supporting overnight batch execution, EOD and SOD processes.
  

• Experience supporting Operations and Compliance Teams
  

• Knowledge of Sanctions Filtering and AML
  

• Knowledge of project management and project life cycle
  

TECHNICAL

• Experience with implementation, upgrades and enhancements of payment systems.
  

• Strong technical knowledge background in databases, Linux, and Windows systems.
  

• Strong knowledge of the Microsoft Suite (Excel, Word, PowerPoint, Visio, etc.), SQL Server, Oracle PL/SQL, and shell scripting.
  

• Working knowledge of Control-M.
  

• Experience with development of technical architectures and solution designs to meet business requirements.
  

• Hands on experience on testing methodologies.
  

• Working knowledge of JIRA is added advantage.
  

SOFT SKILLS

• Experience coordinating with other teams such as Infrastructure, IT Security, and Operations as part of supporting production payment systems.
  

• Ability to provide technical and functional guidance.
  

• Experience in outsourcing model.
  

• Ability to manage complex topics under strict timelines and budget constraints.
  

OTHERS

• Languages skills: English
  

• Strong analytical and troubleshooting skills
  

• 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 and weekend support
  

• Working from Home (WFH): Voluntary basis for up to 2 days per week after 3 months of joining, subject to manager’s discretion.