At a Glance
- Tasks: Own testing activities for financial applications, ensuring data accuracy and system reliability.
- Company: Join a leading financial services organisation in London with a focus on innovation.
- Benefits: Competitive pay, flexible working options, and opportunities for professional growth.
- Other info: Dynamic team environment with a commitment to diversity and equal opportunities.
- Why this job: Make an impact in the financial sector while honing your SQL and testing skills.
- Qualifications: Experience in SQL testing within financial services and strong analytical skills.
The predicted salary is between 63000 - 77000 £ per year.
Job Title: Senior SQL Test Analyst
Location: London
Start Date: November
Job Type: Inside IR35
We are seeking an experienced Senior SQL Test Analyst to join a financial services organisation on an initial six-month contract.
The role will involve working across complex financial applications, ensuring that business processes function correctly and that information is accurately processed, transferred and maintained across multiple systems.
We are particularly interested in candidates who combine strong SQL and database testing capabilities with a solid understanding of financial services, ideally gained within banking, investment management, asset management or capital markets environments.
Key Responsibilities
- Take ownership of testing activities across financial applications, from interpreting requirements through to execution and defect resolution.
- Use SQL to investigate underlying data, verify financial calculations and identify inconsistencies between systems.
- Assess data quality and integrity across databases, interfaces and reporting environments.
- Carry out functional, integration and regression testing to ensure systems operate reliably across business processes.
- Examine data movements and transformations, investigating discrepancies and working with technical teams to resolve issues.
- Produce test documentation, record defects and communicate testing progress to project stakeholders.
- Work alongside developers, business analysts and end users to support testing activities and successful releases.
- Required Skills & Experience
- Proven experience delivering functional and database testing within financial services environments.
- Strong hands-on SQL skills, with the ability to independently investigate complex data issues.
- Experience testing relational databases, ideally Oracle or SQL Server.
- A solid understanding of data reconciliation, validation and testing across interconnected systems.
- Knowledge of financial products, transactions or processes within banking, investments, asset management, trading, risk or compliance.
- Experience working within structured testing lifecycles, including Agile delivery environments.
- Familiarity with defect tracking and test management tools such as Jira or Azure Dev Ops.
- Advantageous Experience
- Testing ETL processes, data warehouses or large-scale data migrations.
- Experience validating stored procedures and complex data transformations.
- API testing or exposure to test automation frameworks.
- Disclaimer
Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business.
Square One embraces diversity and will treat everyone equally.
Please see our website for our full diversity statement.
Senior SQL Test Analyst employer: Squareone
At Square One, we pride ourselves on being an excellent employer, offering a dynamic work culture that fosters innovation and collaboration. Our London-based team enjoys flexible hybrid working arrangements, competitive compensation, and ample opportunities for professional growth in the rapidly evolving field of finance transformation. Join us to make a meaningful impact while advancing your career in a supportive and diverse environment.
StudySmarter Expert Advice🤫
We think this is how you could land Senior SQL Test Analyst
✨Join Financial Networking Events
Jump into local finance meetups and conferences — they’re a goldmine for temporary roles in banking and financial services. You can chat with industry professionals and even get leads on upcoming opportunities that might not be posted online yet.
✨Utilise Temp Agencies Specialised in Finance
Reach out to temp agencies that focus on the banking sector. They often have strong ties with various firms and can help you secure short-term gigs that can help beef up your CV and get your foot in the door at firms like Squareone.
✨Connect with Alumni from Your Uni
Don't underestimate the power of your university’s alumni network. Many former students are working in banking and can help you find temporary roles or even offer mentorship. Reach out directly or attend alumni events to broaden your circle.
✨Stay Active on Job Boards and Company Websites
Keep your eyes peeled on job boards specifically for finance roles. Companies like Squareone might post temporary positions directly on their sites, so make sure to apply there too. Set alerts to catch those roles the moment they go live!
We think you need these skills to ace Senior SQL Test Analyst
Some tips for your application 🫡
Show Off Your Academic Achievements:In banking and financial services, your academic record can really make you stand out. List relevant grades, certifications, or coursework on your CV, especially if you've taken finance-related modules. This is particularly important for a temporary role where qualifications can help you shine even brighter!
Highlight Relevant Experience:If you’ve done any internships, part-time roles, or even coursework that aligns with banking or finance, make sure you include those! Showcase specific tasks where you used quantitative skills or analytical thinking, as this is what the hiring managers at Squareone will be keen to see in your application.
Tailor Your Cover Letter Purposefully:When writing your cover letter, focus on why you’re interested in a temporary position at Squareone. Let them know how you can quickly adapt to the team's needs and how eager you are to learn the ropes of the banking sector during this short stint. Your motivation and enthusiasm could really set you apart!
Be Prepared with References:For temporary roles, references can play a crucial role in your application. Make sure you’ve got a couple of references lined up who can vouch for your skills and work ethic. This helps to give Squareone confidence in your short-term commitment to the role.
How to prepare for a job interview at Squareone
✨Brush Up on Financial Regulations
Since this is a role in banking and financial services, be ready to discuss key regulations like MiFID, Basel III, or GDPR. These are hot topics, and your awareness of how they impact daily operations can give you a significant edge during your interview with Squareone.
✨Showcase Your Analytical Skills
Prepare for interview questions that assess your analytical abilities. You might need to tackle hypothetical scenarios involving risk assessment or financial forecasting. Bringing examples of relevant projects or coursework can emphasise your practical understanding of these concepts.
✨Highlight Flexibility and Adaptability
For a temporary role, showing that you can quickly pick up new processes and tools is crucial. Be ready to discuss previous experiences where you had to adapt to changing requirements or tight deadlines, as this will reassure Squareone that you’re a reliable team player.
✨Demonstrate a Willingness to Learn
In a temporary position, leaning into your eagerness to learn can really set you apart. Be prepared to share how you’re staying updated on industry trends or any additional training you've pursued. Employers appreciate candidates who are proactive about their development—even for short-term roles.