Business Analyst With Aml Expertise

Tata Consultancy Services; 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

Job Description

Business Analyst with AML expertise

Must Have Technical/Functional Skills

• Strong hands on expertise in SQL for complex data validation and reconciliation.
• Deep understanding of DWH architecture - Staging, ODS, DWH, Data Marts.
• Strong Banking domain knowledge (Retail, Corporate, Loans, Payments, Risk).
• Perform cross system data reconciliation between core and downstream systems.
• Perform defect analysis and root cause investigations with development teams.
• Automate data validation and reconciliation using scripts or frameworks.
• Work effectively in Agile/Scrum environments using JIRA/ALM tools.
• Strong hands-on SQL skills for data profiling, validation and analysis across large datasets.
• Good understanding of relational database structures, including tables, keys, joins, views and data relationships.
• Experience in data governance and metadata management, including defining business names and definitions for data elements.
• Hands-on experience with a metadata repository / data catalog tool
• Ability to identify and document Critical Data Elements (CDEs) used in business and regulatory reports.
• Proven experience in end-to-end data lineage, tracing data from reports back to the originating system.
• Ability to build data lineage manually and with automated lineage tools where available.
• Strong knowledge of Data Quality dimensions: completeness, accuracy, validity, consistency, timeliness and uniqueness.
• Experience defining, documenting and implementing Data Quality rules at the element level against business requirements.
• Hands-on experience with Data Quality tools.
• Ability to create Data Quality metrics, scorecards and dashboards for monthly executive reporting.
• Experience working with Authorized Data Sources (ADS) and enterprise data domains.
• Understanding of ETL / data integration processes and how data moves across source, staging, warehouse and reporting layers.
• Knowledge of Data Warehouse concepts: staging, ODS, data marts, and fact and dimension tables.
• Ability to perform source-to-target mapping (STM) analysis and data reconciliation.
• Experience with data profiling to find anomalies, gaps and the root causes of data issues.
• Ability to run data issue management: logging, tracking, remediating and escalating DQ exceptions.
• Working knowledge of reporting / BI tools ( e.g., Tableau, Power BI) to visualize DQ metrics.
• Familiarity with banking regulatory and data management frameworks
• Strong skills in gathering requirements and documenting findings with business and technology teams, analysts and developers.

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternaccl & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range- $90,000-$105,000 a year

Location

Plano, TX

Function

TECHNOLOGY

Role

Business Analyst

ID

437607

Skills

Business analyst

Salary Range

$90,000 - $105,000