At a Glance
- Tasks: Develop and deliver data pipelines, automate processes, and enhance existing systems.
- Company: A leading bank in Central London with a focus on innovation.
- Benefits: Competitive salary, professional development, and a dynamic work environment.
- Other info: Office-based role for 3 days a week with excellent career growth opportunities.
- Why this job: Join a team that values your skills and offers real impact in the banking sector.
- Qualifications: 5-7 years of SQL Server experience; proficiency in SSIS and SSRS is essential.
The predicted salary is between 60000 - 75000 £ per year.
Our Client is a bank based in Central London – looking to recruit a Database Engineer with at least 5 to 7 years of experience working with SQL Server, SSIS and SSRS.
Responsibilities
- 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 code 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
- Analyse issues pertaining to problems or errors raised by in‑house systems, e.g. CORE, SharePoint interface, Equation end‑of‑day cycle.
- Understand business requirements in order to develop and deliver appropriate solutions based on system definition documents.
- Proficiency in advanced 4GL programming languages and ability to apply them throughout the development life‑cycle.
Database Support
- Build data pipelines within the SQL environment in SSIS packages, introducing 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.
SharePoint Integration
- Integrate the SharePoint environment and Forms with Equation system to introduce automation of processes, thereby eliminating the need for duplicate entry.
- Utilise web services to integrate cutting‑edge technology into legacy systems such as Equation.
End Of Day Cycle
- 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.
Risk & Regulatory Duties
- Maintain knowledge of all applicable regulatory requirements including the bank’s Risk and Compliance policies and procedures, and adhere to them to avoid exposing the bank to undue risk.
- Report policy/procedure breaches and areas of potential non‑compliance 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 qualification or equivalent.
- MS SQL stack (SSIS, SSAS, SSRS) to a 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 London and you will be required to be in the office for 3 days a week. Salary: £60K – £75K. Client does NOT provide sponsorship.
SQL Server Developer with SSIS and SSRS employer: Free-Work UK
As a leading bank located in the heart of Central London, we pride ourselves on fostering a dynamic and inclusive work environment that encourages innovation and professional growth. Our commitment to employee development is reflected in our comprehensive training programmes and supportive culture, ensuring that every team member has the opportunity to excel in their role while contributing to meaningful projects that drive the bank's success. With competitive salaries and a focus on work-life balance, we offer an attractive workplace for those looking to make a significant impact 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 have experience with SQL Server. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL Server projects, especially any SSIS and SSRS work. This gives potential employers a taste of what you can do and sets 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 this will demonstrate your analytical skills and how you tackle challenges.
✨Tip Number 4
Don't forget to apply through our website! We make it easy for you to find roles that match your skills. Plus, it shows you're serious about joining our team and helps us keep track of your application.
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 analysing and rectifying issues, include examples of how you've tackled similar challenges in the past. We love seeing candidates who 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 don’t miss out on any important updates from us!
How to prepare for a job interview at Free-Work UK
✨Know Your SQL Inside Out
Make sure you brush up on your SQL Server skills before the interview. Be prepared to discuss your experience with SSIS and SSRS in detail, as well as any specific projects you've worked on that involved data pipelines or report generation.
✨Showcase Problem-Solving Skills
Since the role involves analysing issues and providing solutions, think of examples where you've successfully tackled problems in previous roles. Be ready to explain your thought process and how you approached these challenges.
✨Understand the Business Context
Familiarise yourself with the banking sector and the specific challenges it faces regarding data management. This will help you demonstrate how your skills can directly benefit the company and its operations.
✨Prepare for Technical Questions
Expect technical questions related to SQL, SSIS, and SSRS during the interview. Practise coding challenges or scenarios that might come up, and be ready to explain your reasoning and approach to potential solutions.
