Find your next tech and IT Job or contract SQL

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 of MI - BAU encompassing data warehouse back end maintenance and Housekeeping - Support annual Disaster Recovery invoking/testing - Contribute to design, build and implementation of new reports and applications/interfaces. - Facilitate internal/external Audits and Penetration Testing. Remediation General Skills -Experience working within mission-critical environments -Experience in operational deployments -Maintains required industry recognised skills through training and self-study methods Technical Skills -In-depth knowledge of MS SQL -In-depth knowledge of SDLC -C# Development (advantageous) Technologies SQL - TSQL, SSIS and SSRS. SQL - DBA. SharePoint & InfoPath. Hyperion (Oracle EPM). C# Any experience of process automation and Equation/iSeries DB knowledge. SWIFT. AIX would be very handy. Good interpersonal skills Thorough and reliable Technically competent Ability to work unsupervised This is 6 month full-time permanent role. The salary will be £45K - £50K pro-rata. It is intended that you will work 2 days from the office and 3 days remotely from home for the foreseeable future. Do send your CV to us in Word format along with your salary and availability.

Job Description Software Developer with Full Stack C# and SQL Server Our Client is an international company in the media industry. They are looking to recruit an additional Software Engineer/Developer with full stack software development experience. Must have at least 2 to 4 years of hands-on software development covering both front and backend development. We're looking for a software engineer who bring fresh ideas from all areas, including information retrieval, distributed computing, large-scale system design. Any experience of networking and data storage, security, artificial intelligence, natural language processing, UI design and mobile would be very useful. The Client would like to see experience of the following skills: Languages: HTML5, CSS3, C#, Javascript ( is not main focus but knowledge is good) Frameworks: ASP.Net 4-6, MVC, Ajax, JQuery, HTML, Bootstrap and Knockout (required), Angular (optional) DB's: Ms Sql Server 2012 Testing: Nunit Tools: Jira, Git and Git Hub, Bitbucket Practices: Agile, Scrum The role: • Creating and updating the user interface enabling our customers to create beautiful, bespokeproducts on their global webstores • Creating a project management tool enabling customers to come back to their personalizationprojects without starting the process from scratch. • Creating a one click photobook experience; a thinking system which creates and presents photos and photobooks in the best layout order • Continuous optimization and debugging when adjustments are made to our webstores • Design and implementation of next-generation web applications using Java and C# that can handle web-scale volumes of traffic Summary • Do you have at least 2 years full stack development experience with a focus on front end development? • Have you worked in a fast paced ecommerce environment? • Have you experience in supporting Web applications with high traffic? • Are you a whizz with scripting languages JavaScript and C# ? • Experienced in full automation and configuration management? • Can you help developers own and deliver change from keyboard to customer? • Can you diagnose and fix complex production issues working with others as necessary? • Are you a Developer who wants to work in a cutting edge & dynamic operations team? • Can you help continually improve systems to reduce impact from technical issues? The Company is based in West London. The salary range for this position is £30K - £40K depending on expertise. Please send your CV to us in Word format.

Job Description Years of relevant experience 2+ years Education Level Bachelor's Degree About the Job Oracle Developer with Oracle Forms and SQL Server - Financial Services - East London Our Client is specialist software company developing software for the pensions, insurance and wealth management software market place. They are currently looking to recruit an Oracle with PL/SQL and Oracle Forms Developer with at least 2 to 5 years commercial experience of writing applications developing Oracle Forms applications. You will ideally have experience of working on and developing pensions and or wealth management systems. The Client will be moving from Oracle 10 to Oracle 11g very shortly so this could be great move to learn the latest technology. The main function of the position is to develop in Oracle coupled with the following: • Create and agree work specifications for assigned tasks before commencing any changes/development • Assist with providing quotes for new development and amendments • Development of software using Oracle tools or other technologies used by the company • Carrying out necessary application/database modifications as per agreed specifications • Liaising with clients to address issues/problems at the earliest opportunity (email, phone, web-tools) • Fixing of technical bugs/issues and patch release control • Adhering to standards and expectations of the company as regards programming, recording, controlling and securing developments • Ensuring technical specifications/requirements are met within agreed deadlines • Carrying out adequate unit & link testing before releases are made • Prepare release documentation for all new developments to the agreed format Any experience of developing software for the financial services arena would be a bonus. Other web technologies that would be handy to have are HTML, possibly RedHat/JBoss. This is a 3 to 6 month contract to start ASAP. Send your CV in Word format, along with your salary expectations and availability.

Job Description Database Engineer with SQL Server Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. 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. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language. Data warehouse design concepts, (Inmon or Kimball) The Client is a Bank based in the City of London. This is a 2 year FTC position with a salary of circa £65K - £70K. Do send your CV to us in Word format along with your salary and availability.

Job Description Database Engineer with SQL Server Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. 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. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language. Data warehouse design concepts, (Inmon or Kimball) The Client is a Bank based in the City of London. This is a 2 year FTC position with a salary of circa £65K - £70K. Do send your CV to us in Word format along with your salary and availability.

