Aml Compliance Analyst-Automation

Job Purpose

To manage data analysis and dashboarding for AML compliance and transaction monitoring using advanced tools such as SQL, Tableau, and ACL. This role is critical in ensuring high-quality data integrity, effective MIS reporting, and compliance with regulatory norms, especially in the area of Anti-Money Laundering (AML) and Suspicious Transaction Reporting (STR).

Key Responsibilities

1. Data Quality & ETL Management

• Ensure end-to-end data flow and quality across systems using robust ETL processes.
• Maintain and validate large volumes of data with high accuracy and consistency.

2. Data Analysis & Query Handling

• Independently manage data extraction, analysis, and reporting tasks.
• Write and optimize complex SQL / PL-SQL queries for analytics and data manipulation.
• Perform root cause analysis of data discrepancies and inconsistencies.

3. Reporting & Dashboarding

• Develop and maintain interactive dashboards and visual reports using Tableau.
• Design and automate MIS dashboards to track key metrics related to AML and transaction monitoring.
• Work on Excel-based reporting and advanced spreadsheet models using formulas, pivots, and macros.

4. Compliance & AML Analytics

• Provide analytical support in AML Transaction Monitoring, STR analysis, and related compliance reports.
• Use tools like Audit Command Language (ACL) for forensic and audit-related data analysis.
• Collaborate with compliance teams to ensure regulatory and internal risk requirements are met.

5. Documentation & Continuous Improvement

• Document analytical workflows, data lineage, and logic used for MIS/Compliance reports.
• Suggest process improvements and automation opportunities in existing data/reporting workflows.

Key Skills & Competencies

• ETL & Data Quality Management
• Strong proficiency in SQL / PL-SQL
• Knowledge of Database Concepts (Normalization, Joins, Indexing, etc.)
• Hands-on experience with ACL (Audit Command Language)
• Tableau dashboarding and visualization
• Expert in MS Excel – Pivots, Advanced Formulas, Lookup functions, Conditional Formatting, etc.
• Familiarity with AML compliance frameworks, STRs, and Transaction Monitoring Systems
• Strong analytical and problem-solving skills

Educational Qualifications

• Graduate/Postgraduate in Computer Science, Data Science, Statistics, Finance, or a related field
• Certifications in SQL, Data Analytics, AML/KYC, Tableau are preferred

Experience Required

• Minimum 2 years of hands-on experience in SQL-based data handling and analytics
• Experience in banking / financial services or in a compliance-related analytics role is preferred
• Exposure to AML systems and regulatory reporting is a strong advantage