At a Glance
- Tasks: Develop and deliver data pipelines, automate processes, and enhance existing codes.
- Company: A leading bank in Central London with a focus on innovation.
- Benefits: Competitive salary, professional development, and a collaborative work environment.
- Other info: Office-based role for 3 days a week with excellent career growth opportunities.
- Why this job: Join a dynamic team and make a real impact in the banking sector.
- Qualifications: 5-7 years of SQL Server experience with SSIS and SSRS proficiency.
The predicted salary is between 60000 - 75000 £ per year.
Our Client is a bank based in Central London – who are looking to recruit a Database Engineer with at least 5 to 7 years solid expertise of working with SQL Server, SSIS and SSRS.
Responsibilities include:
- Development and delivery of pipelines to automate and streamline processes required by different departments.
- Support existing SSIS ETLs (overnight and intraday), proactively fine-tune and enhance existing codes to increase robustness and error monitoring.
- Support the internal IT department with changes and upgrades to software platforms.
- Convert legacy Hyperion reports to SSRS.
- Analyse issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation end of day cycle.
- Understand business requirements to develop and deliver appropriate solutions based on system definition documents.
- Build data pipelines within the SQL environment in SSIS packages and introduce new fields and data types for new information to be collated in the CORE environment.
- Build tabular models (SSAS) for different business units.
- Build reports based on business requirements using SQL SSRS.
- Integrate with all the Bank’s sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net.
- Ensure that the environment is running optimally and with high standard housekeeping procedures.
- Integrate the SharePoint environment and Forms with the Equation system to introduce automation of processes thereby eliminating the need for duplicate entry.
- Utilise web services to integrate from cutting edge technology into legacy systems such as Equation.
- Provide second and third level support for in-house programmes during the end of day cycle.
- Analyse and rectify any problems raised in an independent and team scenario.
- Take ownership of a problem and deliver a solution in a timely manner.
- Provide out of office hours support.
- Maintain knowledge of all applicable regulatory requirements including the Bank’s Risk and Compliance policies and procedures.
- Report policy/procedure breaches and areas of potential non-compliance promptly upon identification.
- Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches.
- Identify new risks/control gaps within own area and escalate accordingly.
- Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines.
- Proactively seek to complete recommended technical and behavioural competencies training required for your role.
- Act in accordance with the FCA/PRA Code of Conduct.
- Fulfil all prescribed business continuity requirements as set out in the organisational or departmental specific plans.
Qualifications/Experience:
- Degree level qualified or equivalent.
- MS SQL stack (SSIS, SSAS, SSRS) to high level of proficiency - Essential.
- C# Programming / JavaScript programming - Desirable.
- Software analysis and design good practice.
- Dimensional modelling, Entity Relationship modelling, Normalised modelling.
- Data warehouse design concepts, (Inmon, Kimball).
The position is based in Central London and you will be required to be in the office for 3 days a week. Please note the Client does NOT provide sponsorship. The salary for this position is in the range £60K – £75K. Please do send your CV to us in Word format along with your salary and availability.
SQL Server Developer with SSIS and SSRS employer: Onyx-Conseil
Our client, a prominent bank located in the heart of Central London, offers an exceptional work environment that fosters innovation and professional growth. With a strong emphasis on employee development, the bank provides comprehensive training opportunities and encourages collaboration across departments, ensuring that every team member can contribute meaningfully to impactful projects. The vibrant city location not only enhances work-life balance but also allows employees to enjoy a dynamic urban lifestyle, making it an attractive place for talented individuals seeking a rewarding career in the financial sector.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Server Developer with SSIS and SSRS
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at banks or in similar roles. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Prepare a portfolio or a GitHub repository showcasing your SQL Server projects, SSIS packages, and any reports you've built with SSRS. This gives potential employers a taste of what you can do beyond just a CV.
✨Tip Number 3
Ace the interview by practising common technical questions related to SQL Server, SSIS, and SSRS. We recommend doing mock interviews with friends or using online platforms to get comfortable with the format.
✨Tip Number 4
Apply through our website! It’s super easy and ensures your application gets seen by the right people. Plus, we love seeing candidates who take the initiative to apply directly!
We think you need these skills to ace SQL Server Developer with SSIS and SSRS
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with SQL Server, SSIS, and SSRS. We want to see how your skills match the job description, so don’t be shy about showcasing relevant projects or achievements!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this role. Mention specific experiences that relate to the responsibilities listed in the job description.
Showcase Problem-Solving Skills:Since the role involves troubleshooting and enhancing existing systems, include examples of how you've tackled similar challenges in the past. We love seeing candidates who take ownership of problems and deliver solutions!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you’re serious about joining our team!
How to prepare for a job interview at Onyx-Conseil
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with SQL Server, SSIS, and SSRS in detail. Think of specific projects where you’ve developed pipelines or enhanced existing ETLs, as these will be key talking points.
✨Showcase Problem-Solving Skills
The role requires a lot of troubleshooting, so be ready to share examples of how you've tackled issues in past projects. Highlight your ability to analyse problems and deliver timely solutions, especially during critical processes like the end of day cycle.
✨Understand the Business Context
Familiarise yourself with the banking sector and the specific challenges it faces regarding data management. Being able to relate your technical skills to business requirements will show that you understand the bigger picture and can deliver appropriate solutions.
✨Prepare for Technical Questions
Expect some technical questions or even a practical test during the interview. Brush up on advanced 4GL programming languages and be ready to discuss dimensional modelling and data warehouse design concepts. This will demonstrate your proficiency and readiness for the role.
