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 data management.
- 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 employer: Onyx-Conseil
As a leading bank located in the heart of the City of London, we pride ourselves on fostering a dynamic and inclusive work culture that prioritises employee growth and development. Our commitment to excellence is reflected in our comprehensive benefits package, which includes competitive salaries, professional training opportunities, and a supportive environment that encourages innovation and collaboration. Join us as a Database Engineer and be part of a team that values your contributions while providing you with the tools to succeed in your career.
StudySmarter Expert Advice🤫
We think this is how you could land Database Engineer with SQL Server
✨Tip Number 1
Network like a pro! Reach out to people in the finance and banking sector, 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 how you can solve problems and add value to the team.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL programming and data warehouse design concepts. We recommend practising common interview questions related to database support and risk compliance to feel confident.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. 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
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:Keep your application clear and to the point. Use bullet points where possible to make it easy for us to read through your qualifications and experiences. We appreciate straightforward communication!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
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.
