Database Analyst

Role Overview

The Database Analyst is responsible for managing and maintaining extensive databases with precision and accuracy. This role involves analyzing data and preparing comprehensive management information system (MIS) reports on a daily, weekly, and monthly basis to support business decisions.

Key Responsibilities

• Efficiently manage and maintain large-scale databases ensuring complete accuracy.
• Analyze data trends and prepare detailed MIS reports covering daily, weekly, and monthly periods.
• Design and develop sophisticated Excel reports, dashboards, and tracking tools.
• Conduct thorough data cleaning, validation, and reconciliation processes.
• Create pivot tables, charts, and data summaries to facilitate data interpretation.
• Utilize advanced Excel functions including VLOOKUP, XLOOKUP, INDEX MATCH, IF, SUMIFS, COUNTIFS, among other logical formulas.
• Employ Power Query and other data import utilities when necessary.
• Produce business reports that aid management in making informed decisions.
• Monitor data quality vigilantly and detect inconsistencies or discrepancies.
• Collaborate with various departments to gather, update, and verify data inputs.
• Protect the confidentiality of sensitive business information at all times.
• Ensure prompt completion of all assigned administrative and back-office responsibilities.

Skills and Requirements

• Proficient expertise in Microsoft Excel including Pivot Tables, Pivot Charts, Power Query, and Data Validation techniques.
• Strong command of Excel formulas and functions to handle complex data tasks.
• Capability to analyze large datasets effectively and recognize patterns or trends.
• Sharp numerical aptitude and advanced analytical thinking.
• Exceptional attention to detail ensuring data integrity.
• Good communication skills for reporting and interdepartmental coordination.
• Ability to perform efficiently under deadline-driven environments.
• Basic familiarity with Microsoft Word and PowerPoint applications.
• Knowledge of Google Sheets is considered a valuable plus.

Salary: The monthly remuneration ranges between 18,000 and 30,000 INR.