Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Develop and maintain daily, weekly, and monthly MIS reports according to the lender's specific requirements.
Extract and analyze data from internal systems (e.g., ERP, CRM, SQL databases).
Automate regular reports using Excel (Macros, PivotTables, VLOOKUP, etc.) and/or tools like Power BI, Tableau, Google Data Studio.
Experience
1–2 years
Education
Bachelor's degree
Must-have skills
MS ExcelPivot Tables
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Bengaluru, India Compensation: INR 400000 - 600000 per year
About Olyv Olyv is India’s fastest growing, fully-automated next-gen Fintech company aiming to address the credit requirements of innumerous self-employed micro entrepreneurs, micro-merchants and middle/lower-income salaried individuals. Our platform also offers digital gold savings, credit health products, among others. Headquartered in Bengaluru, Olyv was conceived in 2017 with a mission to provide financial inclusion to the underserved market. The company has been facilitating micro-credit through its cutting-edge app and has witnessed rapid growth with over 4 Cr+ users and 1 million+ loan disbursed through its AI & ML-powered modules in over 19,000 pin codes across India. Olyv's app-based credit platform offers instant credit options through 100% automation at a pan-India scale. The company has been supported by reputed fintech investors like LGT Lightstone, Accion Venture Lab, Unicorn India Ventures etc. Olyv has been recognized nationally and internationally for its efforts at Google’s Launchpad Accelerator, Global Inclusive50 by MetLife, VISA, IFC, etc.
Key Responsibilities:
Develop and maintain daily, weekly, and monthly MIS reports according to the lender's specific requirements.
Extract and analyze data from internal systems (e.g., ERP, CRM, SQL databases).
Automate regular reports using Excel (Macros, PivotTables, VLOOKUP, etc.) and/or tools like Power BI, Tableau, Google Data Studio.
Coordinate with departments to gather data and ensure its accuracy.
Provide actionable insights based on trend and variance analysis.
Assist in forecasting and monitoring performance.
Troubleshoot and resolve data discrepancies and system issues.
Support senior management with ad-hoc reporting and analysis needs.
Key Skills & Competencies:
Advanced proficiency in MS Excel (Formulas, Pivot Tables, Charts, Macros).
Knowledge of database querying tools (SQL preferred).
Experience with BI tools like Power BI and Tableau (optional but preferred).
Strong analytical and problem-solving skills.
Attention to detail and a high level of accuracy.
Good communication and interpersonal skills.
Ability to manage multiple tasks and meet tight deadlines.
Qualifications & Experience:
Bachelor’s degree or related field.
1–2 years of experience in MIS reporting or a similar analytical role and fintech experience is required
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
