At a Glance
- Tasks: Support budgeting and financial planning by managing data in SQL Server.
- Company: A leading bank in the heart of London with a strong focus on compliance.
- Benefits: Competitive salary, professional development, and a dynamic work environment.
- Other info: This is a 2-year fixed-term contract with excellent career growth potential.
- Why this job: Join a vital team ensuring smooth operations in finance with impactful responsibilities.
- Qualifications: Degree level qualified with SQL programming skills and knowledge of data warehousing.
The predicted salary is between 65000 - 70000 £ per year.
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).
The Client is a Bank based in the City of London. This is a 2 year FTC position with a salary of circa £65K - £70K.
Do send your CV to us in Word format along with your salary and availability.
Database Engineer with SQL Server in London employer: Onyx-Conseil
As a leading bank located in the heart of the City of London, we pride ourselves on fostering a dynamic work culture that prioritises employee growth and development. Our commitment to compliance and risk management ensures that you will be part of a team that values integrity and excellence, while our competitive salary and benefits package reflects our dedication to attracting top talent. Join us for a rewarding career where your contributions directly impact our financial planning processes and overall success.
StudySmarter Expert Advice🤫
We think this is how you could land Database Engineer with SQL Server in London
✨Tip Number 1
Network like a pro! Reach out to people in the finance and banking sectors, especially those who work with SQL Server. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! If you’ve got experience with SSIS packages or debugging in Hyperion, make sure to highlight these in conversations. We want to see you confidently discussing how you can tackle the challenges mentioned in the job description.
✨Tip Number 3
Prepare for interviews by brushing up on regulatory requirements and compliance policies. Being able to discuss how you can help the bank avoid risks will definitely set you apart from other candidates.
✨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.
We think you need these skills to ace Database Engineer with SQL Server in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Database Engineer role. Highlight your SQL programming skills and any relevant experience with data flows and financial systems. We want to see how your background fits with what we're looking for!
Showcase Your Problem-Solving Skills:In your application, don’t forget to mention specific examples where you've debugged or analysed errors in a system. We love seeing how you tackle challenges, especially in environments like Hyperion!
Be Clear and Concise:When writing your cover letter, keep it clear and to the point. We appreciate straightforward communication, so make sure you express your interest in the role and why you’d be a great fit without rambling on.
Apply Through Our Website:We encourage you to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the position. Don’t forget to include your salary expectations and availability!
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 SQL Server, including any specific projects you've worked on. Practising common SQL queries and understanding data warehouse design concepts will give you a solid foundation.
✨Understand the Hyperion System
Since the role involves debugging and analysing errors within the Hyperion system, it’s crucial to familiarise yourself with its functionalities. Research common issues that arise in Hyperion and think about how you would approach troubleshooting them. This will show your potential employer that you're proactive and knowledgeable.
✨Brush Up on Regulatory Knowledge
Given the importance of compliance in this role, make sure you understand the relevant regulatory requirements and the Bank's Risk and Compliance policies. Be ready to discuss how you would handle policy breaches or identify control gaps, as this demonstrates your awareness of risk management.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving skills. Think of examples from your past experiences where you successfully managed data flows or resolved issues in a database environment. Use the STAR method (Situation, Task, Action, Result) to structure your answers clearly.
