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

Senior Vigilance Associate

Aml Compliance Analyst-Automation

Associate Manager - Tata Neu Forex Card Operations

AML Team Lead_ Banking

OPS-RC / Reg Reporting Professional