Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join a dynamic team to analyse risk data and enhance investment decisions.
- Company: A leading global asset manager focused on innovative investment strategies.
- Benefits: Enjoy a hybrid work model, competitive salary, bonuses, and great perks.
- Why this job: Be part of a cutting-edge Data Centre of Excellence with real impact on investments.
- 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, fostering a collaborative environment.
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, BI, Databases) 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, BI, Databases)
✨Tip Number 1
Familiarise yourself with the specific tools and technologies mentioned in the job description, such as Power BI, SQL Server, and Databricks. Having hands-on experience or relevant projects to discuss can set you apart during interviews.
✨Tip Number 2
Network with professionals in the financial services sector, especially those working in data analysis roles. Attend industry events or join online forums to gain insights and potentially get referrals that could help you land the job.
✨Tip Number 3
Prepare to discuss your understanding of risk management and compliance in relation to data analysis. Being able to articulate how data impacts investment decisions will demonstrate your relevance to the role.
✨Tip Number 4
Showcase your problem-solving skills by preparing examples of how you've tackled data challenges in previous roles. This will highlight your ability to bridge the gap between business needs and technical solutions, which is crucial for this position.
We think you need these skills to ace Data Analyst (SQL, BI, Databases)
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 Projects: Include details about any relevant projects you've worked on, especially those involving data migration, BI models, or data quality assurance. This will help illustrate your hands-on experience.
Highlight Technical Skills: Clearly list your technical skills related to the role, such as SQL Server, Databricks, and Power BI development. Mention any experience with orchestration tools and project management methodologies like Agile.
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 in areas related to risk and compliance. Be prepared to discuss specific projects or challenges you've faced and how you overcame them.
✨Demonstrate Your Data Modelling Skills
Since data modelling is crucial for this role, come prepared with examples of your work. Discuss the methodologies you've used, such as Kimball style models, and be ready to explain your approach to data cleansing and enrichment.
✨Familiarise Yourself with Power BI
As Power BI is a key tool for this position, ensure you can discuss your experience with it confidently. Bring examples of dashboards or reports you've created, and be ready to explain the data model and DAX calculations you've implemented.
✨Understand the Company’s Data Strategy
Research the company's data strategy and how they utilise data for investment decisions. This will help you align your answers with their goals and demonstrate your genuine interest in contributing to their data team.
