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