SQL Server Database Engineer with SSIS

Free-Work UK

Greater London

Hybrid

GBP 65,000 - 75,000

Full time

5 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Free-Work UK is partnering with a Central London bank to recruit a Database Engineer with 5–7 years of solid experience in SQL Server, SSIS, and SSRS. You will develop data pipelines to collect, validate and prepare high-quality data for multiple departments.

Responsibilities include supporting SSIS ETLs (overnight and intraday), converting legacy Hyperion reports to SSRS, and building data models (SSAS). You will work with SharePoint and Equation platforms and provide end-of-day support while

Qualifications

  • Degree level qualification or equivalent.
  • Proficiency in MS SQL stack (SSIS, SSAS, SSRS) is essential.
  • C# and JavaScript programming are desirable.

Responsibilities

  • Develop and deliver data pipelines to collect, validate and prepare high-quality data.
  • Support and enhance SSIS ETLs (overnight and intraday) and improve robustness.
  • Convert legacy Hyperion reports to SSRS and build tabular models (SSAS).
  • Create reports in SSRS based on business requirements; integrate with bank subsystems.
  • Ensure regulatory compliance and perform risk and control activities.
  • Provide out-of-hours support and maintain training compliance.

Skills

MS SQL
SSIS
SSAS
SSRS
C#
JavaScript

Education

Degree level qualification or equivalent

Tools

Hyperion
SharePoint
4GL programming languages

Job description

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Engineer with SQL Server SSIS, SSRS and SSAS
Database Engineer with SQL Server SSIS, SSRS and SSAS

Free-Work UK • Greater London

On-site
GBP 55,000 - 70,000
Software Developer with C# Dot net SQL Server SSIS
Software Developer with C# Dot net SQL Server SSIS

Project Freelance • Greater London

Hybrid
GBP 60,000 - 70,000
Software Engineer with C# Dot net Asp Dot Net SQL Server SSIS
Software Engineer with C# Dot net Asp Dot Net SQL Server SSIS

Nexus Jobs • London

Hybrid
GBP 60,000 - 70,000
Data Analyst with SQL Server SSIS
Data Analyst with SQL Server SSIS

Project Freelance • Greater London

On-site
GBP 40,000 - 45,000
SQL Server Data Engineer - SSIS/SSRS/SSAS (Hybrid London)
SQL Server Data Engineer - SSIS/SSRS/SSAS (Hybrid London)

Free-Work UK • Greater London

Hybrid
GBP 65,000 - 75,000
Data Analyst with SQL Server SSIS and Network Engineer
Data Analyst with SQL Server SSIS and Network Engineer

Nexus Jobs Limited • Greater London

On-site
GBP 60,000 - 75,000
SQL Server Data Engineer (SSIS/SSRS/SSAS) – 12m FTC
SQL Server Data Engineer (SSIS/SSRS/SSAS) – 12m FTC

Free-Work UK • Greater London

On-site
GBP 55,000 - 70,000
Senior C# .NET & SQL Data Engineer (Hybrid, SSIS/SSRS)
Senior C# .NET & SQL Data Engineer (Hybrid, SSIS/SSRS)

Project Freelance • Greater London

Hybrid
GBP 60,000 - 70,000
Data Engineer
Data Engineer

Berkeley Square IT Ltd • City Of London

On-site
GBP 81,000 - 99,000
SQL DBA (DV)
SQL DBA (DV)

LA International • Reading

On-site
GBP 124,000 - 138,000