SQL Server Developer with SSIS and SSRS

Free-Work UK; London; On-site; GBP 60,000 - 75,000; Full time

Job summary

A leading company in the banking sector seeks a SQL Server Developer with extensive experience in SSIS and SSRS. The role involves developing data pipelines, maintaining existing systems, and ensuring compliance with regulatory requirements. This position offers a competitive salary and requires presence in the office 3 days a week to meet project demands.

Qualifications

• 5 to 7 years of experience in SQL Server, SSIS, and SSRS.
• Proficiency in advanced 4GL programming languages.
• Experience in building data pipelines using SSIS.

Responsibilities

• Develop and deliver pipelines to automate and streamline processes.
• Support existing SSIS ETLs and enhance existing codes.
• Build tabular models and reports based on business requirements.

Skills

Database Engineering

SQL Server

SSIS

SSRS

C# Programming

JavaScript Programming

Education

Degree level qualified or equivalent

Job description

Join to apply for the SQL Server Developer with SSIS and SSRS role at Free-Work UK

Join to apply for the SQL Server Developer with SSIS and SSRS role at Free-Work UK

Get AI-powered advice on this job and more exclusive features.

This range is provided by Free-Work UK. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

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.

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Human Resources Services

Referrals increase your chances of interviewing at Free-Work UK by 2x

Sign in to set job alerts for “SQL Developer” roles.

London, England, United Kingdom 2 weeks ago

Senior Business Intelligence (BI) Developer

London, England, United Kingdom 3 weeks ago

SQL Database Developer - Up to £80k Base Salary + Bonus

Business Intelligence Developer (Looker)

London, England, United Kingdom 3 weeks ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 3 days ago

London, England, United Kingdom 6 days ago

London, England, United Kingdom $40,000.00-$50,000.00 2 weeks ago

Greater London, England, United Kingdom 1 month ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 13 hours ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 day ago

BI Developer (Power BI) - Up to £800 P/D - London/Hybrid

Hedge Fund - Risk Database and Analytics Developer

London, England, United Kingdom 2 days ago

St Albans, England, United Kingdom 1 week ago

Chiswick, England, United Kingdom 1 day ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom £60,000.00-£80,000.00 1 month ago

London, England, United Kingdom 3 weeks ago

London Area, United Kingdom £30,000.00-£35,000.00 11 hours ago

London, England, United Kingdom 1 week ago

Data Engineer | Python | ETL | Spark | Databases | Snowflake | AWS | Hybrid, London

Senior Microsoft SQL Developer - Fintech SaaS. Full Remote, RECRUITMENTREVOLUTION.COM

London, England, United Kingdom 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.