At a Glance
- Tasks: Develop and deliver systems to automate processes and support IT changes.
- Company: Leading bank in Central London with a focus on innovation.
- Benefits: Competitive salary, 12-month FTC, and opportunities for professional growth.
- Other info: Office-based role with a collaborative environment and career advancement potential.
- Why this job: Join a dynamic team and make a real impact in the banking sector.
- Qualifications: 5+ years experience with MS SQL Server, SSIS, and C# .NET.
The predicted salary is between 55000 - 70000 £ per year.
Our client is a bank based in Central London looking for a Database Engineer with solid experience in MS SQL Server and SSIS. The role involves developing and delivering new systems to automate and streamline processes across departments, supporting the internal IT department with software platform changes and upgrades, and serving as the primary contact for all technical questions regarding in‑house bespoke systems and interfacing.
Responsibilities
- Develop and deliver new systems to automate and streamline processes for various departments.
- Support the internal IT team with software platform changes and upgrades.
- Act as the primary technical contact for in‑house bespoke systems and interfacing.
- Support budgeting and financial planning processes for the Finance department, including loading and refreshing data.
- Conduct front‑end functionality to amend and change hierarchical structures within the environment.
- Debug and analyze errors and anomalies within Hyperion systems, pinpoint failure areas and correct issues.
- Liaise with Finance daily to ensure smooth operation of the Hyperion environment.
- Build data flows within the SQL environment using SSIS packages.
- Maintain knowledge of regulatory requirements and the bank’s risk and compliance policies to prevent exposure to risk.
- Report policy, procedure, or potential non‑compliance breaches promptly and execute all controls to minimize risk.
- Identify new risks or control gaps and escalate accordingly to line management.
Qualifications & Experience
- Degree level qualified or equivalent.
- Minimum 5 years of experience working with MS SQL Server and SSIS.
- Solid experience building data warehouses and developing with C# .NET.
- Knowledge of SSRS reporting and SSAS.
- Understanding of data warehouse design concepts (Inmon or Kimball).
Benefits & Other Information
This is a 12‑month FTC position with a salary around £55,000–£70,000. Candidates are required to work from the office at least three days per week.
Architecte Identity Security - F/H employer: FreeMat
As a leading bank in Central London, we pride ourselves on fostering a dynamic work culture that prioritises innovation and collaboration. Our employees benefit from competitive salaries, comprehensive training programmes, and ample opportunities for professional growth, all while working in a vibrant city known for its financial prowess. Join us to be part of a team that values your contributions and supports your career aspirations in the ever-evolving world of banking.
StudySmarter Expert Advice🤫
We think this is how you could land Architecte Identity Security - F/H
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with professionals on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your experience with SQL Server, SSIS, and C#. We recommend doing mock interviews with friends or using online platforms to get comfortable.
✨Tip Number 3
Showcase your skills through a portfolio! If you've worked on relevant projects, create a portfolio that highlights your achievements in database engineering and automation. This will give you an edge over other candidates.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Architecte Identity Security - F/H
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the role of Database Engineer. Highlight your experience with MS SQL Server, SSIS, and C#.Net. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this position. Share specific examples of how you've automated processes or supported IT teams in the past.
Showcase Your Technical Skills:Don’t forget to showcase your technical skills clearly. Mention your experience with data warehouses, SSRS, and any relevant projects. We love seeing how you’ve tackled challenges in your previous roles!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
How to prepare for a job interview at FreeMat
✨Know Your SQL Inside Out
Make sure you brush up on your SQL Server skills before the interview. Be prepared to discuss your experience with MS SQL Server, SSIS, and C#.Net in detail. Practise explaining how you've developed and delivered systems in the past, as this will show your practical knowledge.
✨Understand the Role's Responsibilities
Familiarise yourself with the specific responsibilities mentioned in the job description. Think about examples from your previous work that demonstrate your ability to automate processes, support IT teams, and liaise with finance departments. This will help you articulate how you can add value to their team.
✨Prepare for Technical Questions
Expect technical questions related to data warehousing, debugging, and compliance policies. Prepare to discuss your approach to identifying risks and control gaps, as well as how you’ve handled similar situations in the past. This will showcase your problem-solving skills and technical expertise.
✨Show Enthusiasm for Compliance and Risk Management
Since the role involves maintaining knowledge of regulatory requirements, be ready to talk about your understanding of risk and compliance policies. Demonstrating your commitment to these areas will highlight your suitability for the position and show that you take these responsibilities seriously.
