Database Engineer with SQL Server and SSIS
Database Engineer with SQL Server and SSIS

Database Engineer with SQL Server and SSIS

London Full-Time 39600 - 58800 £ / year (est.) Home office (partial)
Go Premium
O

At a Glance

  • Tasks: Develop and deliver systems to automate processes across departments.
  • Company: Join a leading bank in Central London, known for innovation and excellence.
  • Benefits: Enjoy a competitive salary, with opportunities for growth and learning.
  • Why this job: Be part of a dynamic team, making a real impact on financial processes.
  • Qualifications: Degree level qualified with strong SQL and SSIS experience required.
  • Other info: This is a 12-month FTC position, requiring office presence at least 3 days a week.

The predicted salary is between 39600 - 58800 £ per year.

Job Description Database Engineer with SQL Server and SSIS Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. 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. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language. Data warehouse design concepts, (Inmon or Kimball) Must have solid experience of working with SSIS and building data warehouses and some knowledge of reporting using SSRS. The Client is a Bank based in the Central London. This is a 12 month FTC position with a salary of circa £55K – £70K. You will be required to be in the office at least 3 days week. Do send your CV to us in Word format along with your salary and availability. #J-18808-Ljbffr

Database Engineer with SQL Server and SSIS employer: Onyx-Conseil

As a leading bank located in the heart of Central London, we pride ourselves on fostering a dynamic and inclusive work culture that prioritises employee growth and development. Our commitment to innovation and excellence provides Database Engineers with unique opportunities to engage in meaningful projects that streamline processes and enhance operational efficiency. With competitive salaries and a supportive environment, we empower our team members to thrive both professionally and personally.
O

Contact Detail:

Onyx-Conseil Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Database Engineer with SQL Server and SSIS

✨Tip Number 1

Familiarise yourself with the specific technologies mentioned in the job description, particularly SQL Server and SSIS. Consider building a small project or contributing to an open-source project that showcases your skills in these areas, as practical experience can set you apart.

✨Tip Number 2

Network with professionals in the banking and finance sector, especially those who work with database engineering. Attend industry meetups or webinars to connect with potential colleagues and learn more about the challenges they face, which can help you tailor your approach during interviews.

✨Tip Number 3

Stay updated on the latest trends and regulatory requirements in the banking sector. Understanding compliance and risk management will not only enhance your knowledge but also demonstrate your commitment to the role during discussions with the hiring team.

✨Tip Number 4

Prepare for technical interviews by practising common SQL queries and SSIS package development scenarios. Being able to demonstrate your problem-solving skills and technical expertise in real-time will significantly boost your chances of landing the job.

We think you need these skills to ace Database Engineer with SQL Server and SSIS

SQL Programming
SSIS Development
Data Warehouse Design (Inmon or Kimball)
Software Analysis and Design
SQL Query Language
Data Flow Construction
Debugging and Error Analysis
Financial Data Management
Hyperion System Support
Regulatory Compliance Knowledge
Risk Management
Communication Skills
Problem-Solving Skills
Attention to Detail

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience with SQL Server, SSIS, and any relevant database engineering projects. Use specific examples that demonstrate your skills in software analysis, design, and data warehouse concepts.

Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the role and the bank's mission. Mention your understanding of the responsibilities, such as supporting budgeting processes and liaising with the Finance department, and how your background makes you a great fit.

Showcase Relevant Skills: Emphasise your knowledge of regulatory requirements and risk management in your application. Highlight any experience you have in maintaining compliance and executing controls to minimise risks, as this is crucial for the role.

Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your attention to detail, which is essential for a Database Engineer.

How to prepare for a job interview at Onyx-Conseil

✨Showcase Your SQL Skills

Be prepared to discuss your experience with SQL programming in detail. Bring examples of complex queries you've written or optimised, and be ready to explain your thought process behind them.

✨Demonstrate SSIS Proficiency

Since the role requires solid experience with SSIS, be ready to talk about specific SSIS packages you've built. Discuss the challenges you faced and how you overcame them, as well as any data flows you've created.

✨Understand the Banking Environment

Familiarise yourself with the banking sector's regulatory requirements and compliance policies. Showing that you understand these aspects will demonstrate your ability to minimise risk and adhere to necessary protocols.

✨Prepare for Technical Questions

Expect technical questions related to database support and troubleshooting. Brush up on common issues that arise in Hyperion systems and be ready to discuss how you would debug and resolve them.

Database Engineer with SQL Server and SSIS
Onyx-Conseil
Location: London
Go Premium

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

O
  • Database Engineer with SQL Server and SSIS

    London
    Full-Time
    39600 - 58800 £ / year (est.)
  • O

    Onyx-Conseil

    50-100
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>