At a Glance
- Tasks: Join an international bank as a SQL Server Developer, leading database design and development.
- Company: Dynamic international bank with a focus on Wealth and Asset Management.
- Benefits: Competitive salary, career growth, and opportunities to work with cutting-edge technologies.
- Other info: Collaborative environment with opportunities for professional development.
- Why this job: Make a real impact in banking by solving critical issues and enhancing systems.
- Qualifications: Experience with SQL Server, Power BI, and strong analytical skills required.
The predicted salary is between 50000 - 70000 £ per year.
Excellent opportunity opens to join an International Bank as their new SQL Server Developer. As part of a lean IT function, you will play a pivotal role in supporting the bank's Wealth and Asset Management division. You will lead break-fix implementation and take ownership of database design and development.
Key Responsibilities
- The SQL developer will support the Wealth and Asset Management division’s multiple programs and systems including third-party applications and in-house developed systems.
- The role involves working closely with business analysts, the infrastructure team and the business in understanding critical issues, and in implementing robust and timely break-fixes.
- When needed they should be adept in gathering solution requirements, formulating technical designs and in implementing that design in an iterative development environment.
- The position will focus on the Microsoft technologies the successful candidate will be expected to ‘pitch-in’ in helping progress other development requirements.
Experience/Qualifications
- Previous experience designing and developing databases, tables, views, stored procedures, user defined functions, SSIS packages, and other database objects using SQL Server 2019 and above.
- Experience in Data Extraction, Transforming and Loading (ETL) using Microsoft SQL Server tools and utilities, creating SSIS master and child packages, package configurations, logging and in using variables and expressions in packages.
- Worked with tabular reports, matrix reports, parameterized reports using SSRS and Power BI.
- Experience in Transact SQL / Common Runtime Language (CLR) with good software methodology/practices, using Visual Studio suite.
- Awareness of developing in ASP.NET, C#, web services and JavaScript, with reference to how these can interface with databases.
- Experience with concurrent development source control and continuous integration – GIT, AZDO.
- Experience working in both waterfall and Agile development environments.
- Experience with MS D365 CRM customisation or MS SharePoint development would be beneficial.
- Experience developing / deploying Azure SQL solutions using Azure Data Factory and other Azure services would be beneficial.
- Demonstrating strong analytical and critical thinking skills.
- Experience working with data modeling and design tools.
Interested? Please Apply!
SQL Server Developer - Power BI - Banking in London employer: Rothstein Recruitment
Join an esteemed International Bank as a SQL Server Developer and immerse yourself in a dynamic work culture that prioritises innovation and collaboration. With a focus on employee growth, the bank offers extensive training opportunities and a supportive environment where your contributions directly impact the Wealth and Asset Management division. Located in a vibrant financial hub, this role not only provides competitive benefits but also the chance to work with cutting-edge technologies in a forward-thinking team.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Server Developer - Power BI - Banking in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the banking and tech sectors. Attend meetups or webinars related to SQL Server and Power BI. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL projects, especially those involving Power BI and Azure. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common SQL scenarios and problem-solving questions. Practice explaining your thought process clearly, as communication is key when working with teams in a banking environment.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might just be the perfect fit for you. Plus, it’s a great way to get noticed by our hiring team directly!
We think you need these skills to ace SQL Server Developer - Power BI - Banking in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the SQL Server Developer role. Highlight your experience with SQL Server 2019, ETL processes, and Power BI. We want to see how your skills match what we're looking for!
Showcase Your Projects:Include specific projects where you've designed databases or developed SSIS packages. We love seeing real examples of your work, so don’t hold back on the details!
Be Clear and Concise:When writing your cover letter, keep it clear and to the point. Explain why you're a great fit for the Wealth and Asset Management division and how you can contribute to our team at the bank.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and we can’t wait to see your application come through!
How to prepare for a job interview at Rothstein Recruitment
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills, especially with SQL Server 2019 and above. Be prepared to discuss your experience with designing databases, writing stored procedures, and using SSIS for ETL processes. Practising common SQL queries and scenarios can really help you shine during technical questions.
✨Familiarise Yourself with Power BI
Since the role involves working with Power BI, take some time to explore its features. Understand how to create tabular and matrix reports, and be ready to discuss any projects where you've used Power BI. Showing that you can translate data into insightful reports will impress the interviewers.
✨Understand the Banking Sector
Get a grasp of the banking industry, particularly in Wealth and Asset Management. Research current trends and challenges in the sector. This knowledge will not only help you answer questions more effectively but also demonstrate your genuine interest in the role and the company.
✨Prepare for Team Dynamics
This position requires collaboration with business analysts and infrastructure teams. Think of examples from your past experiences where you successfully worked in a team, especially in Agile or waterfall environments. Being able to articulate your teamwork skills will show that you're a good fit for their lean IT function.
