Data Analytics Lead Analyst Anti Money Laundering Detection Client Insights Vice President

00002 Citibank, N.A.; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading global bank is seeking a Data Analytics Lead Analyst in Toronto, Canada. This role focuses on leveraging data visualization tools like Tableau, developing SQL and Python scripts to support analytics. Candidates should have 6-10 years in data sourcing and governance, with a strong understanding of AML practices. A Bachelor’s degree and advanced communication skills are essential. Join us to drive data-informed decision-making in a dynamic team environment.

Qualifications

• 6-10 years of relevant experience in a data sourcing, reporting and/or governance role.
• Previous experience in AML and basic understanding of Citi’s businesses.
• Ability to independently write new SQL queries and optimize existing queries.
• Ability to develop Python code.
• Good command of Excel and ability to create presentations in PowerPoint.

Responsibilities

• Define a sourcing strategy and analyze large datasets.
• Perform data profiling tasks on new/existing data sources.
• Write SQL queries and optimize queries against Oracle and BigData.
• Develop Python code to extract and analyze data.
• Design dashboards and reports using Tableau.

Skills

Data sourcing

SQL

Python

Excel

Tableau

Data governance

Data visualization

Education

Bachelor’s/University degree or equivalent experience

Tools

Tableau

Oracle

BigData

Job description

Overview

We are seeking a highly analytical and detail-oriented Data Analytics Lead Analyst to join our growing data analytics and data modelling team. In this role, you will leverage your experience in data exploration, governance and visualization to drive a robust data model and data sourcing strategy to drive business insights and support strategic decision-making across the organization.

This role sits within the AML Detection Clients Insights (DCI) Group and specifically the Transaction Monitoring Business Systems Data and Analytics team.

Responsibilities

• Defines a sourcing strategy, collect and analyze large datasets from an identified data source to host and deliver data to business teams.
• Performs data profiling tasks on the new / existing data sources to identify quality of the data to be sourced.
• Documents the data sources to create data dictionaries, identify and document critical data elements as part of data governance responsibilities.
• Writes new SQL queries and optimize existing queries against Oracle and BigData data assets along with understanding and being able to interpret data models in Oracle and BigData.
• Develops Python code to extract, store and analyze large volumes of data.
• Designs and implement dashboards and reports using tools such as Tableau.
• Partners with business stakeholders, and occasionally senior management, to define metrics, monitor performance, and identify opportunities for growth or optimization.
• Develops and maintain SQL queries, ETL pipelines, and data models to support reporting needs.
• Communicates data findings clearly and effectively to both technical and non-technical audiences.
• Collaborates cross-functionally with business analysts, technology engineering and product teams to support data-driven initiatives.
• Identifies data-quality issues and contribute to data governance and standardization efforts.
• Resolves occasionally complex and highly variable issues.
• Produces detailed analysis of issues where the best course of action is not evident from the information available, but actions must be recommended / taken.
• Builds content related to the data projects he / she is working on and work with the SharePoint administrator to deliver the content on the SharePoint.

Qualifications

• 6-10 years of relevant experience in a data sourcing, reporting and / or governance role.
• Previous experience in AML and basic understanding of Citi’s businesses such as Services, Markets, Banking, US Personal Banking and Wealth is important.
• Experience in Tableau to create new dashboards and modify existing dashboards is preferred.
• Ability to independently write new SQL queries and optimize existing queries.
• Ability to understand and interpret data models in Oracle and BigData.
• Ability to develop Python code.
• Good command of Excel as an analytics tool and ability to create presentations in PowerPoint is mandatory.
• Ability to present technical data and concepts to a non-technical audience.
• Developed communication and diplomacy skills are required to guide, influence and convince others, in particular colleagues in other areas and occasional external customers.

Education

• Bachelor’s / University degree or equivalent experience, potentially Masters degree

Job Family Group: Technology

Job Family: Data Analytics

Time Type: Full time

Primary Location Full Time Salary Range:

Most Relevant Skills

Please see the requirements listed above.

Other Relevant Skills

For complementary skills, please see above and / or contact the recruiter.