Senior Integration Analyst

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

#J-18808-Ljbffr…