Senior Integration Analyst (SQL Developer) – Lisburn (Hybrid) | Permanent
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
WHJS1_NI
”, “datePosted”: “2026-05-12”, “hiringOrganization”: { “@type”: “Organization”, “name”: “Ocho”, “sameAs”: “https://uk.whatjobs.com/pub_api__cpl__429206686__4861?utm_campaign=publisher&utm_medium=api&utm_source=4861&geoID=936” }, “jobLocation”: { “@type”: “Place”, “address”: { “@type”: “PostalAddress”, “addressLocality”: “Belfast” } } }Senior Integration Analyst (SQL Developer) – Lisburn (Hybrid) | Permanent
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
WHJS1_NI
…