Data Analyst (SQL, BI, Databases)

Data Analyst (SQL, BI, Databases)

London Full-Time 60000 - 84000 £ / year (est.) No home office possible
V

At a Glance

  • Tasks: Join a dynamic team to analyse and manage data for 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 in Data Analysis within Financial Services, strong SQL and Power BI skills required.
  • 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. You will 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

As a leading global asset manager based in London, we pride ourselves on fostering a dynamic and inclusive work culture that prioritises employee growth and development. Our hybrid working model allows for flexibility while being close to major transport links, ensuring a balanced work-life experience. With competitive salaries, performance bonuses, and a comprehensive benefits package, we empower our Data Analysts to make impactful contributions within a collaborative team of experts in the Data Centre of Excellence.
V

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

Brush up on your knowledge of risk management, compliance, and trade surveillance, as these are crucial areas for this role. Being able to speak confidently about these topics will demonstrate your understanding of the industry.

✨Tip Number 4

Prepare to discuss your experience with data modelling and data quality assurance in detail. Be ready to provide examples of how you've successfully managed data projects in the past, particularly in a financial context.

We think you need these skills to ace Data Analyst (SQL, BI, Databases)

Data Analysis
SQL Server Database
Power BI Development
Data Modelling
Data Cleansing and Enrichment
Data Warehousing
Analytical Data Structures
Data Quality Assurance
Validation and Linkage
Experience with Databricks or Snowflake
Knowledge of Orchestration Tools (e.g. SSIS, ODI, Informatica, Data Factory)
Understanding of Risk and Compliance in Financial Services
Software Development Methodologies (Sprints/Agile)
Project Management Software (Jira Software)
Ability to Create BI Models and Dashboards

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience in data analysis, particularly within financial services. Emphasise your skills in SQL, Power BI, and data modelling, as well as any relevant projects that showcase your ability to manage risk data.

Craft a Compelling Cover Letter: Write a cover letter that connects your background in data analysis with the specific requirements of the role. Mention your understanding of compliance, risk management, and how you can bridge the gap between business needs and technical data solutions.

Showcase Relevant Projects: Include examples of past projects where you successfully migrated data or created BI models. Highlight your experience with data quality assurance and any tools you've used, such as Databricks or orchestration tools.

Proofread and Format: Before submitting your application, ensure that your documents are free from errors and formatted professionally. A clean, well-organised 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 experience in financial services, particularly in risk management and compliance. Be prepared to discuss specific projects or challenges you've faced in these areas, as this will demonstrate your understanding of the industry.

✨Demonstrate Your Data Modelling Skills

Since data modelling is a key part of the role, be ready to explain your approach to creating conceptual, logical, and physical data models. You might even want to bring examples of your previous work to illustrate your expertise.

✨Familiarise Yourself with Power BI

As Power BI is essential for this position, ensure you can discuss your experience with it confidently. Prepare to talk about specific dashboards you've created and how they impacted decision-making within your previous roles.

✨Understand the Company’s Data Strategy

Research the company’s data strategy and how they utilise data for investment decisions. Being able to discuss their approach and how you can contribute to their goals will show your genuine interest in the role and the organisation.

Data Analyst (SQL, BI, Databases)
VirtueTech Recruitment Group
V
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>