Summary: The Hedge Fund SQL/Oracle Data Analyst role involves collaborating with developers and business partners to gather and implement business requirements for a new regulatory component. The position requires strong SQL skills and experience with large datasets, focusing on database performance optimization and data migration. The analyst will also support testing processes and validate solutions to ensure quality. This is a 12-month initial contract role based in London with hybrid working arrangements.

Key Responsibilities:

• Ownership of Analysis and Documentation: Capture and define requirements, analyze and document new data feeds and the migration of existing data, and collaborate with other teams.
• Collaboration with Developers: Partner with developers to build new data feeds and migrate existing data, including creating SQL scripts and stored procedures.
• Testing and Validation: Support testing processes and validate solutions to ensure quality, assist in configuring test automation tools.

Key Skills:

• Preferred experience with investment banking datasets, such as Trades, Positions, P&L, and Reference Data.
• Strong SQL Skills and experience working with large datasets.
• Optimize database performance by analyzing query execution plans, index tuning, and database normalization.
• Utilize window functions for advanced analytical operations.
• Troubleshoot and resolve data-related issues.
• Understanding of testing methodologies to ensure accuracy in production.
• Exposure to AWS Data Warehousing is desirable.

Salary (Rate): undetermined

City: London

Country: UK

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT