Job Description

Roles & Responsibilities

Essential Duties and Responsibilities

• Execute and maintain the daily and monthly data extraction processes using advanced SQL querying to source data from various core systems into the MIS unit s database environment.
• Perform data transformation and cleansing tasks to ensure data consistency, accuracy, and readiness for analysis and reporting.
• Monitor and troubleshoot scheduled data update services (e.g., SQL Agent jobs) and report any system issues to the MIS Manager and IT Department promptly.
• Design and develop high-quality interactive financial dashboards, reports, and data visualizations using Microsoft Power BI (including data modeling, M-Query, and DAX scripting).
• Produce and distribute scheduled MIS reports, ensuring all deliverables adhere to strict quality standards and deadlines.
• Respond to and fulfill ad-hoc data requests from various business stakeholders, performing timely analysis and compiling accurate data sets.
• Ensure all reports and dashboards clearly reflect the company s official Key Performance Indicators (KPIs) related to loan portfolio, credit card usage, and profitability.
• Support the Manager in conducting detailed variance analysis by preparing the underlying data sets and initial findings for review.
• Identify and investigate data anomalies, reporting discrepancies, and unusual trends within the company s financial and operational metrics.
• Maintain comprehensive documentation of all data transformation logic, report generation procedures (SOPs), and Power BI data models.
• Assist the MIS Manager in identifying and implementing efficiency gains by helping to automate manual reporting steps and data preparation processes.
• Contribute to the continuous improvement of the data environment by suggesting enhancements to data structures and report distribution methods.
• Perform any other tasks assigned by the manager to support team operations and business objectives.

Desired Candidate Profile

Education

A minimum of BSc. in Finance, Accounting, Computer Science, or a related quantitative field.

Experience

Entry level.

Competencies

Core Competencies

• Strong verbal and written communication skills to clearly convey complex information to both internal and external stakeholders.
• Works proactively with colleagues, sharing knowledge, resources, and support to achieve team and organizational objectives.
• Adapt to change, embrace challenges, stay resilient under pressure, and maintain a positive attitude to achieve goals.
• Strong analytical and critical thinking abilities to resolve issues efficiently and effectively in complex, high-pressure situations.
• Able to uphold ethical standards, make transparent decisions, follow legal requirements, and treat others with fairness and respect.

Technical/Role-Specific Competencies

• Proficient in writing complex SQL queries for data extraction, manipulation, and optimization, with working knowledge of database environments such as SQL Server and tools like SSMS.
• Skilled in designing and developing interactive dashboards and reports using Microsoft Power BI, including data modeling, DAX calculations, and M-Query for data transformation.
• Proficiency in Excel for data analysis, reporting, and manipulation tasks in support of MIS and financial reporting functions.
• Ability to execute, monitor, and maintain automated data extraction and loading workflows, including scheduled jobs (e.g., SQL Agent), with competence in identifying and resolving data pipeline failures.
• Demonstrated ability to apply data cleansing and validation techniques to ensure reporting accuracy, alongside maintaining clear SOPs, transformation logic documentation, and data model records.