Aller au contenu
Toutes les missions
Veille marché · Freework Publiée il y a 1 mois

SQL Server Database Engineer with SSIS

SQL Server Database Engineer with SSISOur 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 Serve...

Entreprise Nexus Jobs Limited
Mode Angleterre (Royaume-Uni)

Résumé

<p><strong>SQL Server Database Engineer with SSIS</strong></p><br /><p>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.</p><br /><p>Responsible for the development and delivery of pipelines (collect, validate and prepare high quality data) to automate and streamline processes required by different departments.</p><br /><p>Support existing SSIS ETLs (overnight and intraday), proactively fine-tune and enhance existing codes to increase robustness and error monitoring.</p><br /><p>Support the internal IT department with changes and upgrades to software platforms. </p><br /><p>Convert legacy Hyperion reports to SSRS.</p><br /><p><strong>Software Development:</strong></p><br /><p>Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation end of day cycle. </p><br /><p>Understanding business requirements in order to develop and deliver appropriate solutions based on system definition documents. </p><br /><p>Proficiency in advanced 4GL programming languages and able to apply to the fully development life-cycle.</p><br /><p><strong> </strong></p><br /><p><strong>Database Support</strong></p><br /><p>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.</p><br /><p>To build tabular models (SSAS) for different business units.</p><br /><p>To build reports based on business requirements using SQL SSRS. </p><br /><p>To integrate with all the Bank’s sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net. </p><br /><p>Ensure that the environment is running optimally and with high standard house-keeping procedures.</p><br /><p><strong>Sharepoint Integration:</strong></p><br /><p>To integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry.  </p><br /><p>To utilise web services to integrate from cutting edge technology into legacy systems such as Equation.</p><br /><p><strong>End of Day Cycle:</strong></p><br /><p>To provide second and third level support for in-house programmes during the end of day cycle. </p><br /><p>To be able to analyse and rectify any problems raised in an independent and team scenario. </p><br /><p>To take ownership of a problem and deliver a solution in a timely manner. </p><br /><p>Provide out of office hours support.</p><br /><p><strong>Risk &amp; Regulatory Duties</strong></p><br /><p>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. </p><br /><p>Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank&#039;s Risk and Compliance policies. </p><br /><p>Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches. </p><br /><p>Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department. </p><br /><p><strong>Training &amp; Competence</strong></p><br /><p>Complete all annual mandatory regulatory refresher training as per the Bank&#039;s training plans and deadlines. </p><br /><p>Proactively seek to complete recommended technical and behavioural competencies training required for your role.  </p><br /><p>Act in accordance with the FCA/PRA Code of Conduct.</p><br /><p>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.</p><br /><p> </p><br /><p><strong>Qualifications/Experience  </strong></p><br /><p>Degree level qualified or equivalent. </p><br /><p>MS SQL stack (SSIS, SSAS, SSRS) to high level of proficiency - Essential</p><br /><p>C# Programming / JavaScript programming - Desirable</p><br /><p><strong> </strong></p><br /><p><strong>Knowledge and Skills</strong></p><br /><p>Software analysis and design good practice</p><br /><p>Dimensional modelling, Entity Relationship modelling, Normalised modelling.</p><br /><p>Data warehouse design concepts, (Inmon, Kimball)</p><br /><p> </p><br /><p>The position is based in Central and you will be required to be in the office for 3 days a week.</p><br /><p>Please note the Client does NOT provide sponsorship.</p><br /><p>The salary for this position is in the range £65K – £75K.</p><br /><p>Please do send your CV to us in Word format along with your salary and availability.</p><br /><p> </p><br /><p> </p><br /><p> </p><br /><p> </p>