Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and deliver systems to automate processes and support IT changes.
- Company: Join a leading bank in Central London, known for innovation and excellence.
- Benefits: Enjoy a competitive salary, office perks, and a collaborative work environment.
- Why this job: Be part of a dynamic team, enhancing your skills in SQL and data management.
- Qualifications: Degree level qualified with solid experience in SQL Server, SSIS, SSRS, and SSAS.
- Other info: This is a 12-month FTC position; hybrid work model with office presence required.
The predicted salary is between 46200 - 58800 £ 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:
- Responsible for the 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 pinpoint areas of failure to correct any issues.
- Liaise with Finance daily 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 with SSIS, SSRS, and SSAS.
- 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.
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. Do send your CV to us in Word format along with your salary and availability.
Database Engineer with SQL Server SSIS, SSRS and SSAS 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 SSIS, SSRS and SSAS
✨Tip Number 1
Make sure to brush up on your SSIS skills, as this is a crucial requirement for the role. Consider working on personal projects or contributing to open-source projects that involve SSIS to showcase your expertise.
✨Tip Number 2
Network with professionals in the banking and finance sector, especially those who work with SQL Server technologies. 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 warehousing and reporting, particularly focusing on Inmon and Kimball methodologies. This knowledge will not only help you in interviews but also demonstrate your commitment to staying current in the field.
✨Tip Number 4
Prepare to discuss real-world scenarios where you've successfully debugged and resolved issues within SQL environments. Having concrete examples ready will help you stand out during the interview process.
We think you need these skills to ace Database Engineer with SQL Server SSIS, SSRS and SSAS
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL Server, SSIS, SSRS, and SSAS. Use specific examples from your past roles that demonstrate your expertise in these areas, especially focusing on your 5+ years of relevant experience.
Craft a Strong Cover Letter: Write a cover letter that addresses the key responsibilities mentioned in the job description. Explain how your skills and experiences align with the needs of the bank, particularly your ability to automate processes and support IT changes.
Showcase Relevant Projects: If you have worked on specific projects involving data warehousing or financial systems, be sure to mention these in your application. Highlight your role in building data flows and debugging systems, as these are crucial for the position.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any errors or typos. A polished application reflects your attention to detail, which is essential for a Database Engineer role.
How to prepare for a job interview at Onyx-Conseil
✨Showcase Your SQL Expertise
Make sure to highlight your experience with MS SQL Server, especially your proficiency in SSIS, SSRS, and SSAS. Prepare specific examples of projects where you've successfully implemented these technologies, as this will demonstrate your hands-on skills.
✨Understand the Bank's Environment
Research the bank's operations and their specific needs regarding database management. Familiarise yourself with their risk and compliance policies, as understanding these will show that you are proactive and ready to contribute to their regulatory duties.
✨Prepare for Technical Questions
Expect technical questions related to database design, data flows, and error debugging. Brush up on common issues faced in Hyperion systems and be ready to discuss how you would approach troubleshooting and resolving these problems.
✨Demonstrate Communication Skills
Since you'll be liaising with various departments, it's crucial to showcase your communication skills. Be prepared to discuss how you've effectively collaborated with finance teams or other departments in past roles to ensure smooth operations.
