MIS - Executive

Job Description

Experience : 1-3 Years Skills and Qualifications: Bachelor s degree in IT, Computer Science, Business Administration, or a related field. Technical Skills: Advanced proficiency in Microsoft Excel (including pivot tables, complex formulas, data analysis tools). Expertise in Power Query for data transformation and automation. Strong experience with Macros to automate repetitive tasks. Solid experience with SQL for data extraction, analysis, and manipulation. Experience in creating interactive Power BI dashboards for data visualization. Strong understanding of Data Modeling techniques for clean and efficient data analysis. Experience: Prior experience in an MIS or data analytics role, preferably within the e-commerce, retail, or supply chain industry. Analytical Skills: Strong analytical and problem-solving abilities with an attention to detail. Communication Skills: Ability to communicate technical information and data insights effectively to non-technical stakeholders. Time Management: Ability to prioritize tasks, manage time efficiently, and meet deadlines in a fast-paced environment. Job Summary: A highly skilled MIS Executive to join our team at the Aroor, Cochin location. The ideal candidate will possess advanced technical skills, including expertise in Excel, Power Query, Macros, SQL, and Power BI, with a strong background in creating dashboards, data modeling, and reporting. The MIS Executive will be responsible for analyzing data, preparing and automating reports, and providing insights to support key business decisions. Key Responsibilities: Report Creation & Automation: Design, develop, and maintain automated MIS reports using Advanced Excel, Power Query, and Macros. Data Analysis & Reporting: Extract, analyze, and present data insights using SQL and Power BI to support business functions. Dashboard Development: Create interactive and insightful dashboards in Power BI to track business performance and KPIs. Data Modeling: Develop efficient data models for reporting purposes and to streamline the reporting process. Ad-hoc Analysis: Support ad-hoc data requests and generate customized reports for management as needed. Collaboration: Work closely with different teams to understand reporting requirements and deliver reports that align with business needs. Data Integrity: Ensure data accuracy and consistency across all reports, dashboards, and data models. Troubleshooting: Identify and resolve issues related to data and reporting, ensuring seamless data flow and report delivery. Process Improvement: Continuously identify opportunities to improve reporting processes, automation, and data quality.