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
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
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.