SQL Server Developer with SSIS and SSRS

Social network you want to login/join with:

SQL Server Developer with SSIS and SSRS, London

Client:

Nexus

Location:

London, United Kingdom

Job Category:

Other

EU work permit required:

Yes

Job Reference:

e87e49251223

Job Views:

2

Posted:

26.03.2025

Expiry Date:

10.05.2025

Job Description:

SQL Server Database Engineer with SSIS

Our Client is a bank based in Central London – who are looking to recruit a Database Engineer with at least 5 to 7 years of solid expertise in SQL Server, SSIS, and SSRS.

Responsibilities include:

1. Development and delivery of data pipelines to automate and streamline processes required by different departments.
2. Support existing SSIS ETLs (overnight and intraday), proactively fine-tuning and enhancing existing codes for robustness and error monitoring.
3. Support the internal IT department with changes and upgrades to software platforms.
4. Convert legacy Hyperion reports to SSRS.

Software Development:

Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation end of day cycle.

Understanding business requirements to develop and deliver appropriate solutions based on system definition documents.

Proficiency in advanced 4GL programming languages and applying to the full development life-cycle.

Database Support:

Build data pipelines within the SQL environment in SSIS packages, introduce 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 automate processes, eliminating the need for duplicate entry.

Utilise web services to integrate cutting-edge technology into legacy systems such as Equation.

End of Day Cycle:

Provide second and third level support for in-house programmes during the end of day cycle.

Analyse and rectify any problems raised independently or in a 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.

Report policy/procedure breaches and areas of potential non-compliance promptly upon identification.

Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches.

Identify new risks/control gaps within own area and escalate accordingly.

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 behavioural competencies training required for your role.

Act in accordance with the FCA/PRA Code of Conduct.

Fulfil all prescribed business continuity requirements as set out in the organisational or departmental specific plans or as instructed by the Line Manager/Head of Department.

Qualifications/Experience:

Degree level qualified or equivalent.

MS SQL stack (SSIS, SSAS, SSRS) to a high level of proficiency - Essential.

Knowledge and Skills:

Software analysis and design good practice.

Dimensional modelling, Entity Relationship modelling, Normalised modelling.

Data warehouse design concepts (Inmon, Kimball).

The position is based in Central London and you will be required to be in the office for 3 days a week.

Please note the Client does NOT provide sponsorship.

The salary for this position is in the range £60K – £75K.

Please send your CV to us in Word format along with your salary and availability.