Database Engineer

Jas Gujral; London; On-site; GBP 65,000 - 70,000; Full time

Job summary

An established industry player is seeking a Database Engineer to enhance their internal systems and streamline operations. In this pivotal role, you will be responsible for developing new systems, supporting financial planning processes, and ensuring optimal performance of the Hyperion environment. You will collaborate closely with the Finance department, troubleshoot issues, and integrate cutting-edge technology with legacy systems. This position offers a unique opportunity to work in a dynamic environment where your contributions will directly impact efficiency and compliance. If you're ready to take on a challenge and make a difference, this is the role for you.

Qualifications

• Degree level qualified or equivalent required.
• Proficiency in SQL and C# programming is essential.

Responsibilities

• Develop and deliver new systems to automate processes across departments.
• Provide support for budgeting and financial planning processes.

Skills

SQL Programming

C# Programming

Software Analysis and Design

Dimensional Modelling

Data Warehouse Design Concepts

Education

Degree Level Qualified or Equivalent

Tools

Hyperion

SSIS

SharePoint

Job description

Database Engineer

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.

Introduce new field and data types for new information to be collated in the CORE environment.

Integrate with all the Bank’s sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net.

Build reports based on business requirements using Hyperion Interactive Reports.

Ensure that the environment is running optimally and to utilise house-keeping procedures.

Sharepoint Integration:

Integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry.

Utilise web services to integrate from cutting edge technology into legacy systems such as Equation.

End of Day Cycle:

Provide second and third level support for in-house programmes during the end of day cycle.

Analyse and rectify any problems raised in an independent and team scenario.

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.

Conduct

Act in accordance with the FCA/PRA Code of Conduct.

Business Continuity

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.

SQL Programming.

C# Software development.

Knowledge and Skills

C# Programming to high level of proficiency.

Software analysis and design.

SQL query language.

Dimensional modelling

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.