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 a focus on innovation and career development.
- 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 in Newtownabbey employer: Ocho
Contact Detail:
Ocho Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Integration Analyst in Newtownabbey
✨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 lookout 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 love seeing candidates who are genuinely interested in joining our team. Plus, it makes it easier for us to keep track of your application and get back to you quickly.
We think you need these skills to ace Senior Integration Analyst in Newtownabbey
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’re considered for the role. Plus, it’s super easy – just a few clicks and you’re done!
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 data integration solutions using SSIS, be ready to talk about your hands-on experience with it. Prepare examples of past projects where you've designed and implemented SSIS packages, and highlight any challenges you faced and how you overcame them.
✨Get Familiar with XML and Data Quality Checks
As you'll be working with XML data files, make sure you understand how to integrate and validate this type of data. Be prepared to discuss your approach to implementing data quality checks and maintaining data integrity across systems, as this is crucial for the role.
✨Communicate Clearly and Confidently
Strong communication skills are essential for this position, so practise articulating your thoughts clearly. Think about how you've collaborated with stakeholders in the past and be ready to share specific examples. This will demonstrate your ability to work effectively with clients and partners.