Database Engineer with SQL and C#

Job Description
Database Engineer with SQL and C#

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

Software Development:

1. Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation end of day cycle.
2. Understanding business requirements in order to develop and deliver appropriate solutions based on system definition documents.
3. Proficiency in advanced 4GL programming languages and able to apply to the fully development life-cycle.

Database Support:

1. Supporting budgeting and financial planning processes for the Finance department, including loading and refreshing of data based on requirements.
2. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment.
3. Debug and analyze errors and anomalies within the Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues.
4. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment.
5. Build data flows within the SQL environment in SSIS packages.
6. Introduce new fields and data types for new information to be collated in the CORE environment.

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 utilize housekeeping procedures.

SharePoint Integration:

1. Integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry.
2. Utilize web services to integrate cutting-edge technology into legacy systems such as Equation.

End of Day Cycle:

1. Provide second and third level support for in-house programs during the end of day cycle.
2. Able to analyze and rectify any problems raised in an independent and team scenario.
3. Take ownership of a problem and deliver a solution in a timely manner.
4. Provide out of office hours support.

Risk & Regulatory Duties:

1. 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.
2. 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.
3. Accurately execute all controls within own area to minimize risk of policy, procedure, and/or regulatory breaches.
4. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department.

Training & Competence:

1. Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines.
2. Proactively seek to complete recommended technical and behavioral competencies training required for your role.

Conduct:

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

Business Continuity:

Fulfill all prescribed business continuity requirements as set out in the organizational or departmental specific plans or as instructed by the Line Manager/Head of Department.

Qualifications/Experience:

1. Degree level qualified or equivalent.
2. SQL Programming.
3. C# Software development.

Knowledge and Skills:

1. C# Programming to high level of proficiency.
2. Software analysis and design.
3. SQL query language.
4. Dimensional modeling.
5. 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.