We are seeking an experienced ETL SSIS Developer with strong expertise in Anti-Money Laundering (AML) systems to join our banking technology team. The ideal candidate will design, develop, and maintain ETL processes using Microsoft SQL Server Integration Services (SSIS), ensuring accurate and timely data integration for AML compliance and regulatory reporting.
Key Responsibilities:
- Design, develop, and implement ETL workflows using SSIS to extract, transform, and load data from multiple sources into data warehouses and AML systems.
- Collaborate with AML compliance teams to understand data requirements for transaction monitoring, customer due diligence, and regulatory reporting.
- Optimize ETL processes for performance, scalability, and reliability.
- Develop and maintain SQL Server stored procedures, functions, and scripts for data processing and validation.
- Ensure data integrity and quality across all AML-related datasets.
- Support AML systems such as Actimize, SAS AML, or similar platforms by providing accurate data feeds.
- Troubleshoot and resolve ETL and database issues in a timely manner.
- Document ETL processes, data mappings, and workflows for audit and compliance purposes.
- Work closely with business analysts, compliance officers, and IT teams to deliver AML solutions aligned with regulatory standards.
Required Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- 5+ years of experience in ETL development using SSIS in a banking or financial services environment.
- Strong proficiency in SQL Server (T-SQL, stored procedures, performance tuning).
- Hands-on experience with AML systems and understanding of AML compliance requirements.
- Knowledge of data warehousing concepts, data modeling, and relational databases.
- Familiarity with regulatory frameworks such as BSA, KYC, and OFAC.
- Excellent problem-solving and analytical skills.
- Strong communication and documentation skills.
Preferred Skills:
- Experience with Actimize, SAS AML, or similar AML platforms.
- Knowledge of Python or other scripting languages for data automation.
- Exposure to cloud-based ETL tools (Azure Data Factory, AWS Glue) is a plus.
- Understanding of big data technologies and data governance practices.
Requirements
None
Top Skills
What We Do
Matrix Global Services is an award-winning Insurance and Financial Advisory.
Matrix delivers a unique portfolio of Insurance products and services that enable investors to access finance and to de-risk and enhance the security of their investments, through the application of proprietary insurance solutions that adjust and reduce risk.
Matrix is an outcome led, insurance market solutions provider, the solutions that we create and deploy, credit enhance all types of complex transactions, enabling the efficient flow of global capital.
The Matrix team possess an in-depth knowledge of, and strong and established connections to, the global markets for Insurance & (re)Insurance; we blend these capabilities with Financial and Capital Markets expertise, to assist our international clients with navigating complexity and opportunity.
Within the M&A community, our specialists provide independent Insurance Due Diligence, insurance programme design and reconstruction, W&I Insurance and supporting transactional solutions that provide our M&A clients with assurance whilst also adding tangible value within the investment life cycle
