Database Engineer
Job description
Job Description
Position: Database Engineer
Responsibilities:
- Develop and deliver new systems to automate and streamline processes required by different departments.
- Support the internal IT department with changes and upgrades to software platforms.
- Act as the primary contact for all technical questions relating to in-house bespoke systems and interfacing.
- Support budgeting and financial planning processes for the Finance department, including loading and refreshing of data based on requirements.
- Understand and conduct front-end functionality to amend and change hierarchical structures within the environment.
- Debug and analyze errors and anomalies within the Hyperion system as raised by Finance and correct any issues.
- Liaise with Finance daily to ensure smooth running of the Hyperion environment.
- Build data flows within the SQL environment using SSIS packages.
- Introduce new fields 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 utilize house-keeping procedures.
- Integrate the SharePoint environment and Forms with the Equation system to introduce automation of processes.
- Utilize web services to integrate cutting-edge technology into legacy systems such as Equation.
- Provide second and third level support for in-house programs during the end of day cycle.
- Analyze and rectify any problems raised independently or in a team scenario.
- Take ownership of problems and deliver solutions 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.
- Report policy/procedure breaches and areas of potential non-compliance promptly.
- Accurately execute all controls to minimize risk of policy, procedure, and/or regulatory breaches.
- Identify new risks/control gaps 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.
- 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.
Qualifications/Experience:
- Degree level qualified or equivalent.
- SQL Programming.
- C# Software development.
Knowledge and Skills:
- C# Programming to a high level of proficiency.
- Software analysis and design.
- SQL query language.
- Dimensional modeling.
- Data warehouse design concepts (Inmon or Kimball).
Company Information:
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.
Please send your CV in Word format along with your salary and availability.