Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and deliver data pipelines, support ETLs, 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.
- Why this job: Join a dynamic team and make a real impact in the banking sector.
- Qualifications: 5-7 years of SQL Server experience, proficiency in SSIS, SSRS, and C# or JavaScript.
- Other info: Office-based role with excellent career growth opportunities.
The predicted salary is between 65000 - 75000 £ per year.
SQL Server Database Engineer with SSIS
Our Client is bank based in Central London – who are looking to recruit Database Engineer with at least 5 to 7 years sold expertise of working SQL Server SSIS and SSRS.
Responsible for the development and delivery of pipelines (collect, validate and prepare high quality data) 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.
Software Development:
Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation end of day cycle.
Understanding business requirements in order to develop and deliver appropriate solutions based on system definition documents.
Proficiency in advanced 4GL programming languages and able to apply to the fully development life-cycle.
Database Support
To build data pipelines within the SQL environment in SSIS packages, where required, introduce new field and data types for new information to be collated in the CORE environment.
To build tabular models (SSAS) for different business units.
To build reports based on business requirements using SQL SSRS.
To integrate with all the Banks sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net.
Ensure that the environment is running optimally and with high standard house-keeping procedures.
Sharepoint Integration:
To integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry.
To utilise web services to integrate from cutting edge technology into legacy systems such as Equation.
End of Day Cycle:
To provide second and third level support for in-house programmes during the end of day cycle.
To be able to analyse and rectify any problems raised in an independent and team scenario.
To take ownership of a problem and deliver a solution in a timely manner.
Provide out of office hours support.
Risk & Regulatory Duties
Maintain knowledge of all applicable regulatory requirements including the Bank’s Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk.
Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank\’s Risk and Compliance policies.
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 to your Line Manager and/or Head of Department.
Training & Competence
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 or as instructed by the Line Manager/Head of Department.
Qualifications/Experience
Degree level qualified or equivalent.
MS SQL stack (SSIS, SSAS, SSRS) to high level of proficiency – Essential
C# Programming / JavaScript programming – Desirable
Knowledge and Skills
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 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 £65K – £75K.
Please do send your CV to us in Word format along with your salary and availability.
#J-18808-Ljbffr
SQL Server Database Engineer with SSIS employer: Jas Gujral
Contact Detail:
Jas Gujral Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Server Database Engineer with SSIS
✨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
Prepare for interviews by brushing up on your SQL Server and SSIS skills. We recommend doing mock interviews with friends or using online platforms to practice common questions related to database engineering.
✨Tip Number 3
Showcase your projects! If you've worked on any relevant database projects, make sure to highlight them during interviews. We love seeing real-world applications of your skills, so be ready to discuss your contributions.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we often have exclusive listings that you won't find anywhere else.
We think you need these skills to ace SQL Server Database Engineer with SSIS
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL Server, SSIS, and SSRS experience. 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. We love seeing enthusiasm and a clear understanding of what we do at StudySmarter.
Showcase Problem-Solving Skills: Since the role involves troubleshooting and enhancing existing systems, share examples of how you've tackled similar challenges in the past. We appreciate candidates who can take ownership and deliver solutions!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Jas Gujral
✨Know Your SQL Inside Out
Make sure you brush up on your SQL Server skills, especially SSIS and SSRS. Be prepared to discuss your experience with data pipelines and how you've automated processes in the past. Having specific examples ready will show that you can hit the ground running.
✨Showcase Problem-Solving Skills
Since the role involves troubleshooting and enhancing existing systems, think of a few challenges you've faced in previous positions. Be ready to explain how you identified the issues and what steps you took to resolve them. This will demonstrate your analytical skills and ability to take ownership of problems.
✨Understand the Business Context
Familiarise yourself with the banking sector and the specific needs of the client. Understanding how your technical skills can support business requirements will set you apart. Research the bank's operations and think about how your work can contribute to their goals.
✨Prepare for Technical Questions
Expect to be asked technical questions related to SQL, ETL processes, and data modelling. Review key concepts and be ready to discuss your experience with dimensional modelling and data warehouse design. Practising common interview questions can help you feel more confident.
