At a Glance
- Tasks: Support budgeting and financial planning by managing data in the Hyperion system.
- Company: Join a leading bank with a focus on risk management and compliance.
- Benefits: Competitive salary, professional development, and a dynamic work environment.
- Other info: 12-month FTC position with opportunities for career growth.
- Why this job: Make an impact in finance while honing your SQL and data analysis skills.
- Qualifications: Degree level qualified with experience in SQL, SSIS, SSRS, and SSAS.
The predicted salary is between 55000 - 70000 £ per year.
Database Support supporting 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 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 elevate 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 with SSIS, SSRS and SSAS.
- 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.
Database Engineer with SQL Server SSIS, SSRS and SSAS in London employer: Onyx-Conseil
As a Database Engineer at our esteemed financial institution, you will thrive in a dynamic work culture that prioritises collaboration and innovation. We offer competitive salaries, comprehensive benefits, and ample opportunities for professional growth, all while working in a vibrant office environment that fosters teamwork and creativity. Join us to make a meaningful impact on our financial planning processes and enhance your career in a supportive and forward-thinking organisation.
StudySmarter Expert Advice🤫
We think this is how you could land Database Engineer with SQL Server SSIS, SSRS and SSAS in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the finance and database sectors. We all know that sometimes it’s not just what you know, but who you know. Attend industry meetups or webinars to make those valuable connections.
✨Tip Number 2
Prepare for the interview by brushing up on your SQL skills and understanding the Hyperion system. We recommend practising common database scenarios and troubleshooting techniques. Show them you can handle the pressure and solve problems on the spot!
✨Tip Number 3
Don’t forget to research the company culture! Understanding their values and how they operate will help you tailor your responses during interviews. We want you to show them you’re not just a fit for the role, but for the team too.
✨Tip Number 4
Finally, apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take the initiative. So, get your CV ready and let’s get you that Database Engineer position!
We think you need these skills to ace Database Engineer with SQL Server SSIS, SSRS and SSAS in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL programming skills and experience with SSIS, SSRS, and SSAS. We want to see how your background aligns with the role, so don’t be shy about showcasing relevant projects or achievements!
Showcase Your Problem-Solving Skills:Since the role involves debugging and analysing errors, include examples of how you've tackled similar challenges in the past. We love seeing candidates who can think critically and resolve issues effectively.
Be Clear About Your Availability:When you send us your CV, make sure to mention your availability clearly. This helps us understand when you can start and ensures a smoother process for everyone involved.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and we’ll have all your details in one place, making it easier for us to review your application!
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, SSIS, SSRS, and SSAS in detail. Practise writing queries and building data flows, as you might be asked to demonstrate your technical knowledge.
✨Understand the Financial Context
Since this role involves supporting budgeting and financial planning, take some time to understand how databases interact with financial systems. Familiarise yourself with Hyperion and its functionalities, as well as any relevant regulatory requirements that may impact the role.
✨Prepare for Problem-Solving Questions
Expect to face questions about debugging and analysing errors. Think of specific examples from your past experiences where you identified issues and implemented solutions. This will show your analytical skills and ability to work under pressure.
✨Show Your Communication Skills
Liaising with the Finance department is a key part of this role, so be ready to demonstrate your communication skills. Prepare to discuss how you've effectively collaborated with other teams in the past and how you would approach daily interactions with Finance.
