Business Analyst with AML expertise

Job Title: Business Analyst with AML expertise
Location: Plano, TX (100% Onsite)
Experience: 8 Years
Type: Fulltime

• 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.