AML Data Analyst — SQL, Lineage & Quality

Tata Consultancy Services Limited; Plano (TX); On-site; USD 90,000 - 105,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Family Support: Parental Leaves

401K Plan

Certification & Training Reimbursement

Job summary

Tata Consultancy Services Limited in Plano, TX is seeking a Business Analyst with AML expertise to validate and reconcile large datasets across core and downstream systems. The role requires strong SQL, data governance, and DWH knowledge to support regulatory reporting and data quality initiatives.

Work in an Agile environment with cross-functional teams, leveraging BI tools to visualize DQ metrics and ensure data accuracy for risk and reporting purposes.

Qualifications

• Strong SQL skills for complex data validation and reconciliation.
• Deep understanding of DWH architecture and data layers.
• Extensive banking domain knowledge across retail, corporate, loans and payments.

Responsibilities

• Perform cross-system data reconciliation and data lineage tracing.
• Analyze defects and perform root cause investigations with development teams.
• Automate data validation and reconciliation processes with scripts or frameworks.
• Collaborate in Agile/Scrum environments using JIRA/ALM tools.
• Define business data elements and maintain data quality metrics.

Skills

SQL for data validation

Data governance

ETL / data integration

DWH architecture

Data lineage

Data Quality

Banking domain knowledge

Agile / Scrum (JIRA)

Tableau / Power BI

Data profiling

Tools

JIRA

ALM tools

Job description

Tata Consultancy Services Limited in Plano, TX is seeking a Business Analyst with AML expertise to validate and reconcile large datasets across core and downstream systems. The role requires strong SQL, data governance, and DWH knowledge to support regulatory reporting and data quality initiatives.

Work in an Agile environment with cross-functional teams, leveraging BI tools to visualize DQ metrics and ensure data accuracy for risk and reporting purposes.