Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join a dynamic team to analyse data and ensure regulatory compliance in investment banking.
- Company: McGregor Boyall is a prestigious investment bank known for its innovative approach and commitment to excellence.
- Benefits: Earn £550/day with flexible work options; enjoy a collaborative and supportive environment.
- Why this job: Gain valuable experience in a fast-paced trading environment while making a real impact on compliance.
- Qualifications: Advanced Excel skills, SQL knowledge, and experience with financial regulations are essential.
- Other info: This is a 6-month contract role based in Belfast, starting immediately.
Business Data Analyst - Investment Banking
Belfast | £550/day | 6-Month Contract
Prestigious Investment Bank seeks experienced Business Analyst for Markets Division. We are recruiting for a skilled Business/Data Analyst to join the Markets business of a leading investment bank. This role offers excellent exposure to regulatory risk and reporting within a dynamic trading environment.
Contract Details
- Daily Rate: £550 (Inside IR35)
- Duration: 6 months (Contract ends 19th December 2025)
- Location: Belfast - 3 days per week on-site
- Start: Immediate
The Role
You will be working within the Markets division, focusing on regulatory compliance, risk analysis, and data-driven insights. This position requires someone who can navigate complex regulatory frameworks while delivering actionable business intelligence to support trading operations and compliance requirements.
Essential Requirements
- Technical Expertise: Advanced Excel proficiency including pivot tables, VLOOKUP, conditional functions, and statistical analysis; SharePoint administration and collaboration tools; SQL database querying capabilities with joins and data manipulation; Business Requirements Documentation (BRD) and Functional Specification Document (FSD) creation and interpretation.
- Regulatory & Risk Experience: Hands-on experience interpreting and analyzing complex financial regulations; Knowledge of key regulatory frameworks such as Regulation K, Basel III, MiFID II; Proven ability to distill complex regulatory requirements into clear, actionable summaries; Experience conducting thorough root cause analysis.
- Financial Markets Knowledge: Understanding of financial instruments including equities, fixed income securities, and derivatives; Familiarity with market data attributes: CUSIP, ISIN, trade dates, settlement dates; Experience working with financial datasets and market microstructure.
- Analytical Skills: Data modeling and regression testing experience; Strong attention to detail with commitment to data integrity; Ability to identify patterns and anomalies in complex datasets.
McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.
Contact Detail:
McGregor Boyall Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analytics Specialist - McGregor Boyall
✨Tip Number 1
Familiarise yourself with the key regulatory frameworks mentioned in the job description, such as Basel III and MiFID II. Understanding these regulations will not only help you in interviews but also demonstrate your commitment to the role.
✨Tip Number 2
Brush up on your SQL skills, particularly focusing on querying databases and data manipulation. Being able to showcase your technical expertise during discussions can set you apart from other candidates.
✨Tip Number 3
Prepare to discuss your experience with Business Requirements Documentation (BRD) and Functional Specification Documents (FSD). Having concrete examples ready will show your ability to translate complex requirements into actionable insights.
✨Tip Number 4
Stay updated on current trends in financial markets and instruments. This knowledge will not only help you answer questions more effectively but also demonstrate your genuine interest in the field during your interactions with us.
We think you need these skills to ace Data Analytics Specialist - McGregor Boyall
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data analytics, regulatory compliance, and financial markets. Use keywords from the job description to demonstrate that you meet the essential requirements.
Craft a Compelling Cover Letter: Write a cover letter that specifically addresses your experience with regulatory frameworks and data analysis. Explain how your skills align with the needs of the Markets division at McGregor Boyall.
Showcase Technical Skills: In your application, emphasise your proficiency in Excel, SQL, and any other relevant tools. Provide examples of how you've used these skills in previous roles to solve complex problems or improve processes.
Highlight Analytical Experience: Detail your experience with data modelling, root cause analysis, and working with financial datasets. Use specific examples to illustrate your ability to identify patterns and deliver actionable insights.
How to prepare for a job interview at McGregor Boyall
✨Showcase Your Technical Skills
Make sure to highlight your advanced Excel proficiency and SQL querying capabilities during the interview. Be prepared to discuss specific examples of how you've used these skills in previous roles, especially in relation to data manipulation and analysis.
✨Demonstrate Regulatory Knowledge
Familiarise yourself with key regulatory frameworks such as Basel III and MiFID II. During the interview, be ready to explain how you have interpreted and applied these regulations in past experiences, showcasing your ability to distill complex requirements into actionable insights.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your analytical skills and problem-solving abilities. Think of examples where you've conducted root cause analysis or identified patterns in complex datasets, and be ready to walk the interviewer through your thought process.
✨Understand Financial Markets
Brush up on your knowledge of financial instruments and market data attributes. Being able to discuss equities, fixed income securities, and derivatives confidently will demonstrate your understanding of the industry and your readiness for the role.
