Data Analyst with SQL Server SSIS in London
Data Analyst with SQL Server SSIS

Data Analyst with SQL Server SSIS in London

London Full-Time 40000 - 45000 £ / year (est.) No home office possible
Jas Gujral

At a Glance

  • Tasks: Build and maintain a robust digital data infrastructure for a leading bank.
  • Company: Dynamic bank in Central London with exciting projects.
  • Benefits: Competitive salary, professional development, and a collaborative work environment.
  • Why this job: Make a real impact on data management and compliance in the financial sector.
  • Qualifications: Experience in SQL Server, data visualisation tools, and strong analytical skills.
  • Other info: Join a team that values integrity and offers excellent career growth opportunities.

The predicted salary is between 40000 - 45000 £ per year.

Our Client, a bank based in Central London, is seeking a highly motivated Data Analyst to play a key role in building and maintaining a robust digital data infrastructure. This position supports data users across the business, ensuring high-quality data extraction, reporting, and analytics capabilities.

Working closely with the IT Manager and various business units, you will help strengthen compliance and regulatory risk management through effective management information (MI) reporting and analytical insights.

Responsibilities
  • Develop, maintain, and enhance the Branch's digital data infrastructure to ensure reliability and accessibility.
  • Deliver accurate and timely data extraction, MI analysis, and reporting to support operational, compliance, and regulatory needs.
  • Work collaboratively with IT and business departments to understand data requirements and provide analytical support.
  • Explore, evaluate, and propose new technologies/tools to improve data management, governance, and reporting efficiency.
  • Ensure data integrity and support the implementation of best practices in data governance.
  • Assist in identifying and managing data-related risks, supporting the Branch's compliance and regulatory frameworks.
Must have:
  • Strong analytical skills with experience in data extraction, transformation, and reporting.
  • Proficiency in SQL Server, data visualisation tools (e.g., Power BI, Tableau), and data management technologies.
  • Understanding of data governance, regulatory reporting, and compliance requirements (banking/financial sector experience a plus).
  • Excellent problem-solving skills and attention to detail.
  • Ability to collaborate effectively with cross-functional teams and communicate complex information clearly.
  • Coming from an IT support function is a bonus.
Data Analysis and Management
  • Maintain and develop SSIS packages.
  • Perform ad-hoc data extraction and analytics based on requirements from business.
  • Develop data visualisation for business.
  • Work with business to enhance the data available to the data warehouse.
  • Assist in testing reporting solutions developed by external vendors.
  • Support and maintain the generation of internal MI reports.
  • Support and advise the business on data related matters and automation possibilities.
  • Any other responsibilities/tasks as assigned by the Head of IT from time to time.
Business Performance
  • Support the department's operations as and when needed and any other tasks assigned by the business stakeholders.
  • Work with the Managers to ensure the business is compliant with applicable rules and regulations that fall within the department's remit.
  • Work with the business to ensure timely submission of relevant department's reports.
  • To adhere and follow all Bank/Group applicable policies and procedures.
Data accuracy and ownership duties
  • To ensure all data worked on and/or shared with internal/external clients are accurate.
  • Escalate any data issue to the business promptly and without delays.
  • Ensuring any data sharing requests are discussed with business/DPO so that prior authorisation is given and follows GDPR/department's SOPs.
Regulatory Compliance duties
  • Comply with all applicable individual conduct rules (especially the FCA Conduct Rules, Regulations, Bank policies and procedures, and the banking Compliance).
Technical/Functional skills
  • Knowledge in SQL query is essential - Working experience in administration and development with SQL (experience with SQL Server and SQL Server Integration Service is preferred).
  • Experience in working with data visualisation tools such as Power BI.
  • Experience in working with scripting languages such as VBA and Python.
  • Experience in working with Power Automate is a plus.
  • Required understanding of the business and business units.
Personal skills (Soft Competencies [Core/Leadership])
  • Personal integrity and ethics.
  • Good judgement in enabling the provision of sound advice on regulation and practice, proactive management of compliance and regulatory risk.

You will have at least 3 to 5 years' relevant experience working in the data field, preferably in an established bank or financial institution.

Qualifications (Basic Degree/Diploma)
  • Bachelor's Degree or Professional Qualification in the relevant discipline (Degrees in Statistics, Information Systems, or similar).

This is an exciting position within a bank with interesting projects. The salary for this position is in the range £40K-£45K.

Please do send your CV to us in Word format along with your salary and availability.

Data Analyst with SQL Server SSIS in London employer: Jas Gujral

Our client, a prominent bank located in the heart of Central London, offers an exceptional work environment that fosters collaboration and innovation. With a strong commitment to employee growth, the bank provides ample opportunities for professional development and training, ensuring that team members are equipped with the latest skills in data management and analytics. The inclusive work culture prioritises integrity and compliance, making it an ideal place for those seeking meaningful and rewarding careers in the financial sector.
Jas Gujral

Contact Detail:

Jas Gujral Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Analyst with SQL Server SSIS in London

✨Tip Number 1

Network like a pro! Reach out to people in the banking and data sectors on LinkedIn. Join relevant groups, attend webinars, and don’t be shy about asking for informational interviews. You never know who might have the inside scoop on job openings!

✨Tip Number 2

Show off your skills! Create a portfolio showcasing your data analysis projects, especially those involving SQL Server and SSIS. This will give potential employers a taste of what you can do and set you apart from the crowd.

✨Tip Number 3

Prepare for interviews by brushing up on common data-related questions and scenarios. Practice explaining your past projects and how you’ve tackled challenges in data extraction and reporting. Confidence is key!

✨Tip Number 4

Don’t forget to apply through our website! We’re always looking for talented individuals like you. Plus, it’s a great way to ensure your application gets seen by the right people. Let’s get you that dream job!

We think you need these skills to ace Data Analyst with SQL Server SSIS in London

Analytical Skills
Data Extraction
SQL Server
SSIS
Data Visualisation Tools (e.g., Power BI, Tableau)
Data Management Technologies
Data Governance
Regulatory Reporting
Problem-Solving Skills
Attention to Detail
Collaboration Skills
Communication Skills
VBA
Python
Power Automate

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience with SQL Server and SSIS. We want to see how your skills match the job description, so don’t be shy about showcasing your relevant projects and achievements!

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about data analysis and how you can contribute to our team. Keep it concise but impactful – we love a good story!

Show Off Your Analytical Skills: In your application, give examples of how you've tackled data extraction and reporting challenges in the past. We’re looking for those strong analytical skills, so don’t hold back on sharing your successes!

Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity. Let’s get started!

How to prepare for a job interview at Jas Gujral

✨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 and SSIS, and maybe even tackle a few practical questions or problems during the interview. Show them you can extract and manipulate data like a pro!

✨Showcase Your Analytical Skills

Prepare examples of how you've used your analytical skills in previous roles. Think about specific projects where you delivered accurate data extraction or reporting. Being able to articulate your thought process will demonstrate your problem-solving abilities and attention to detail.

✨Understand Data Governance and Compliance

Since this role involves compliance and regulatory risk management, make sure you understand the basics of data governance and the relevant regulations in the banking sector. Be ready to discuss how you've ensured data integrity and compliance in your past work.

✨Collaborate and Communicate

This position requires working closely with IT and various business units. Prepare to talk about your experience collaborating with cross-functional teams. Highlight how you’ve communicated complex information clearly to non-technical stakeholders, as this will be key in your new role.

Data Analyst with SQL Server SSIS in London
Jas Gujral
Location: London

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>