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- $100,000-$110,000 a year </div

Requirements

Must-haves

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.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlagilescrumjira

Platform: careers-page
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Parental Leave