Job Description Software Developer with C# .Net SQL Server and RPG Role Description This is a full-time hybrid role based in London, offering flexibility for remote work. As a Software Developer with expertise in C# .NET, SQL Server, and RPG, your responsibilities will include developing software solutions, maintaining databases, and supporting system integrations. The Client a bank in London would like you to have a background in working for a bank working on Core Banking systems along with BAU and developing solutions in C# .net coupled with excellent SQL Server SSIS and RPG. Qualifications • Proficiency in C# .NET, SQL Server, and RPG programming languages • Experience in software development, database management, and system integration • Strong analytical and problem-solving skills • Ability to work independently and collaborate effectively in a team environment • Excellent communication and documentation skills This a hybrid position based in Central London. The salary will be circa £80K - £100K depending on expertise. Do send your CV to us in Word format along with your salary and notice period.

Job Description About the Job C# Dot Net Developer with Classic ASP - Waterloo London We are looking to recruit a C# Dot Net Developer for a Client based at Waterloo London. You must have at least 1 to 3 years experience of software development with the following: Classic-ASP T-SQL jQuery HTML & CSS You will have .NET or MVC experience almost certainly could work in classic-ASP. In addition you must have experience of MS SQL Server. The Client produces surveys which are all managed in-house using their own survey programming framework written in classic-ASP. The framework enables the team to create a new survey very quickly and efficiently, with a high degree of customisation and advanced features, (including in other languages) and publish real-time results via an online reporting platform. Salary will depend on level of experience - £25-£30K for a junior developer and up to £40K with at least 5 years experience. Please send your CV to Click here to contact this recruiter in Word format, along with your salary expectations and availability.

Job Description About the Job C# Dot Net Developer with Classic ASP - Waterloo London We are looking to recruit a C# Dot Net Developer for a Client based at Waterloo London. You must have at least 1 to 3 years experience of software development with the following: Classic-ASP T-SQL jQuery HTML & CSS You will have .NET or MVC experience almost certainly could work in classic-ASP. In addition you must have experience of MS SQL Server. The Client produces surveys which are all managed in-house using their own survey programming framework written in classic-ASP. The framework enables the team to create a new survey very quickly and efficiently, with a high degree of customisation and advanced features, (including in other languages) and publish real-time results via an online reporting platform. Salary will depend on level of experience - £25-£30K for a junior developer and up to £40K with at least 5 years experience. Please send your CV to Click here to contact this recruiter in Word format, along with your salary expectations and availability.

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. Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. 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. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language. Data warehouse design concepts, (Inmon or Kimball) Must have solid experience of working with SSIS and building data warehouses and some knowledge of reporting using SSRS. The Client is a Bank based in the Central London. This is a 12 month FTC position with a salary of circa £55K - £70K. You will be required to be in the office at least 3 days week. Do send your CV to us in Word format along with your salary and availability.

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

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

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.

Job Description MS SQL Server DBA Database Administrator - Investment Bank - Canary Wharf - London Our Client is an International Bank with offices in Canary Wharf London. They are now looking to recruit a Senior MS SQL Server DBA with at least 5 years expertise. Although the role is for a Senior MS SQL Server DBA - the Client would like you to have a background in Data Warehousing. As MS SQL Server DBA with Application Support you will be involved with developing and implementing solutions for the banks financial systems. As an MS SQL Server DBA role will involve the following: Ensure the integrity, security and accuracy of production database environment, ensuring good performance of the dependent applications. Plan and implement operating procedures for backup of database and recovery of database information. Develops database-related application development standards covering database creation, software placement, storage and auditing. Ensures the integrity of the recovery system at all times. Initiates formal testing of the recovery system. Develops database procedures as necessary to enhance the application suite as required. Responds to, resolves and documents support calls for the production and test applications. Maintains to a high standard documentation supporting the build, maintenance and operational procedures of the database environment. Acts as the technical liaison between database operations and vendor support. Performs other related duties as assigned. You must have at least 5 to 7 years solid expertise as a MS SQL Server DBA - Database Administrator. Must have the Microsoft SQL Server Administration (Enterprise Edition) experience. High Level T-SQL programming (SP, Functions, Triggers). Operation, design and implementation experience of Mirroring, Log Shipping and SQL Server Replication. SQL Reporting services and Analysis services maintenance and tuning. Configuration and operation of clustered database Servers using external storage. Scripting stored procedures. Security concepts of database management. Change management concepts and application The role will be to work as a MS SQL DBA with an element of supporting financial applications. Salary for this role is negotiable - but is expected to be in the range £55K - £70K + benefits. Please send your CV's to us in MS Word format.

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. Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. 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. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language. Data warehouse design concepts, (Inmon or Kimball) Must have solid experience of working with SSIS and building data warehouses and some knowledge of reporting using SSRS. The Client is a Bank based in the Central London. This is a 12 month FTC position with a salary of circa £55K - £70K. You will be required to be in the office at least 3 days week. Do send your CV to us in Word format along with your salary and availability.

Job Description Database Engineer with SQL Server Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. 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. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language. Data warehouse design concepts, (Inmon or Kimball) The Client is a Bank based in the City of London. This is a 2 year FTC position with a salary of circa £65K - £70K. Do send your CV to us in Word format along with your salary and availability.

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.