Data Analyst with VBA and SQL

Jas Gujral; Greater London; On-site; GBP 92,000 - 138,000; Full time

Job summary

Jas Gujral is seeking a Data Analyst with VBA programming and PL/SQL experience for a 3–6 month assignment in Canary Wharf, London. The role requires 5+ years in the financial sector, strong data profiling skills, and excellent written and verbal communication to bridge business and IT teams.

Candidates should have advanced Excel skills, expertise in VBA/PL-SQL, and a solid understanding of ETL concepts, data mapping, and data modelling. The position emphasizes quality and attention to detail.

Qualifications

• 5+ years of experience as a Business Analyst in the Financial sector.
• Excellent ability to profile data and reach substantive conclusions.
• Ability to communicate conclusions through writing documentation or verbal communication to business/IT users.
• Attention to detail and grasp of underlying data complexities.
• Strong VBA and SQL skills with high proficiency in MS Excel.
• Must have development/definitional knowledge of VBA and PL/SQL and ETL concepts.
• Exposure to BREs and data mapping exercises.
• Experience in functional and data testing.
• Knowledge of data modelling concepts and data flow diagrams.

Responsibilities

• Profile data and derive substantive conclusions in response to business questions.
• Communicate conclusions through clear documentation or verbal communication to business and IT users.
• Create data flow diagrams and understand data modelling concepts.
• Demonstrate attention to detail and grasp underlying data complexities.
• Collaborate with business and IT teams to ensure data quality and accuracy.

Skills

VBA

PL/SQL

SQL

Excel

Data profiling

Data mapping

ETL concepts

Documentation

Communication

Tools

BREs

Job description

Data Analyst with VBA programming and PL/SQL

Our Client a financial institution with offices in Canary Wharf London – are 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.