Responsibilities The candidate has to collate data from multiple sources and dashboards, establish the cause-and-effect relationships between different data points.
Analyse and compare the same data-set at different time intervals, and one data-set with another data-set and establish cause-and-effect relationships.
Work collaboratively with multi-disciplinary, cross-functional teams with people from Website, PR, ORM, Social, Event popups, and other marketing specialties.
Maintain documentation and perform routine systems administration activities. Develop processes and procedures to ensure the security and integrity of data.
Develop, improve, document and maintain data standard operating procedures. Manage end-user accounts and accessibilities.
Develop and implement large databases using advance MS Excel techniques, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
Automating manual efforts by developing Macros / Web crawlers using VBA and Advanced MS Excel for Process improvements. Identify, analyze and interpret trends or patterns in complex data sets.
Work on with tools, softwares, dashboards and with process owners to identify the requirements and prepare daily / weekly / monthly reports.
Design and Implements systems to handle data / reports and regularly review to make necessary changes. Identify process gaps and collaborate with the department head to formulate solutions.
Role Requirements The Miko marketing team is seeking an experienced MIS Executive to track essential marketing KPIs and OKRs and to enable management take data based decisions.
Making team contribution visible through tracking efficacy of marketing spends against predetermined takeaways, monitoring campaigns efficacy through OKRs, MIS of key KPIS, analysis and insights, managing agreements, vendor payments, new service contracts, and archiving all marketing collaterals and brand assets.
Education Demonstrated experience in using work / project management softwares and data and analytics dashboards. Collaborating with software engineers and other development team members.
At least 3-year(s) work experience in the related field is required for this position. Experience in Advanced Excel, Macros & VBA is preferred.
Relevant certification is a plus. Highly motivated and proactive. Capable of working within tight deadlines. Possess good interpersonal communication skills in English.
Meticulous with an eye for detail. Able to raise and communicate issues or recommendations effectively.