At a Glance
- Tasks: Develop and streamline database systems using SQL Server, SSIS, and C#.
- Company: Join a leading bank in Central London with a focus on innovation.
- Benefits: Competitive salary, professional growth, and a dynamic work environment.
- Other info: 12-month FTC with opportunities for career advancement.
- Why this job: Make an impact by automating processes and supporting financial planning.
- Qualifications: 5+ years of experience with SQL Server, SSIS, and strong analytical skills.
The predicted salary is between 55000 - 70000 € per year.
Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. You must have solid expertise of at least 5 years experience of working with MS SQL Server and SSIS – SSIS is very important for this position.
Responsibilities include:
- Development and delivery of new systems to automate and streamline processes required by different departments.
- Support the internal IT department with changes and upgrades to software platforms.
- Be the primary contact for all technical questions relating to in-house bespoke systems and interfacing.
- Support budgeting and financial planning processes for the 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 the Hyperion system as raised by Finance 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.
- Report policy/procedure breaches and areas of potential non-compliance promptly upon identification.
- 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 elevate accordingly to your Line Manager and/or Head of Department.
Qualifications/Experience:
- Degree level qualified or equivalent.
- SQL Programming.
- Software analysis and design.
- SQL query language with SSIS, SSRS and SSAS.
- Data warehouse design concepts (Inmon or Kimball).
- Experience of developing with C# .net and asp.net would be very useful.
- Must have solid experience of working with SSIS and building data warehouses and some knowledge of reporting using SSRS.
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 a week.
Database Engineer with SQL Server SSIS, SSRS and C# .net asp.net employer: Onyx-Conseil
Our client, a prominent bank located in the heart of Central London, offers an exceptional work environment that fosters innovation and collaboration. With a strong emphasis on employee growth, the bank provides numerous opportunities for professional development and training, ensuring that you can advance your career while contributing to meaningful projects. The vibrant culture and commitment to compliance and risk management make this an ideal workplace for those seeking a rewarding role in the financial sector.
StudySmarter Expert Advice🤫
We think this is how you could land Database Engineer with SQL Server SSIS, SSRS and C# .net asp.net
✨Tip Number 1
Network like a pro! Reach out to your connections in the banking and tech sectors. Attend meetups or webinars related to database engineering, and don’t be shy about introducing yourself. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your projects with SQL Server, SSIS, and C#. This could be a GitHub repository or a personal website. When you get that interview, you can wow them with real examples of your work.
✨Tip Number 3
Prepare for technical interviews by brushing up on your SQL queries and SSIS packages. Practice common database problems and scenarios you might face in the role. We recommend using online platforms to simulate coding challenges and get comfortable with the tech side.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take the initiative to connect directly with us. Let’s get you that Database Engineer role!
We think you need these skills to ace Database Engineer with SQL Server SSIS, SSRS and C# .net asp.net
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with SQL Server, SSIS, and any relevant projects you've worked on. We want to see how your skills match the job description, so don’t hold back on showcasing your expertise!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for the Database Engineer role. Mention specific experiences that relate to the responsibilities listed in the job description, especially around automation and support.
Showcase Your Problem-Solving Skills:In your application, highlight instances where you've debugged issues or improved processes. We love candidates who can demonstrate their analytical skills, especially when it comes to handling data flows and resolving anomalies.
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to receive your CV and cover letter. Plus, it ensures you’re considered for the role as quickly as possible. We can’t wait to hear from you!
How to prepare for a job interview at Onyx-Conseil
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with MS SQL Server, SSIS, and how you've used them in past projects. They’ll likely ask you to solve a problem or explain a complex query, so practice makes perfect!
✨Showcase Your SSIS Expertise
Since SSIS is crucial for this role, be ready to talk about specific SSIS packages you've built. Highlight any challenges you faced and how you overcame them. If you can, bring examples of your work or describe a project where you automated processes using SSIS.
✨Understand the Business Context
This position involves liaising with the Finance department, so it’s important to understand their needs. Research how database engineering supports budgeting and financial planning. Being able to speak their language will show that you’re not just technically savvy but also business-minded.
✨Prepare for Technical Questions
Expect technical questions related to C# .net and asp.net, even if they’re not the main focus. Brush up on your knowledge of data warehouse design concepts like Inmon or Kimball. This will demonstrate your well-rounded skill set and readiness to tackle various challenges in the role.
