Database Engineer with SQL Server SSIS, SSRS and SSAS

Jas Gujral; Greater London; Hybrid; GBP 55,000 - 70,000; Full time

Job summary

A financial services company based in Greater London is seeking a Database Support professional to assist with budgeting and financial planning processes. The role involves debugging and analyzing errors within the Hyperion system, building data flows using SQL in SSIS, and liaising with the Finance team regularly. Candidates should possess a degree or equivalent, strong SQL programming skills, and experience with SSIS and data warehouse design. This position is a 12-month fixed-term contract with a competitive salary range of £55K - £70K, requiring in-office attendance at least three days a week.

Qualifications

• Degree level qualification or equivalent is required.
• Strong SQL programming skills are essential.
• Experience with SQL Server Integration Services (SSIS) is mandatory.

Responsibilities

• Support budgeting and financial planning processes for the Finance department.
• Debug and analyze errors within the Hyperion system.
• Liaise with Finance for smooth operations of the Hyperion environment.

Skills

SQL Programming

Software analysis and design

SSIS

SSRS

SSAS

Data warehouse design concepts

Risk and Compliance knowledge

Education

Degree level qualified or equivalent

Tools

SQL

Hyperion

SSIS

SSRS

Job description

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 elevate 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 with SSIS SSRS and SSAS.

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.

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

Do send your CV to us in Word format along with your salary and availability.