MIS Specialist

Job Description

Core Requirements: Advanced Proficiency in Microsoft Excel: Expertise in complex formula creation such as VLOOKUP, INDEX-MATCH, IF, and nested functions. Skilled in data summarization and analysis using pivot tables, filters, conditional formatting, and other dynamic tools. Ability to automate repetitive tasks using macros or advanced Excel features (preferred) Data Handling and Transformation: Strong understanding of data structures, data cleaning, and transformation techniques Ability to extract, merge, and manipulate data from multiple sources for meaningful insights. Proficiency in identifying data inconsistencies and ensuring data integrity in reports and dashboards. Power BI and SQL: Ability to build interactive dashboards and reports using Power BI Experience in writing and optimizing SQL queries for data extraction and transformation Understanding of data modeling and relational database concepts Written Communication Skills: Ability to draft professional and concise emails for internal and external communication Verbal Communication: Capable of clear and effective coordination across teams, ensuring accurate understanding of processes and requirements. Preferred Attributes: Detail-oriented with strong analytical and problem-solving skills Ability to manage large data sets with precision and efficiency Comfortable working in a fast-paced, deadline-driven environment Programming experience in any platform or language (e.g., Python, R, VBA, etc.) is a plus, especially for data automation and processing tasks. Show more Show less