Data Analyst - Financial Crimes Analytics

About the Role

We are searching for a skilled Analytics Consultant to join our Financial Crimes Analytics team. This position plays a vital role in assisting investigative teams such as Intelligence and Special Operations by extracting and filtering pertinent data from an extensive metadata repository. Ideal candidates will demonstrate advanced SQL proficiency, comprehensive knowledge of customer and transactional datasets, and a strong analytical curiosity.

Key Responsibilities

• Develop and streamline complex SQL queries incorporating multiple table joins, Common Table Expressions (CTEs), temporary tables, conditional logic (CASE), ranking functions (RANK, QUALIFY), indexing strategies, and table design.
• Research and explore large metadata portals to pinpoint applicable tables and fields for investigations related to financial crimes.
• Partner with Financial Crimes units to understand data prerequisites and fulfill JIRA-defined data requests.
• Document data sources, database schemas, table architectures, and data lineage comprehensively.
• Validate data accuracy and ensure completeness of deliverables.
• Leverage domain expertise in retail and corporate banking to contextualize data insights.
• Exhibit proactive problem-solving skills and innovation when facing ambiguous analytical challenges.
• Communicate analytical findings effectively through both written and oral formats.

Qualifications and Experience

• Bachelor's degree in Technology (CSE/IT); an MBA in Finance is advantageous. Other backgrounds considered with strong SQL and retail banking experience.
• Between 3 to 6 years of professional experience focused on data analysis with a strong emphasis on SQL.
• Proficiency in Power BI for creating dashboards, visuals, and comprehensive analytical reports using data sourced from enterprise-wide databases and warehouses.
• Demonstrated experience handling extensive banking or financial services datasets involving customers, accounts, transactions, payments, and operational information.
• Advanced capabilities in querying and analyzing data from enterprise warehouses, data marts, or centralized platforms dealing with high-volume structured datasets.
• In-depth SQL knowledge including complex joins, optimizing query performance, profiling data, and validating results.
• Hands-on involvement with transactional, customer, and account-level data supporting functions like analytics, investigations, compliance, risk, financial crime detection, and reporting.
• Experience with Teradata databases is required.

Job Expectations

• Deliver precise and timely data outputs to support investigative teams such as Intelligence and Special Operations.
• Adhere to internal data governance frameworks and maintain security standards.
• Maintain thorough documentation for every SQL script and related data source.
• Identify data discrepancies early and escalate issues that pose potential risks.
• Work collaboratively across teams and consistently meet deadlines tied to JIRA work items.
• Exhibit curiosity and passion in resolving complex data challenges.
• Maintain investigatory and discovery-driven problem-solving approaches.
• Utilize critical and inventive thinking with a strong ability to learn and adapt.
• Support teamwork by fostering collaboration within cross-functional groups.

Eligibility

Open to candidates holding any graduate degree.