Sr Executive- MIS

Job Title: Sr Executive MIS Department: MIS/ Business Intelligence / Operations Location: Gurugram Reports To: Manager – Business Intelligence / Senior Manager – MIS Job Summary: We are seeking an experienced and detail-oriented Sr Executive – MIS to join our team. The ideal candidate will have strong analytical skills, expertise in Advanced Excel, PostgreSQL, and hands-on experience in data extraction, transformation, and manipulation. You will be responsible for generating actionable insights through dashboards and reports that support strategic and operational decision-making across departments. Key Responsibilities: Design, develop, and automate MIS reports and dashboards using Advanced Excel and SQL (PostgreSQL). Perform complex data manipulation, cleansing, and validation to ensure data accuracy and integrity. Extract data from multiple sources, especially PostgreSQL databases, and prepare reports as per business needs. Work closely with cross-functional teams (sales, finance, operations, etc.) to understand reporting requirements and deliver solutions. Develop and maintain dashboards, KPIs, and performance reports on a regular and ad-hoc basis. Identify trends, anomalies, and insights from data to support strategic decision-making. Ensure the security and confidentiality of data being accessed and shared. Gathering requirements from stakeholders and troubleshoot report-related issues and ensure timely resolution of data discrepancies. Optimize SQL queries for faster performance and improved efficiency in data fetching. Required Skills & Qualifications: Bachelor’s degree in Commerce, Business Analytics, Statistics, Computer Science, or a related field. 2-5 years of experience in an MIS or data analysis role. Proficient in Advanced Excel (VLOOKUP, Pivot Tables, Macros, Power Query, Index-Match, Charts). Strong knowledge of SQL with hands-on experience in PostgreSQL. Strong understanding of data modeling and data manipulation techniques. Ability to write and optimize complex SQL queries and stored procedures. Strong attention to detail and data accuracy. Excellent problem-solving and communication skills. Ability to manage multiple priorities and work under tight deadlines. Preferred Qualifications: Experience with BI tools like Power BI or Tableau is a plus. Experience in process automation using VBA, Python, or any scripting language is an added advantage. Exposure to large datasets and database performance tuning