Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and deliver data pipelines, support existing ETLs, and enhance software platforms.
- Company: Join Free-Work UK, a dynamic bank in Central London, focused on innovation and technology.
- Benefits: Enjoy competitive pay, opportunities for growth, and a collaborative work environment.
- Why this job: Be part of a tech-driven team making impactful changes in banking processes.
- Qualifications: 5-7 years of SQL Server experience; proficiency in SSIS, SSRS, and advanced programming languages.
- Other info: Office-based role with 3 days in the office; no sponsorship provided.
The predicted salary is between 52000 - 65000 £ 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 solid expertise in SQL Server, SSIS, and SSRS.
Responsibilities:
- Development and delivery of pipelines to automate and streamline processes required by different departments.
- Support existing SSIS ETLs, 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.
- Understand business requirements to develop and deliver appropriate solutions based on system definition documents.
- Build data pipelines within the SQL environment in SSIS packages.
- 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.
- Ensure that the environment is running optimally with high standard housekeeping procedures.
- Integrate the SharePoint environment and Forms with the Equation system to introduce automation of processes.
- Provide second and third level support for in-house programmes during the end of day cycle.
- Take ownership of a problem and deliver a solution in a timely manner.
- Maintain knowledge of all applicable regulatory requirements including the Bank's Risk and Compliance policies.
- Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines.
Qualifications/Experience:
- Degree level qualified 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. 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.
SQL Server Database Engineer with SSIS employer: Free-Work UK
Contact Detail:
Free-Work UK Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Server Database Engineer with SSIS
✨Tip Number 1
Make sure to brush up on your SQL Server skills, especially SSIS and SSRS, as these are crucial for the role. Consider working on personal projects or contributing to open-source projects that involve these technologies to showcase your expertise.
✨Tip Number 2
Network with professionals in the banking and finance sector, particularly those who work with data engineering. Attend industry meetups or webinars to connect with potential colleagues and learn more about the specific challenges they face.
✨Tip Number 3
Familiarise yourself with the latest trends in data integration and automation, especially regarding SharePoint and legacy systems. Being knowledgeable about how to streamline processes can set you apart from other candidates.
✨Tip Number 4
Prepare to discuss real-world scenarios where you've successfully solved complex database issues or improved existing systems. Having concrete examples ready will demonstrate your problem-solving skills and technical proficiency during interviews.
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 experience with SQL Server, SSIS, and SSRS. Include specific projects or achievements that demonstrate your expertise in these areas, as well as any relevant programming skills like C# or JavaScript.
Craft a Strong Cover Letter: In your cover letter, explain why you are interested in the SQL Server Database Engineer role at Free-Work UK. Mention how your skills align with the job requirements and provide examples of how you've successfully handled similar responsibilities in the past.
Showcase Relevant Experience: When detailing your work history, focus on your experience with data pipelines, ETL processes, and report generation. Highlight any experience you have with SharePoint integration and risk compliance, as these are key aspects of the role.
Proofread Your Application: Before submitting your application, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a Database Engineer.
How to prepare for a job interview at Free-Work UK
✨Showcase Your SQL Expertise
Make sure to highlight your experience with SQL Server, SSIS, and SSRS during the interview. Be prepared to discuss specific projects where you've developed data pipelines or automated processes, as this will demonstrate your hands-on skills.
✨Understand the Business Context
Familiarise yourself with the banking sector and how data engineering supports various departments. Being able to relate your technical skills to business needs will show that you understand the bigger picture and can contribute effectively.
✨Prepare for Problem-Solving Questions
Expect questions that assess your analytical skills and ability to troubleshoot issues. Prepare examples of past challenges you've faced in database management or ETL processes, and explain how you resolved them.
✨Demonstrate Continuous Learning
Discuss any recent training or certifications you've completed, especially those related to SQL technologies or regulatory compliance. This shows your commitment to staying updated in a rapidly evolving field, which is crucial for a role in a bank.
