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