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 pinpoint areas of failure to correct any issues. Liaise with Finance daily 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 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 be part of a team that values your contributions and supports your career development.
StudySmarter Expert Advice🤫
We think this is how you could land Database Engineer with SQL Server SSIS, SSRS and SSAS
✨Tip Number 1
Network like a pro! Reach out to your connections in the finance and database sectors. Attend industry meetups or webinars to meet potential employers and get your name out there.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL projects, especially those involving SSIS, SSRS, and SSAS. This will give you an edge and demonstrate your hands-on experience.
✨Tip Number 3
Prepare for interviews by brushing up on common database scenarios and problem-solving questions. Practice explaining your thought process clearly, as communication is key when liaising with finance teams.
✨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 that extra step to connect with us directly.
We think you need these skills to ace Database Engineer with SQL Server SSIS, SSRS and SSAS
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.
Highlight Your Communication Skills:As you'll be liaising with the Finance team daily, it’s important to demonstrate your ability to communicate clearly. Mention any experiences where you’ve successfully collaborated with other departments or stakeholders.
Follow Application Instructions:Don’t forget to send your CV in Word format along with your salary expectations and availability. We appreciate attention to detail, so following our instructions shows you’re serious about joining us at StudySmarter!
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, it’s crucial to understand how your work impacts the Finance department. Familiarise yourself with financial concepts and how data flows into systems like Hyperion. This will help you answer questions more effectively and show that you’re aligned with their goals.
✨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 resolved them. Being able to articulate your thought process will demonstrate your analytical skills and ability to handle challenges.
✨Show Your Compliance Knowledge
Since the role involves adhering to regulatory requirements, be ready to discuss your understanding of risk and compliance policies. Highlight any previous experience you have in maintaining compliance and how you’ve reported breaches or identified control gaps. This will show that you take these responsibilities seriously.
