SQL Technical Business Analyst - Investment Management

Bowers Partnership; City; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading investment management firm is looking for an SQL Technical Business Analyst to join their Risk & Performance Technologies team. The role involves assisting with data migration for a transactions-based attribution reporting system and supporting file upload requirements for a new risk system implementation. The ideal candidate will possess strong SQL development skills, experience in performance and risk vendor systems, and a solid understanding of data architecture. Great compensation and progression opportunities are offered.

Benefits

High annual bonus

Sports club membership subsidy

Season ticket loans interest-free

Cycle to work scheme

25 days holiday increasing after 5 years

Non-contributory pension scheme – 10% basic salary

Dental plan scheme

Private healthcare for employee partner & children

Childcare voucher scheme

Critical illness cover

Qualifications

• Experience in a performance attribution or risk system implementation.
• Strong understanding of data and systems architecture.
• Knowledge of all asset-classes and derivatives.

Responsibilities

• Assist with loading historical data for migration.
• Support file upload requirements for risk system.
• Provide 3rd line platform support for SQL queries and extracts.
• Communicate requirements to the Vendor.
• Prepare test packs for complex support solutions.

Skills

Strong SQL analysis and development expertise

Experience with Performance and attribution vendor systems

Experience with Risk vendor systems

Familiarity with Bloomberg, Qlikview & thinkFolio

Job description

SQL Technical Business Analyst - Investment Management

SQL Technical Business Analyst

Our Investment Management client is looking for an SQL Technical Business Analyst to join the Risk & Performance Technologies team on a permanent basis.

This would ideally suit someone with a strong personality with the ability to multi-task, work to tight deadlines and cope well under pressure.

Ideally you will have experience of working on a Performance Attribution or Risk system implementation or upgrade project – systems such as StatPro, FactSet, BISAM, UBS Delta, Aladdin, Barra, RiskMetrics etc.

Our client offers excellent compensation with annual bonuses well above the norm for the Asset Management sector, as well as real chances for progression.

Benefits

• High annual bonus
• Sports club membership subsidy - Fitness First & Virgin Active
• Season ticket loans interest free
• Cycle 2 work scheme
• 25 days holiday increasing after 5 years
• Non-contributory pension scheme 10% basic salary
• Dental plan scheme
• Private healthcare - for employee partner & children
• Childcare voucher scheme
• Critical illness cover

Key Responsibilities

• The SQL Technical Business Analyst would be assisting with the loading of historical data to support the migration to a transactions-based attribution reporting system
• Assisting with the file upload requirements for the new risk system implementation
• The Technical Business Analyst should have familiarisation with all extracts from the data warehouse going to downstream risk and performance systems
• 3 rd line platform support of these SQL queries and extracts, optimisation, liaison with the business and Business Analysts to assist with troubleshooting
• Communicating requirements to the Vendor
• Preparation of test packs to reflect the business requirement for more complex 3 rd line support solutions and mini-projects

Skills

• Strong SQL analysis and development expertise.
• Performance and attribution vendor systems experience
• Risk vendor systems experience
• Experience with Bloomberg, Qlikview & thinkFolio would be an advantage.

Technical Knowledge and Experience

• A strong understanding of data and systems architecture in the context of Front Office and Operations
• End to end investment life-cycle knowledge from dealing to downstream reporting
• Knowledge of all asset-classes and the use of Derivatives.
• A good understanding of the full project life cycle.