At a Glance
- Tasks: Support and deliver MI operations, maintain data warehouses, and design new reports.
- Company: Join an international bank in the heart of London.
- Benefits: Competitive salary, flexible remote work, and opportunities for professional growth.
- Other info: Enjoy a hybrid work model with excellent career advancement potential.
- Why this job: Be part of a dynamic team making impactful decisions in a mission-critical environment.
- Qualifications: 5 years of experience with MS SQL Server, SSIS, SSRS, and SharePoint.
The predicted salary is between 45000 - 50000 £ per year.
Our Client is an international bank with offices in the City London. They are looking to recruit an MI Analyst with at least 5 years experience of MS SQL Server, SSIS, SSRS, and Sharepoint.
Responsibilities:
- Work within MI team in supporting and delivering all aspects of MI BAU encompassing data warehouse back end maintenance and Housekeeping
- Support annual Disaster Recovery invoking/testing
- Contribute to design, build and implementation of new reports and applications/interfaces.
- Facilitate internal/external Audits and Penetration Testing.
- Remediation
General Skills:
- Experience working within mission-critical environments
- Experience in operational deployments
- Maintains required industry recognised skills through training and self-study methods
Technical Skills:
- In-depth knowledge of MS SQL
- In-depth knowledge of SDLC
- C# Development (advantageous)
Technologies:
- SQL - TSQL, SSIS and SSRS.
- SQL - DBA.
- SharePoint & InfoPath.
- Hyperion (Oracle EPM).
- C#
- Any experience of process automation and Equation/iSeries DB knowledge.
- SWIFT.
- AIX would be very handy.
Good interpersonal skills, thorough and reliable, technically competent, and ability to work unsupervised.
This is a 6 month full-time permanent role. The salary will be £45K - £50K pro-rata. It is intended that you will work 2 days from the office and 3 days remotely from home for the foreseeable future. Do send your CV to us in Word format along with your salary and availability.
MI Analyst with MS SQL Server employer: Onyx-Conseil
As an international bank located in the heart of London, we pride ourselves on fostering a dynamic and inclusive work culture that values innovation and collaboration. Our employees benefit from flexible working arrangements, ongoing professional development opportunities, and a commitment to maintaining a healthy work-life balance, making us an excellent employer for those seeking meaningful and rewarding careers in the financial sector.
StudySmarter Expert Advice🤫
We think this is how you could land MI Analyst with MS SQL Server
✨Tip Number 1
Network like a pro! Reach out to your connections in the banking and MI sectors. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by brushing up on your SQL skills and understanding the latest trends in MI reporting. We recommend practising common interview questions related to data warehousing and operational deployments.
✨Tip Number 3
Showcase your technical prowess! If you've worked with SSIS, SSRS, or SharePoint, be ready to discuss specific projects where you made an impact. Real-life examples can set you apart from other candidates.
✨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 are proactive about their job search.
We think you need these skills to ace MI Analyst with MS SQL Server
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with MS SQL Server, SSIS, and SSRS. We want to see how your skills match the job description, so don’t be shy about showcasing relevant projects or achievements!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for the MI Analyst role. Share specific examples of your past work that relate to the responsibilities listed in the job description.
Be Clear and Concise:When writing your application, keep it straightforward. We appreciate clarity, so avoid jargon unless it’s necessary. Make sure your points are easy to read and get straight to the point!
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to receive your CV and cover letter. Plus, it shows you’re keen on joining our team at StudySmarter!
How to prepare for a job interview at Onyx-Conseil
✨Know Your SQL Inside Out
Make sure you brush up on your MS SQL Server skills before the interview. Be prepared to discuss your experience with T-SQL, SSIS, and SSRS in detail. They might ask you to solve a problem on the spot, so practice some common SQL queries and data manipulation techniques.
✨Showcase Your MI Experience
Since this role is all about MI, be ready to talk about your previous projects where you've supported MI BAU. Highlight any specific reports or applications you've designed and built, and how they contributed to the business. Use concrete examples to demonstrate your impact.
✨Prepare for Technical Questions
Expect technical questions related to data warehousing, disaster recovery, and operational deployments. Brush up on your knowledge of SDLC and any relevant technologies like SharePoint and Hyperion. Being able to explain your thought process will show your depth of understanding.
✨Demonstrate Your Interpersonal Skills
This role requires good interpersonal skills, so be ready to discuss how you've worked within teams and facilitated audits or testing. Share examples of how you've communicated complex technical information to non-technical stakeholders, as this will highlight your ability to collaborate effectively.
