At a Glance
- Tasks: Develop and deliver systems to automate processes and support IT changes.
- Company: Join a leading bank in the heart of London with a dynamic work culture.
- Benefits: Competitive salary, professional development, and opportunities for career growth.
- Other info: Enjoy a collaborative environment with excellent support and training opportunities.
- Why this job: Make a real impact by streamlining operations and enhancing financial processes.
- Qualifications: Degree level qualified with SQL and C# programming skills.
The predicted salary is between 65000 - 70000 £ per year.
Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. 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.
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.
- Introduce new field and data types for new information to be collated in the CORE environment.
- Integrate with all the Bank’s sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net.
- Build reports based on business requirements using Hyperion Interactive Reports.
- Ensure that the environment is running optimally and to utilise house-keeping procedures.
Sharepoint Integration
- Integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry.
- Utilise web services to integrate from cutting edge technology into legacy systems such as Equation.
End of Day Cycle
- Provide second and third level support for in-house programmes during the end of day cycle.
- Analyse and rectify any problems raised in an independent and team scenario.
- Ownership of a problem and deliver a solution in a timely manner.
- Provide out of office hours support.
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.
Training & Competence
- Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines.
- Proactively seek to complete recommended technical and behavioural competencies training required for your role.
Conduct
- Act in accordance with the FCA/PRA Code of Conduct.
Business Continuity
- Fulfil all prescribed business continuity requirements as set out in the organisational or departmental specific plans or as instructed by the Line Manager/Head of Department.
Qualifications/Experience
- Degree level qualified or equivalent.
- SQL Programming.
- C# Software development.
Knowledge and Skills
- C# Programming to high level of proficiency.
- Software analysis and design.
- SQL query language.
- Dimensional modelling.
- Data warehouse design concepts, (Inmon or Kimball).
Database Engineer 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 Database Engineer role offers competitive remuneration, comprehensive training opportunities, and the chance to work with cutting-edge technology in a collaborative environment, ensuring that you can make a meaningful impact while advancing your career.
StudySmarter Expert Advice🤫
We think this is how you could land Database Engineer
✨Tip Number 1
Network like a pro! Get out there and connect with people in the industry. Attend meetups, webinars, or even just grab a coffee with someone who works at the bank. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL programming and C# projects. This is your chance to demonstrate what you can do beyond your CV. Share it during interviews or on LinkedIn to catch the eye of recruiters.
✨Tip Number 3
Prepare for those technical interviews! Brush up on your software analysis and design skills, and be ready to tackle some SQL queries on the spot. Practising common interview questions can help you feel more confident when it’s your turn to shine.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities waiting for you, and applying directly can sometimes give you an edge. Plus, it’s super easy to keep track of your applications that way!
We think you need these skills to ace Database Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Database Engineer role. Highlight your SQL programming skills, C# proficiency, and any relevant experience with data warehousing or software development. We want to see how your background fits perfectly with what we're looking for!
Showcase Your Problem-Solving Skills:In your application, don’t just list your skills—show us how you've used them to solve real problems. Whether it’s debugging a system or optimising processes, we love seeing examples of how you’ve taken ownership and delivered solutions.
Keep It Professional Yet Personal:While we appreciate professionalism, don’t be afraid to let your personality shine through in your application. A bit of flair can make your application stand out, so feel free to express why you're passionate about this role and working with us at StudySmarter!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us that you’re proactive and keen to join our team!
How to prepare for a job interview at Onyx-Conseil
✨Know Your SQL Inside Out
As a Database Engineer, you'll be expected to have a solid grasp of SQL programming. Brush up on your SQL skills and be ready to discuss complex queries or even solve problems on the spot. Practising with real-world scenarios can help you demonstrate your expertise.
✨Understand the Business Context
Since this role involves liaising with the Finance department, it's crucial to understand their processes and how your work will impact them. Familiarise yourself with budgeting and financial planning concepts, as well as how data flows within the Hyperion system. This knowledge will show that you're not just technically savvy but also business-minded.
✨Prepare for Technical Questions
Expect technical questions related to C# programming, software analysis, and data warehouse design concepts. Review common interview questions in these areas and prepare clear, concise answers. Being able to explain your thought process during problem-solving will impress your interviewers.
✨Showcase Your Problem-Solving Skills
The role requires ownership of problems and delivering timely solutions. Be prepared to discuss past experiences where you've successfully debugged issues or improved processes. Use the STAR method (Situation, Task, Action, Result) to structure your responses and highlight your contributions.
