Lead Data Warehouse Developer

Description

Purpose of the job

The Bank for International Settlements (BIS) is currently recruiting for a Lead Data Warehouse Developer to join the Data & Analytics team in Basel. The Data & Analytics team supports Business Intelligence (BI) requirements for the banking business by managing a modern Enterprise Data Warehouse (EDW) and reporting platforms. The EDW serves a growing ecosystem of personas across the Bank from senior managers to risk analysts and front office staff.

Your contribution to our mission

As part of the BIS Innovation 2025 strategy, we are transforming the Bank’s foundational data & analytical capabilities, the Enterprise Data Warehouse being a critical component of this foundation.

In this context, we are looking for technical individuals with experience of leading data warehouse teams with proven technical platform ownership in an agile, DevOps environment.

This is your opportunity to lead the implementation to ensure that EDW achieves high levels of availability, resiliency and scalability, as well as to work cross-functionally with a large variety of areas across the Bank.

Principal accountabilities

• Provide technical leadership to the entire data warehouse platform with a particular focus on high availability, performance, scalability, resilience and maintainability


• Together with the Architect, design, develop and maintain staging, integration, and reporting data schemas in the Bank’s agile data warehouse platform


• Design, write code and implement highly performant ETL solutions by leading a team of developers and data analysts


• Take ownership of the platform, monitor and respond quickly to urgent issues related to data load or transformation processes


• Document ETL processes and flows


• Collaborate across user groups and platform delivery teams to lead the collation, refinement and prioritisation of platform demand using agile methodologies and techniques


• Together with the Architect, actively engage in data warehouse design and plan a roadmap to achieve continuous platform improvements


• Work closely with the business intelligence team to design, build, and test sustainable data processes and structures for reporting and analysis


• Ensure tools, processes and adequate code coverage is implemented for unit, integration and regression testing of the data warehouse


• Work with the Architect and Head of Data & Analytics to define a platform vision that enables the long term performance and successful adoption of the platform


• Assist in the development of internal policies and procedures (standards, controls and metrics)


• Set the platform release schedule and ensure that changes do not have unexpected impacts to the platform ecosystem


• Assist in the definition and collection of metrics that measure the productivity and quality of platform delivery and the success of the platform; use these metrics to support the prioritisation of new platform features


• Follow the Bank’s policies, procedures and standard working practices for the management of time, including on-call arrangements and unsociable working


• Collaborate with the project stakeholders to support a data governance structure, policies and procedures

Qualifications, skills and experience

• A university-level degree in a technology related discipline


• Relevant experience with developing and designing Data Warehouses and Kimball Dimensional Data Modelling


• Experience in developing for both operational and reporting database systems


• Experience with structured agile methodologies from requirements analysis to release management


• Proficiency in developing and maintaining complex SQL and ETL/ELT (Extract/Transform/Load) solutions in a team development environment


• Experience with Microsoft SQL Server, including SSMS, SSIS, SSAS (multi-dimensional and tabular) and RedGate Tools (SCA, SQL Clone)


• Experience with Data Vault methodology and proven ability to design and develop database solutions to meet specific business requirements


• Experience with GitHub or other version control/source code management tools and CI/CD practices for Data Warehouses


• Ability to recognize and manage project trade-offs while considering factors including time, priority, scope, sustainability, efficiency, simplicity, features, deadlines, urgency, and impact


• Familiarity with the SDLC (Software Development Lifecycle)


• Ability to troubleshoot and debug code and technical solutions


• Proficient oral and writing communication skills in English and the ability to communicate with diverse stakeholders at different levels


• Well-proven customer orientation


• Well organised, flexible and able to perform under pressure


• Knowledge of financial markets, economics and/or financial statistics would be an advantage

The BIS is fully committed to equal opportunity employment and strives for diversity among its staff.

Are you a returning applicant?