Position: Data Warehouse System Support Engineer
Company: Luxoft
Experience required: 3y
Category: SQL
English level: upper
Published: 2022-01-01T00:00:00+02:00

An exciting opportunity has opened up within Technology for an application support analyst who can provide day-to-day support of the AMIS Warehouse system, which provides daily P&L, GL and other finance data for the BANK of London, including data for regulatory reporting (to BOE via Vermeg and HMRC)

Responsibilities:
Main Purpose of the Role :
Development work for the Finance Application Development team, serving Finance. This role is to complete development tasks for the team in addition to BAU support of systems currently looked after by the team. We have a rapid development model, involving Infra Team QA, so QA experience with clear documentation skills is essential. There will be opportunities to work with Business users in Finance to carry out development work to automate their daily talks, with tasks including Business Analysis and technical documentation.

Key Responsibilities:
In this role, you will be responsible for Development work and Technical investigations across banking arm and securities business under a dual-hat arrangement. Under this arrangement, you will act and make decisions on behalf of both the bank and the securities business, subject to the same remit and level of authority, and irrespective of the entity which employs you.

- Help ensure that the business have no major outstanding issues with the Finance Intranet tools, data presented is accurate and timely, business are fully supported, web development work is completed on time with no major issues
- Support EMEA Repository (ER) data warehouse, resolve issues with overnight jobs, Investigate and resolve data issues
- Support Finance's Intranet tools
- Support Finance's SSRS reporting
Mandatory Skills Description:
Functional / Technical Competencies (essential):
- Understanding of data warehousing concepts and data problem investigation, diagnosis, and correction
- Solid and demonstrable development with MS SQL, SSIS, Sql Agent, T-SQL, SSRS
- Query Optimization
- Good debugging/ Hands-on approach
- Understanding of Business Analysis
- Good verbal communication skills.
- Strong Documentation Skills
- Strong QA

Work Experience (essential):
- Taking requirements from users
- Automation experience

Nice-to-Have Skills:
Functional / Technical Competencies (preferred):
• .net
• VBA
• Cognos/BI experience
• Snowflake/Cloud experience
Work Experience (preferred):
• Warehousing Project(s) for Finance Department

Work Experience (preferred):
- Experience working in Banking/Finance organizations
- Experience working on MI projects
- Finance/Banking business knowledge.

Education / Qualifications:
- Degree Educated
- Computer Science, Mathematics, Physics or similar technical discipline; alternatively professional Microsoft certification