Database Engineer with SQL Server and SSIS

Job Description

Position: Database Engineer with SQL Server and SSIS

Company: Our Client is a bank based in Central London looking to recruit a Database Engineer with the ability to work with SSIS.

Responsibilities:

1. Develop and deliver new systems to automate and streamline processes required by different departments.
2. Support the internal IT department with changes and upgrades to software platforms.
3. Act as the primary contact for all technical questions relating to in-house bespoke systems and interfacing.
4. Support budgeting and financial planning processes for the Finance department, including loading and refreshing of data based on requirements.
5. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment.
6. Debug and analyze errors and anomalies within the Hyperion system as raised by Finance, pinpointing areas of failure and correcting any issues.
7. Liaise with Finance daily to ensure the smooth running of the Hyperion environment.
8. Build data flows within the SQL environment in SSIS packages.
9. Maintain knowledge of all applicable regulatory requirements including the Bank's Risk and Compliance policies and procedures.
10. Report policy/procedure breaches and areas of potential non-compliance promptly upon identification.
11. Accurately execute all controls within own area to minimize risk of policy, procedure, and/or regulatory breaches.
12. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department.

Qualifications/Experience:

1. Degree level qualified or equivalent.
2. SQL Programming.

Knowledge and Skills:

1. Software analysis and design.
2. SQL query language.
3. Data warehouse design concepts (Inmon or Kimball).
4. Solid experience of working with SSIS and building data warehouses.
5. Some knowledge of reporting using SSRS.

Position Details:
This is a 12 month FTC position with a salary of circa £55K - £70K. You will be required to be in the office at least 3 days a week.

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