Job Description: Database Engineer

Overview

Our client is a bank based in Central London, currently seeking to recruit a Database Engineer with at least 5 to 7 years of solid experience working with SQL Server, SSIS, and SSRS.

Responsibilities

• Pipeline Development: Responsible for the development and delivery of pipelines to collect, validate, and prepare high-quality data, automating and streamlining processes required by different departments.
• SSIS ETL Support: Support existing SSIS ETLs (overnight and intraday), proactively fine-tuning and enhancing existing codes to increase robustness and error monitoring.
• Software Development:
  • Analyze issues pertaining to problems or errors raised by in-house systems, i.e., CORE, SharePoint interface, Equation end-of-day cycle.
  • Develop and deliver appropriate solutions based on system definition documents.
  • Proficient in advanced 4GL programming languages and able to apply to the full development life-cycle.
• Database Support:
  • Build data pipelines within the SQL environment in SSIS packages, introducing new fields and data types for new information to be collated in the CORE environment.
  • Build tabular models (SSAS) for different business units.
  • Build reports based on business requirements using SQL SSRS.
  • Integrate with all the Bank’s sub-systems using data abstraction and connectivity layers, i.e., ODBC, ADO.net.
  • Ensure that the environment is running optimally and with high standard housekeeping procedures.
• SharePoint Integration:
  • Integrate the SharePoint environment and Forms with the Equation system to introduce automation of processes, thereby eliminating the need for duplicate entry.
  • Utilize web services to integrate from cutting-edge technology into legacy systems such as Equation.
• End of Day Cycle:
  • Provide second and third-level support for in-house programs during the end-of-day cycle.
  • Analyze and rectify any problems raised in an independent and team scenario.
  • Take ownership of a problem and deliver a solution in a timely manner.
  • Provide out-of-office hours support.
• Risk & Regulatory Duties:
  • Maintain knowledge of all applicable regulatory requirements, including the Bank’s Risk and Compliance policies and procedures, and adhere to these to avoid exposing the Bank to undue risk.
  • Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies.
  • Accurately execute all controls within own area to minimize risk of policy, procedure, and/or regulatory breaches.
  • Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department.
• Training & Competence:
  • Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines.
  • Proactively seek to complete recommended technical and behavioral competencies training required for your role.
  • Act in accordance with the FCA/PRA Code of Conduct.
  • Fulfill all prescribed business continuity requirements as set out in the organizational or departmental specific plans or as instructed by the Line Manager/Head of Department.