Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a Database Engineer, automating processes and supporting our IT department.
- Company: We're a leading bank in Central London, committed to innovation and excellence.
- Benefits: Enjoy a competitive salary, office perks, and the chance to work with cutting-edge technology.
- Why this job: Make an impact by streamlining operations and collaborating with finance for smooth system functionality.
- Qualifications: You need a degree and 5 years of experience with SQL Server and SSIS.
- Other info: This is a 12-month fixed-term contract, requiring office presence at least 3 days a week.
The predicted salary is between 46200 - 84000 £ 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 pinpoint areas of failure to 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.
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.
Contact Detail:
Onyx-Conseil Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer with SSIS and SSAS
✨Tip Number 1
Familiarise yourself with the specific tools and technologies mentioned in the job description, particularly SSIS and SQL Server. Consider building a small project or contributing to an open-source project that showcases your skills in these areas.
✨Tip Number 2
Network with professionals in the banking and finance sector, especially those who work with data engineering. Attend relevant meetups or webinars to connect with potential colleagues and learn more about the industry’s expectations.
✨Tip Number 3
Prepare for technical interviews by practising common data engineering problems and scenarios related to SSIS and SQL Server. Use platforms like LeetCode or HackerRank to sharpen your problem-solving skills.
✨Tip Number 4
Research the bank's culture and values to tailor your approach during interviews. Understanding their risk and compliance policies will help you demonstrate your alignment with their operational standards.
We think you need these skills to ace Data Engineer with SSIS and SSAS
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with MS SQL Server and SSIS specifically. Include relevant projects or roles where you've developed systems or automated processes, as these are key aspects of the job.
Craft a Strong Cover Letter: In your cover letter, emphasise your 5+ years of experience in database engineering and your familiarity with financial planning processes. Mention your ability to liaise with different departments, particularly Finance, to showcase your collaborative skills.
Showcase Technical Skills: Clearly list your technical skills related to SQL programming, data warehouse design concepts, and any experience with SSRS. This will help demonstrate that you meet the qualifications and can handle the responsibilities outlined in the job description.
Follow Application Instructions: Ensure you send your CV in Word format as specified in the job posting. Don't forget to include your salary expectations and availability to make your application complete and compliant with their requirements.
How to prepare for a job interview at Onyx-Conseil
✨Showcase Your SSIS Expertise
Since SSIS is crucial for this role, be prepared to discuss your experience with it in detail. Highlight specific projects where you've used SSIS to automate processes or build data flows, and be ready to explain the challenges you faced and how you overcame them.
✨Demonstrate SQL Proficiency
With a strong emphasis on SQL Server, ensure you can confidently discuss your SQL programming skills. Prepare to answer technical questions or even solve problems on the spot, showcasing your ability to write complex queries and understand data warehouse design concepts.
✨Understand the Banking Environment
Familiarise yourself with the banking sector's regulatory requirements and compliance policies. Being able to discuss how you would handle risk and compliance issues in your role will demonstrate your understanding of the industry's unique challenges.
✨Prepare for Technical Questions
Expect to face technical questions related to database support and troubleshooting. Brush up on common errors and anomalies that can occur within systems like Hyperion, and be ready to explain how you would debug and resolve these issues effectively.
