Database Engineer with SQL Server SSIS, SSRS and SSAS

Job Title: Database Engineer with SQL Server SSIS, SSRS and SSAS

Company: Our Client is a bank based in Central London looking to recruit a Database Engineer with expertise in 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 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 and correct any issues.
7. Liaise with Finance daily to ensure 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.
11. Accurately execute all controls within own area to minimize risk of breaches.
12. Identify new risks/control gaps within own area and escalate accordingly.

Qualifications/Experience:

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

Knowledge and Skills:

1. Software analysis and design.
2. SQL query language with SSIS, SSRS, and SSAS.
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.

To apply, please send your CV in Word format along with your salary and availability.