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.