MIS Analyst

Job Title: MIS Analyst/ Sr. MIS Analyst Location: Pune Department: Data Website: www.strelema.com About Company Strelema is a leading political consulting firm delivering data-driven strategies for electoral success, specializing in voter behaviour analysis, campaign planning, and real-time sentiment tracking. With expertise in dynamic data sets, AI-powered political intelligence, and crisis communication, they turn political vision into impactful outcomes. Guided by values of integrity, client-centricity, and meaningful impact, Strelema empowers leaders to navigate the political landscape effectively. Job Overview The MIS Analyst will be responsible for managing, analyzing, and reporting business data to support decision-making processes. This role involves preparing and maintaining MIS reports, creating dashboards, and delivering insights using advanced tools and techniques. The ideal candidate should be proficient in Advanced Excel, Power BI, and data analysis, with a strong understanding of linking data to business outcomes. Key Responsibilities 1. MIS Reporting & Analysis o Prepare and maintain daily, weekly, monthly, and quarterly MIS reports. o Assimilate and analyze data from multiple systems to create actionable insights. o Monitor and validate data for accuracy, completeness, and consistency. o Detect anomalies, trends, and patterns to address operational inefficiencies. 2. Data Management & Visualization o Develop and maintain operational dashboards for all business verticals. o Create interactive dashboards and visualizations in Excel and Power BI. o Build Excel-based applications, macros (VBA), and automation tools for reporting. 3. Analytical Insights o Derive insights from electoral and demographic data using statistical methods. o Analyze structured and unstructured datasets to make recommendations. o Link data analysis to business objectives for improved decision-making. 4. Collaboration & Communication o Work with cross-functional teams to gather data requirements and deliver reports. o Communicate findings clearly to stakeholders through reports, charts, and presentations. 5. Project Management o Manage analytics projects to extract, process, and analyze data from multiple sources. o Ensure timely delivery of reports and insights in line with business timelines. Qualifications & Skills • Bachelor’s degree in Statistics, Mathematics, Economics, Computer Science, or related field. • 1 – 3 years of proven experience in MIS reporting and data analysis. • Advanced Excel skills (Pivot Tables, VLOOKUP, INDEX-MATCH, Power Query, etc.) – Mandatory. • Experience in VBA/Macro development is preferred. • Strong analytical and problem-solving skills. • Good communication skills and business acumen. • Ability to work independently and manage multiple priorities. Additional Requirements • Strong attention to detail and accuracy. • Adaptability to work in a fast-paced environment. • Capability to handle sensitive and confidential information with integrity.