You will own and manage all the Data, MIS, Dashboard & Automation requirements that are needed to govern day to day operations, create recons and perform data analysis for the Product team working on
FinOps and Loan Management System.
What you will do:
Establish a robust reconciliation framework across our Loan Management System (LMS), lender systems, and payment gateways to ensure data consistency, anomaly detection, and automatedreporting via slack and email.
Design and implement frameworks to automate and deploy Management Information System (MIS), data integration, and manual operations workflows, streamlining processes and reducing manual effort.
Create databases and data marts that are required for performing analysis quickly and efficiently.
Work with product, finops & data teams to build data pipelines that are required for creating reporting datasets/data marts
Perform analysis,
create alerts and provide regular findings for metric movement, anomaly detection and improving operational efficiency
Must haves
Excellent data manipulation skill with proficiency in excel, sql & python
Ability to create data mart design required for building governance
Ability to create data and metric alerts for quick anomaly detection
Ability to do basic root cause analysis and provide findings to the stakeholders
Ability to integrate systems for slack reporting using Google AppScript & Webhooks
Nice to have :
Experience of handling large datasets using pyspark
Experience in working with BI tools such Tableau, PowerBI, Quicksight, Clickhouse etc
AI adaptability in routine tasks