Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse data using VBA and SQL to support business decisions.
- Company: Join a leading financial institution based in Canary Wharf, London.
- Benefits: Enjoy a competitive daily rate and the chance to work in a dynamic environment.
- Why this job: Make an impact in finance while developing your analytical skills in a collaborative team.
- Qualifications: 5+ years as a Business Analyst with strong VBA and SQL skills required.
- Other info: This is a short-term assignment lasting 3 to 6 months.
The predicted salary is between 43200 - 72000 £ per year.
Our Client, a financial institution with offices in Canary Wharf London, is looking to recruit a Data Analyst with VBA and PL/SQL development experience. You must have at least 5+ years of experience as a Business Analyst in the Financial sector.
- Excellent ability to profile data and come to substantive conclusions in response to business questions.
- Ability to communicate conclusions through writing clear documentation or through verbal communication to both business and IT users.
- Attention to detail and ability to grasp underlying complexities in data.
- Strong VBA and SQL skills with respect to data profiling and data discovery, as well as high proficiency in MS Excel.
- Must have development and definitional knowledge of VBA and PL/SQL and ETL (the fundamental concepts, rather than actual scripting or development, although experience developing is a plus).
- Exposure to BREs and data mapping exercises.
- Experience in functional and data testing.
- Grasp of data modelling concepts and ability to create data flow diagrams.
- Knowledge of financial markets, ratings and financial data (significant exposure is a plus, but not required).
- Strong team player with a focus on quality, attention to detail with excellent communication and written skills.
This is a 3 to 6 month assignment in Canary Wharf London. Please send your CV to us in Word format along with daily rate and availability.
Data Analyst with VBA and SQL employer: Nexus
Contact Detail:
Nexus Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst with VBA and SQL
✨Tip Number 1
Make sure to brush up on your VBA and SQL skills before the interview. Practising real-world scenarios where you can demonstrate your data profiling abilities will show that you're not just familiar with the concepts, but that you can apply them effectively.
✨Tip Number 2
Familiarise yourself with the financial sector, especially if you have experience in it. Understanding the specific challenges and data needs of financial institutions will help you articulate how your skills can directly benefit the company.
✨Tip Number 3
Prepare to discuss your previous projects in detail, particularly those involving data mapping and ETL processes. Being able to explain your role and the impact of your work will demonstrate your expertise and problem-solving capabilities.
✨Tip Number 4
Practice your communication skills, both verbal and written. Since the role requires clear documentation and interaction with both business and IT users, being able to convey complex data insights in an understandable way is crucial.
We think you need these skills to ace Data Analyst with VBA and SQL
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your 5+ years of experience as a Business Analyst in the Financial sector. Emphasise your skills in VBA, SQL, and data profiling, ensuring that you align your experiences with the job requirements.
Craft a Strong Cover Letter: Write a cover letter that clearly outlines your relevant experience and how it relates to the role. Mention specific projects where you've used VBA and PL/SQL, and demonstrate your ability to communicate complex data insights effectively.
Showcase Your Technical Skills: In your application, provide examples of your proficiency in MS Excel, data mapping, and ETL concepts. If you have experience with data modelling or financial markets, be sure to include that as well.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any errors. Attention to detail is crucial for this role, so ensure your application reflects that quality.
How to prepare for a job interview at Nexus
✨Showcase Your Technical Skills
Make sure to highlight your proficiency in VBA and SQL during the interview. Be prepared to discuss specific projects where you've used these skills, as well as any challenges you faced and how you overcame them.
✨Demonstrate Data Profiling Expertise
Since the role requires strong data profiling abilities, come equipped with examples of how you've analysed data in the past. Discuss the methodologies you used and the conclusions you drew that impacted business decisions.
✨Communicate Clearly
Effective communication is key, especially when conveying complex data insights. Practice explaining your findings in a straightforward manner, both verbally and in writing, to ensure you can engage both technical and non-technical stakeholders.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving skills and attention to detail. Think of situations where you had to analyse data under pressure or resolve discrepancies, and be ready to explain your thought process.
