At a Glance
- Tasks: Build and maintain a robust digital data infrastructure while supporting data users across the bank.
- Company: A leading bank in Central London with exciting projects and a collaborative environment.
- Benefits: Competitive salary of £60K-£75K, professional development, and a dynamic work culture.
- Other info: Opportunity to work on cutting-edge technologies in a supportive and engaging atmosphere.
- Why this job: Join a team that drives operational excellence and compliance through innovative data solutions.
- Qualifications: 7-10 years in data analysis, SQL Server experience, and strong analytical skills required.
The predicted salary is between 60000 - 75000 £ 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.
The Client would ideally like you to have experience in Network Engineering in addition to the Data Engineering skills. Ideally, you should have the following skills:
- LAN/WAN Administration
- Administer, maintain, and optimize Windows and Linux server environments
- Manage VMware virtualized infrastructure (vSphere 8 and above)
- Oversee enterprise backup and disaster recovery solutions using Veeam Backup & Replication
- Manage Veeam ONE monitoring and Veeam Recovery Orchestrator (VRO) environments
- Administer endpoint security and encryption solutions, including Symantec Endpoint Protection (SEP) and Symantec Endpoint Encryption (SEE)
- Support endpoint DLP, SIEM, and security monitoring tools (e.g., Splunk, Tenable)
- Manage patching processes using Manage Engine Patch Manager Plus
- Support Microsoft 365 services and related cloud technologies
The candidate must have strong technical expertise in Windows/Linux, VMware, Microsoft 365, networking, cybersecurity, and infrastructure management, who also enjoys solving complex challenges and driving operational excellence.
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
- Adhere to and follow all Bank/Group applicable policies and procedures
Data accuracy and ownership duties:
- Ensure all data worked on and/or shared with internal/external clients are accurate
- Escalate any data issues to the business promptly and without delays
- Ensure 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 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 7 to 10 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 based in Central London. The salary for this position is in the range £60K-£75K.
Data Analyst with SQL Server SSIS and Network Engineer employer: Onyx-Conseil
Onyx-Conseil is an excellent employer for those seeking a dynamic and rewarding career in infrastructure engineering. With a strong focus on employee development, the company offers numerous growth opportunities, a collaborative work culture, and the chance to work on impactful projects in secure environments. Located in Salford, employees benefit from a vibrant community and access to cutting-edge technology, making it an ideal place for professionals looking to enhance their skills and contribute to meaningful projects.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst with SQL Server SSIS and Network Engineer
✨Tap into Campus Networks
If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.
✨Get Certified
Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.
✨Connect on Professional Platforms
Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.
✨Apply Directly and Be Proactive
Don’t shy away from reaching out directly to firms like Onyx-Conseil. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.
We think you need these skills to ace Data Analyst with SQL Server SSIS and Network Engineer
Some tips for your application 🫡
Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.
Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to Onyx-Conseil.
Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.
Research and Reflect:Before hitting that 'apply' button on Onyx-Conseil's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!
How to prepare for a job interview at Onyx-Conseil
✨Brush Up on Financial Analysis Skills
Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with Onyx-Conseil.
✨Prepare for Case Studies
Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.
✨Show Your Passion for Finance
Since this is a full-time position, employers at Onyx-Conseil will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.
✨Network with Industry Professionals
Before your interview, reach out to current or former Onyx-Conseil employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.
