Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Integrate and automate data solutions using SQL and SSIS in a dynamic financial services environment.
- Company: Join a leading financial services organisation based in Lisburn with a focus on data analytics.
- Benefits: Enjoy hybrid work, competitive salary, and opportunities for professional growth.
- Other info: Collaborative team culture with exciting projects and career advancement opportunities.
- Why this job: Make an impact by solving complex data challenges and enhancing data integrity.
- Qualifications: Strong SQL skills, ETL experience, and a passion for data integration.
The predicted salary is between 45000 - 55000 £ per year.
We're hiring a Senior Integration Analyst for a specialist data role within a financial services organisation based in Lisburn. This is a permanent position sitting within the Data Integration, Reporting & Analysis team, reporting to the Associate Director of Data Analytics.
If you're a strong SQL developer with solid ETL and SSIS experience, and you enjoy getting into the detail of complex data problems - this one's for you.
What you'll be doing:
- Integrating bulk data supplied in XML format onto live systems, writing SQL scripts to automatically cleanse and match data against existing records.
- Designing and building SSIS integration solutions from multiple source file types - Excel, .txt, and XML.
- Developing automated solutions for document handling - renaming, archiving, and moving files using database-driven logic.
- Implementing data quality checks and validation processes to maintain integrity across systems.
- Writing SQL to support ad-hoc business reporting and analysis needs.
- Working with internal and external stakeholders on data projects and client integrations, including SFTP-based file transfers.
- Sharing responsibility for the ongoing health of databases, integration packages, reports, and automated processes across the analytics team.
What we're looking for:
- Strong, hands-on SQL skills - writing, optimising, and working across multiple related tables.
- Solid experience building data integration solutions in SSIS.
- Comfortable working with XML data files and XSD schemas.
- Experience delivering process automation - file handling, renaming, archiving.
- In-depth knowledge of T-SQL and database design concepts.
- Familiarity with multi-server environments.
- Strong communication skills - you'll be working closely with clients and partners to ensure data is delivered correctly.
Nice to have:
- Experience in financial services or a regulated environment.
- Python, R, or C# scripting ability.
- Familiarity with Tableau, Power BI, or SSRS.
- Experience with SFTP-based file transfer automation.
- Exposure to PDF scraping or OCR techniques.
- Event-driven automated communication experience.
Benefits:
- Work From Home
Senior Integration Analyst employer: Ocho
Contact Detail:
Ocho Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Integration Analyst
✨Tip Number 1
Network like a pro! Reach out to your connections in the financial services sector and let them know you're on the hunt for a Senior Integration Analyst role. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL scripts, SSIS solutions, and any data integration projects you've worked on. This will give potential employers a taste of what you can do and set you apart from the competition.
✨Tip Number 3
Prepare for interviews by brushing up on common SQL and data integration questions. Practice explaining your thought process when tackling complex data problems, as this will demonstrate your analytical skills and problem-solving abilities.
✨Tip Number 4
Don't forget to apply through our website! We’ve got loads of opportunities waiting for you, and applying directly can sometimes give you an edge. Plus, it’s super easy to keep track of your applications that way!
We think you need these skills to ace Senior Integration Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL skills and experience with ETL and SSIS. We want to see how your background aligns with the role, 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 passionate about data integration and how your skills can benefit our team. Keep it concise but impactful – we love a good story!
Showcase Your Problem-Solving Skills: In your application, give examples of complex data problems you've tackled in the past. We’re looking for someone who enjoys diving into details, so share how you approached challenges and what solutions you implemented.
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 don’t miss out on any important updates from our team!
How to prepare for a job interview at Ocho
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with writing and optimising SQL scripts, especially in relation to complex data problems. Practise explaining how you've used SQL in past projects, as this will show your depth of knowledge.
✨Show Off Your SSIS Expertise
Since the role involves building SSIS integration solutions, be ready to talk about your hands-on experience with SSIS. Prepare examples of projects where you've designed and implemented SSIS packages, and highlight any challenges you faced and how you overcame them.
✨Demonstrate Your Data Integration Skills
Familiarise yourself with the types of data files mentioned in the job description, like XML and Excel. Be ready to discuss how you've integrated these file types in previous roles, and think about any automated solutions you've developed for document handling.
✨Communicate Clearly and Confidently
Strong communication skills are key for this position, so practice articulating your thoughts clearly. Prepare to discuss how you've collaborated with stakeholders on data projects, and be ready to explain technical concepts in a way that's easy for non-technical people to understand.