Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our Data team to analyse risk data and support investment decisions.
- Company: A leading global asset manager focused on innovative investment strategies.
- Benefits: Enjoy hybrid working, competitive salary up to £100k, bonuses, and great perks.
- Why this job: Be part of a dynamic team shaping the future of investment management with data.
- Qualifications: 5+ years as a Data Analyst in financial services, with strong SQL and Power BI skills.
- Other info: Work close to major tube stations in London, with a collaborative and supportive culture.
The predicted salary is between 60000 - 84000 £ per year.
A leading global asset manager, responsible for assets under management across liability driven investment (LDI), cashflow-driven investing (CDI) and longevity hedging, currency management, fixed income, absolute return, multi-asset and specialist investment strategies, is looking to add to their Data team by hiring a Data Analyst, coming from a financial services / Trading House background with knowledge around Risk, regulations, Compliance, Trade Surveillance etc.
The Data Analyst will join the Data Centre of Excellence, encompassing Data Analysis, Data Architecture, Data Intelligence and Machine Learning experts. This Data team helps the Investment Management House make use of their data to help make investment and risk decisions.
As a Data Analyst, you will be responsible for proactively managing aspects of the data acquisition and commercial lifecycle to create P&L impacting value for the investment business. Specifically within compliance, understanding the data needed from the business to make decisions, bridging the gap between the Business & Data technical experts.
The company works a hybrid model, with 3 days per week in the office, close to major tube stations including Liverpool Street.
As a Data Analyst you will:
- Analyse Risk data sourcing, how it flows and is housed in the organisation.
- Map how to acquire data from primary and secondary sources and maintain data systems.
- Migrate legacy data warehouse to strategic data platform.
- Identify, collect and migrate data to and from a range of systems into the central Data Platform, working closely with the Data Management Team.
- Analyse normalised transactional data and analytic data sources.
- Analyse semi-structured and file-based data extracts.
- Data modelling to transform operational data into analytic/reporting structures such as Kimball style multi-dimensional models.
Essential Skills for the Data Analyst:
- Proven Data Analyst experience of at least 5 years, within a Financial Services environment, with particular emphasis on Risk or cross asset derivatives areas.
- Data modelling, cleansing and enrichment, with experience in conceptual, logical and physical data modelling and data cleansing and standardisation.
- Familiarity with Data warehousing and analytical data structures.
- Data quality assurance, validation and linkage.
- Experience creating BI models and dashboards, ideally in Power BI.
- Software development methodologies (Sprints/Agile) and project management software (Jira Software).
- SQL Server Database.
- Databricks (or Alternative Modern Data Platform such as Snowflake).
- Knowledge of Orchestration Tools and processes (e.g. SSIS, ODI, Informatica, Data Factory).
- Power BI Development including the data model, DAX, and visualisations.
If you are interested in this Data Analyst role, please reply with your latest CV or send it to toby@virtuetech.io.
Data Analyst SQL - Hybrid Working employer: VirtueTech Recruitment Group
Contact Detail:
VirtueTech Recruitment Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst SQL - Hybrid Working
✨Tip Number 1
Familiarise yourself with the specific data tools mentioned in the job description, such as Power BI and SQL Server. Having hands-on experience or even personal projects showcasing your skills with these tools can set you apart from other candidates.
✨Tip Number 2
Network within the financial services sector, especially with professionals who work in data analysis or investment management. Attend industry events or webinars to make connections that could lead to referrals or insider information about the role.
✨Tip Number 3
Brush up on your knowledge of risk management and compliance regulations relevant to the financial services industry. Being able to discuss these topics confidently during an interview will demonstrate your understanding of the business context behind the data.
✨Tip Number 4
Prepare to discuss your previous experiences with data migration and data modelling in detail. Be ready to provide examples of how you've successfully managed data projects, as this will show your practical expertise and problem-solving abilities.
We think you need these skills to ace Data Analyst SQL - Hybrid Working
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience in financial services, particularly in risk analysis and data management. Use specific examples that demonstrate your skills in SQL, Power BI, and data modelling.
Craft a Compelling Cover Letter: Write a cover letter that connects your background to the job description. Emphasise your understanding of compliance, trade surveillance, and how your previous roles have prepared you for this position.
Showcase Relevant Skills: In your application, clearly outline your proficiency in data warehousing, BI models, and any orchestration tools you've used. Mention your familiarity with Agile methodologies and project management software like Jira.
Proofread and Edit: Before submitting your application, carefully proofread your documents for any errors or typos. A polished application reflects your attention to detail, which is crucial for a Data Analyst role.
How to prepare for a job interview at VirtueTech Recruitment Group
✨Showcase Your Financial Services Experience
Make sure to highlight your previous experience in financial services, especially if you've worked with risk or cross-asset derivatives. Be prepared to discuss specific projects or challenges you've faced in this area.
✨Demonstrate Your Data Modelling Skills
Since data modelling is crucial for this role, come prepared to explain your approach to conceptual, logical, and physical data modelling. You might even want to bring examples of your work or discuss how you've tackled data cleansing and enrichment.
✨Familiarise Yourself with Power BI
As Power BI development is a key requirement, ensure you can discuss your experience creating BI models and dashboards. Be ready to talk about the data model, DAX, and visualisations you've implemented in past projects.
✨Understand the Company’s Data Strategy
Research the company's data strategy and how they utilise data for investment and risk decisions. This will help you align your answers with their goals and demonstrate your genuine interest in the role.
