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 stability.
- Benefits: Competitive salary, potential for remote work, and opportunities for professional growth.
- Why this job: Be part of a dynamic team, enhance your skills, and make a real impact.
- Qualifications: Degree level qualified with 5 years of SQL Server and SSIS experience.
- Other info: 12-month FTC position; office presence required at least 3 days a week.
The predicted salary is between 44000 - 56000 £ 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 analyze errors and anomalies within the 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 minimize 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.
Data Engineer with SSIS and SSAS employer: Onyx-Conseil
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
Make sure to highlight your experience with SSIS and SQL Server during any networking opportunities. Attend industry meetups or webinars where you can connect with professionals in the banking sector, as they might have insights or referrals for the position.
✨Tip Number 2
Familiarise yourself with the specific regulatory requirements and compliance policies relevant to the banking industry. This knowledge will not only help you in interviews but also demonstrate your commitment to understanding the environment you'll be working in.
✨Tip Number 3
Prepare to discuss your previous projects involving data warehousing and SSIS in detail. Be ready to explain the challenges you faced, how you overcame them, and the impact of your work on the organisation's processes.
✨Tip Number 4
Engage with current employees of the bank on platforms like LinkedIn. Ask them about their experiences and any tips they might have for someone looking to join their team. This could give you valuable insights and potentially a referral.
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 developed systems, automated processes, or worked with data flows in SSIS packages.
Craft a Strong Cover Letter: In your cover letter, emphasise your 5+ years of experience and how it aligns with the responsibilities outlined in the job description. Mention your familiarity with regulatory requirements and your ability to liaise with finance departments.
Showcase Technical Skills: Clearly list your technical skills related to SQL programming, data warehouse design concepts, and any experience with reporting using SSRS. This will demonstrate your fit for the role and your understanding of the required technologies.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any errors or typos. A polished application reflects attention to detail, which is crucial for a Data Engineer role.
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 in detail. Share specific projects where you've successfully implemented SSIS packages and how they improved processes.
✨Demonstrate SQL Proficiency
Highlight your SQL programming skills by discussing complex queries you've written or optimised. Be ready to solve a SQL problem during the interview to showcase your technical abilities.
✨Understand the Business Context
Research the bank's operations and how data engineering supports their goals. Being able to relate your technical skills to their business needs will show that you understand the bigger picture.
✨Prepare for Regulatory Questions
Familiarise yourself with banking regulations and compliance policies. Be ready to discuss how you've ensured compliance in past roles and how you would approach risk management in this position.
