Database Engineer with SQL and C#

Jas Gujral; Greater London; On-site; GBP 55,000 - 60,000; Full time

Job summary

A financial institution based in the City of London is looking for a Database Engineer with strong expertise in SQL and C#. The successful candidate will develop solutions, support the Hyperion environment, and integrate with various bank sub-systems. The position requires at least 3-5 years of relevant experience, with a strong emphasis on C# programming and data warehouse design concepts. This is a full-time contract, initially for 6 months with a salary range of £55K to £60K per annum.

Qualifications

• Minimum 3 to 5 years of experience in SQL and C# development.
• Proficiency in advanced 4GL programming languages.
• Ability to perform debugging and analytical tasks.

Responsibilities

• Develop and support SQL and C# solutions.
• Manage and optimize the Hyperion environment.
• Integrate with Bank’s sub-systems using ODBC and ADO.net.

Skills

SQL Programming

C# Software development

Software analysis and design

Dimensional modelling

Data warehouse design concepts

Education

Degree level qualified or equivalent

Job description

Database Engineer – SQL and C#

Our Client is a City‑based bank – looking to recruit a Database Engineer with at least 3 to 5 years expertise of developing and supporting SQL and C#.

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

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

Integration with Bank Sub‑Systems

• To 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.
• Able to analyse and rectify any problems raised in an independent and team scenario.
• 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.

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

This is a Full‑Time Contract initially for 6 months – but likely to become permanent.

Salary for this position will be £55K – £60K per annum.

The Client is based in the City of London.

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