We are looking for a skilled and analytical Fraud Risk Data Analyst with
3 to 5 years of experience in fraud analytics, risk reporting and business intelligence. The ideal candidate should have solid expertise in Advanced Excel, Power BI/Tableau and SQL, with the ability to analyze large transactional datasets, identify fraud trends and develop automated dashboards to support business decisions.
Key Responsibilities
- Develop and maintain interactive dashboards using Power BI/Tableau to monitor fraud KPIs, chargebacks, alert volumes, false-positive rates and rule performance.
- Perform advanced data analysis, root-cause investigations and fraud trend analysis using Microsoft Excel.
- Utilize Power Query, Power Pivot, DAX, XLOOKUP, INDEX-MATCH and Pivot Tables for data modelling and reporting.
- Analyze fraud detection rules and recommend threshold optimization based on historical data and performance trends.
- Write SQL queries involving joins, CTEs, aggregations and window functions to extract and validate transactional data.
- Automate recurring reports and improve reporting efficiency through Excel macros/VBA and BI tools.
- Collaborate with Fraud Operations, Chargeback and Compliance teams to support fraud monitoring and regulatory reporting.
- Identify opportunities to improve fraud detection accuracy while minimizing false positives and customer friction.
Required Skills
- Advanced Microsoft Excel (Power Query, Power Pivot,
Pivot Tables, DAX, VBA/Macros, XLOOKUP and complex formulas).
- Strong hands-on experience with Power BI or Tableau.
- Working knowledge of SQL (Joins, CTEs, Window Functions and Aggregations).
- Experience in Fraud Risk Analytics, Risk Reporting or Business Intelligence.
- Strong analytical, problem-solving and data interpretation skills.
- Understanding of fraud monitoring, chargebacks, transaction analysis and risk management.
Education
Bachelor's degree in Commerce, Finance, Statistics, Economics, Mathematics, Engineering or any related analytical discipline.
Required Qualifications & Skills
- Experience: 3 to 5 years of experience in fraud risk analytics, risk reporting, or business intelligence within Banking, FinTech, Payments, NBFCs, or E-commerce.
- Advanced Excel Mastery (Core Requirement): Expert-level proficiency in Microsoft Excel, including Power Query (M), Power Pivot, VBA/Macros, dynamic arrays, multi-dimensional pivot tables, and financial/loss-impact modelling.
- Business Intelligence & Visualization: Strong hands-on experience building end-to-end data models, calculated measures (DAX), and executive dashboards in Power BI or Tableau.
- Data Querying: Solid working proficiency in SQL (joins, CTEs, window functions, aggregations) to pull and reconcile data independently.
[email protected] | (phone hidden)
📌 Fraud Risk Data Analyst (BI & Reporting) (Mumbai Suburban)
🏢 Datamatics
📍 Mumbai Suburban