SQL Server Developer with SSIS and SSRS

2 months ago


London, United Kingdom Nexus Jobs Limited Full time

Job Description

SQL Server Database Engineer with SSIS

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

Responsible for the development and delivery of pipelines (collect, validate and prepare high quality data) to automate and streamline processes required by different departments.

Support existing SSIS ETLs (overnight and intraday), proactively fine-tune and enhance existing codes to increase robustness and error monitoring.

Support the internal IT department with changes and upgrades to software platforms.

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 in order to develop and deliver appropriate solutions based on system definition documents.

Proficiency in advanced 4GL programming languages and able to apply to the fully development life-cycle.

Database Support

To build data pipelines within the SQL environment in SSIS packages, where required, introduce new field and data types for new information to be collated in the CORE environment.

To build tabular models (SSAS) for different business units.

To build reports based on business requirements using SQL SSRS.

To 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 house-keeping procedures.

Sharepoint Integration:

To integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry.

To utilise web services to integrate from cutting edge technology into legacy systems such as Equation.

End of Day Cycle:

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

To be able to analyse and rectify any problems raised in an independent and team scenario.

To 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 minimise 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 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 high level of proficiency - Essential

C# Programming / JavaScript programming - Desirable

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 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 do send your CV to us in Word format along with your salary and availability.



  • London, Greater London, United Kingdom Nexus Jobs Limited Full time

    Job DescriptionWe are seeking a highly skilled SQL Server Developer with expertise in SSIS and SSRS to join our team in Central London.Key ResponsibilitiesDesign and develop pipelines to automate and streamline processes using SSIS and SSRS.Support existing SSIS ETLs, fine-tune and enhance existing codes to increase robustness and error...


  • London, Greater London, United Kingdom Nexus Jobs Limited Full time

    Job DescriptionWe are seeking a highly skilled SQL Server Developer with expertise in SSIS and SSRS to join our team in Central London.Key ResponsibilitiesDesign and develop pipelines to automate and streamline processes using SSIS and SSRS.Support existing SSIS ETLs, fine-tune and enhance existing codes to increase robustness and error...


  • London, Greater London, United Kingdom Nexus Jobs Limited Full time

    Job Description SQL Server Database Engineer with SSIS Our Client is bank based in Central London - who are looking to recruit Database Engineer with at least 5 to 7 years sold expertise of working SQL Server SSIS and SSRS. Responsible for the development and delivery of pipelines (collect, validate and prepare high quality data) to automate and streamline...


  • London, United Kingdom Nexus Jobs Limited Full time

    Job Description SQL Server Database Engineer with SSIS Our Client is bank based in Central London - who are looking to recruit Database Engineer with at least 5 to 7 years sold expertise of working SQL Server SSIS and SSRS. Responsible for the development and delivery of pipelines (collect, validate and prepare high quality data) to automate and streamline...


  • London, Greater London, United Kingdom Nexus Jobs Limited Full time

    Job Description Database Engineer with SQL Server SSIS, SSRS and SSAS Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. You must have solid expertise of at least 5 years experience of working with MS SQL Server and SSIS - SSIS is very important for this position. Responsible for...


  • London, United Kingdom Nexus Jobs Limited Full time

    Job Description Database Engineer with SQL Server SSIS, SSRS and SSAS Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. You must have solid expertise of at least 5 years experience of working with MS SQL Server and SSIS - SSIS is very important for this position. Responsible for...


  • London, United Kingdom Nexus Jobs Limited Full time

    Job Description Database Engineer with SQL Server SSIS, SSRS and SSAS Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. You must have solid expertise of at least 5 years experience of working with MS SQL Server and SSIS - SSIS is very important for this position. Responsible for...


  • London, United Kingdom Nexus Jobs Limited Full time

    Job Description Database Engineer with SQL Server SSIS, SSRS and C# .net asp.net Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. You must have solid expertise of at least 5 years experience of working with MS SQL Server and SSIS - SSIS is very important for this position....


  • London, United Kingdom Saragossa Full time

    Have you ever fancied stepping into the world of sports betting and online gaming? You will join the company's FinTech department as a SQL Developer, supporting the conversion of large quantities of financial data and delivering information for significant business impact. By developing sturdy data frameworks and services, your work will result in the...


  • London, United Kingdom Saragossa Full time

    Have you ever fancied stepping into the world of sports betting and online gaming? You will join the company's FinTech department as a SQL Developer, supporting the conversion of large quantities of financial data and delivering information for significant business impact. By developing sturdy data frameworks and services, your work will result in the...


  • London, Greater London, United Kingdom Nexus Jobs Limited Full time

    Job DescriptionWe are seeking a highly skilled SQL Server Database Engineer with SSIS expertise to join our team in Central London. As a key member of our IT department, you will be responsible for designing, developing, and delivering high-quality data pipelines using SSIS, SSAS, and SSRS.Key ResponsibilitiesDesign and develop SSIS packages to automate and...


  • London, Greater London, United Kingdom Nexus Jobs Limited Full time

    Job DescriptionWe are seeking a highly skilled SQL Server Database Engineer with SSIS expertise to join our team in Central London. As a key member of our IT department, you will be responsible for designing, developing, and delivering high-quality data pipelines using SSIS, SSAS, and SSRS.Key ResponsibilitiesDesign and develop SSIS packages to automate and...


  • London, Greater London, United Kingdom Onyx-Conseil Full time

    Job DescriptionJob Title: SQL Server Database Engineer with SSIS ExpertiseCompany: Onyx-ConseilLocation: Central LondonJob Type: Full-timeAbout the Role:We are seeking a highly skilled SQL Server Database Engineer with expertise in SSIS to join our team. As a key member of our database team, you will be responsible for designing, developing, and implementing...


  • London, Greater London, United Kingdom Onyx-Conseil Full time

    Job DescriptionJob Title: SQL Server Database Engineer with SSIS ExpertiseCompany: Onyx-ConseilLocation: Central LondonJob Type: Full-timeAbout the Role:We are seeking a highly skilled SQL Server Database Engineer with expertise in SSIS to join our team. As a key member of our database team, you will be responsible for designing, developing, and implementing...

  • SQL Server Engineer

    7 days ago


    London, United Kingdom Red 10 Full time

    SQL Server / Power BI / Developer / Engineer / SSRS / SSIS KEY SKILLS: Proficiency in SQL development, particularly with T-SQL, Microsoft SSIS, SSRS, and Power BIWorked in Agile environmentsExperience completing system and unit testing THE ROLE:The role involves designing, coding, testing, documenting, and implementing software solutions, with a focus on ETL...


  • London, Greater London, United Kingdom Red 10 Full time

    About Red 10Red 10 is a leading provider of innovative solutions for the insurance industry.Job SummaryWe are seeking a highly skilled SQL Server Developer to join our team. The ideal candidate will have a strong background in SQL Server development, particularly with T-SQL, Microsoft SSIS, SSRS, and Power BI.Key ResponsibilitiesDesign, code, test, document,...


  • London, Greater London, United Kingdom Red 10 Full time

    About Red 10Red 10 is a leading provider of innovative solutions for the insurance industry.Job SummaryWe are seeking a highly skilled SQL Server Developer to join our team. The ideal candidate will have a strong background in SQL Server development, particularly with T-SQL, Microsoft SSIS, SSRS, and Power BI.Key ResponsibilitiesDesign, code, test, document,...

  • SQL Server Developer

    11 hours ago


    London, Greater London, United Kingdom Red 10 Full time

    About the RoleWe are seeking a skilled SQL Server developer to join our team at Red 10. As a key member of our technology team, you will be responsible for designing, coding, testing, documenting, and implementing software solutions with a focus on ETL and data migration.Key ResponsibilitiesDesign and develop efficient ETL processes using SQL Server and...

  • SQL Server Developer

    13 hours ago


    London, Greater London, United Kingdom Red 10 Full time

    About the RoleWe are seeking a skilled SQL Server developer to join our team at Red 10. As a key member of our technology team, you will be responsible for designing, coding, testing, documenting, and implementing software solutions with a focus on ETL and data migration.Key ResponsibilitiesDesign and develop efficient ETL processes using SQL Server and...


  • London, Greater London, United Kingdom Red 10 Full time

    About the RoleWe are seeking a skilled SQL Server developer to join our team at Red 10. As a key member of our technology team, you will be responsible for designing, coding, testing, documenting, and implementing software solutions with a focus on ETL and data migration.Key ResponsibilitiesDesign and develop efficient ETL processes using SQL Server and...