SQL Server Developer with SSIS and SSRS

5 days 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.

  • Database Engineer with SQL Server SSIS, SSRS and SSAS

    5 days ago

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

  • Database Engineer with SQL Server SSIS, SSRS and C# .net asp.net

    5 days ago

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

  • SQL Server Engineer

    2 weeks ago

    London, Greater London, United Kingdom CNA Hardy Full time

    About the Company CNA Hardy is a leading specialist commercial insurance provider for clients within the Lloyd's and company markets. We are part of CNA Financial Corp, the 8th largest U.S. commercial property and casualty insurance company. Established in 1897, CNA has approximately 7,000 employees, serving businesses and professionals in the U.S., Canada...

  • Database Engineer with SQL Server and SSIS

    5 days ago

    London, United Kingdom Nexus Jobs Limited Full time

    Job Description Database Engineer with SQL Server and SSISOur Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department...

  • SQL Server Database Professional

    3 weeks ago

    London, Greater London, United Kingdom Jas Gujral Full time

    **About the Role:We are seeking an experienced SQL Server Database Professional to join our team at Jas Gujral, a bank based in Central London. The successful candidate will have a proven track record of working with SSIS, SSRS, and C# .net and asp.net.Key responsibilities include building data flows within the SQL environment in SSIS packages and...

  • C# and SQL Developer

    2 months ago

    London, United Kingdom Oliver Bernard Full time

    Contract C#/SQL Developer - Energy Trading - Hybrid working Our client is seeking an experienced Contract C#/SQL Developer to join their team, working on complex projects with cutting-edge technologies. This hybrid role requires you to be in the office 2 days a week, providing the perfect blend of collaborative and flexible working environments. ...

  • C# and SQL Developer

    3 months ago

    London, United Kingdom Oliver Bernard Full time

    Contract C#/SQL Developer - Energy Trading - Hybrid working Our client is seeking an experienced Contract C#/SQL Developer to join their team, working on complex projects with cutting-edge technologies. This hybrid role requires you to be in the office 2 days a week, providing the perfect blend of collaborative and flexible working environments. ...

  • MI Analyst with MS SQL Server

    5 days ago

    London, United Kingdom Nexus Jobs Limited Full time

    Job Description MI Analyst with MS SQL Server - City London Our Client is an international bank with offices in the City London. They are looking to recruit an MI Analyst with at least 5 years experience of MS SQL Server, SSIS, SSRS, and Sharepoint. The main elements of the role are follows: - Work within MI team in supporting and delivering all aspects...

  • Senior SQL Server Data Warehouse Developer

    3 weeks ago

    London, Greater London, United Kingdom Candour Solutions Full time

    Candour Solutions is committed to diversity and creating a truly inclusive culture, driving success through collaboration and hybrid-working practices. As a Senior SQL Server Data Warehouse Developer, you will play a key role in implementing and producing data models, building automated pipelines, and working with Enterprise-grade technology.About the JobThe...

  • SQL Developer

    1 month ago

    London, United Kingdom Impellam Group Full time

    SQL BI DeveloperOutside IR35 - £600 - £700Hybrid: x 2 per week onsite in Central London6 month initial, rollingJoin an international energy company in the trading middle and back officeResponsibilities:As a SQL Developer with trading experience, you'll be part of the SDLC lifecycleEnterprise developer with SQL, C# and SQL BI stackTake business requirements...

  • SQL Developer

    2 weeks ago

    City Of London, United Kingdom Impellam Group Full time

    SQL BI DeveloperOutside IR35 - £600 - £700Hybrid: x 2 per week onsite in Central London6 month initial, rollingJoin an international energy company in the trading middle and back officeResponsibilities:As a SQL Developer with trading experience, you'll be part of the SDLC lifecycleEnterprise developer with SQL, C# and SQL BI stackTake business requirements...

  • SQL Developer

    4 weeks ago

    City of London, United Kingdom Impellam Group Full time

    Job Description SQL BI Developer Outside IR35 - £600 - £700 Hybrid: x 2 per week onsite in Central London 6 month initial, rolling Join an international energy company in the trading middle and back office Responsibilities: As a SQL Developer with trading experience, you'll be part of the SDLC lifecycle Enterprise developer with SQL, C# and SQL BI...

  • Data Engineer with SSIS and SSAS

    5 days ago

    London, United Kingdom Nexus Jobs Limited Full time

    Job Description Database Engineer with SQL Server and SSIS 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 the...

  • Contract C#/SQL Developer

    2 months ago

    London, United Kingdom Oliver Bernard Full time

    Contract C#/SQL Developer - Energy Trading - Hybrid working Our client is seeking an experienced Contract C#/SQL Developer to join their team, working on complex projects with cutting-edge technologies. This hybrid role requires you to be in the office 2 days a week, providing the perfect blend of collaborative and flexible working environments. Required...

  • Business Analyst

    2 days ago

    London, Greater London, United Kingdom Endeavour Recruitment Solutions Full time

    Endeavour Recruitment Solutions is seeking a highly skilled Dynamics CRM Developer to join our esteemed client based in London.About the RoleWe are looking for an individual with proven experience working with Dynamics CRM, specifically versions 2015/2016/365. The successful candidate will have expertise in configuration and version upgrades, as well as...

  • Database Specialist

    6 months ago

    London, United Kingdom CNA Hardy Full time

    **Job Profile** **Function / Area**:Operations & IT **Reports To**:Application Support Manager **Position Summary** This Database specialist will assist in troubleshooting current SQL server database issues, look at performance improvements, database upgrades, provide support and maintain SSIS and SSRS code. This is not a production support role but will...

  • Contract C#/SQL Developer

    3 months ago

    London, United Kingdom Oliver Bernard Full time

    Contract C#/SQL Developer - Energy Trading - Hybrid working Our client is seeking an experienced Contract C#/SQL Developer to join their team, working on complex projects with cutting-edge technologies. This hybrid role requires you to be in the office 2 days a week, providing the perfect blend of collaborative and flexible working environments. Required...

  • Contract Database Developer

    1 day ago

    London, Greater London, United Kingdom Oliver Bernard Full time

    About this roleWe are looking for a Contract Database Developer to join our team at Oliver Bernard.This role involves designing, developing, and maintaining databases and data warehouse solutions using SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS). You will also be required to...

  • SQL Developer

    3 weeks ago

    London, United Kingdom Vector Resourcing Full time

    We are seeking an experienced MSSQL Developer to contribute to the enhancement and support of our in-house CRM system (SIMS) and assist in the migration to its successor, built on Microsoft Dynamics. You'll play a pivotal role in designing, developing, and maintaining complex database components and reports, while providing user support to optimize...

  • SQL Developer

    3 weeks ago

    London, United Kingdom Vector Resourcing Full time

    We are seeking an experienced MSSQL Developer to contribute to the enhancement and support of our in-house CRM system (SIMS) and assist in the migration to its successor, built on Microsoft Dynamics. You'll play a pivotal role in designing, developing, and maintaining complex database components and reports, while providing user support to optimize...