Data Analyst/MIS

Role & responsibilities : Have experience on advance Excel (Vlookup, Hlookup, Index and match, pivot, power pivot etc.) Responsible for publishing process reports at Daily Weekly & monthly frequency Manage MIS Documentation and SOP to ensure business continuity; Good in VBA to design macros to automate daily task Provide support and maintenance to existing MIS Data warehousing. Generate and publish reports dashboards accurately as per specifications and within TAT Collaborate the Reports and provide meaningful insights;Have 1-2 year job knowledge about excel, access and SQL Reevaluate the clients reporting requirements and enhance effectiveness of dashboards reports Taking care of all customer requests on various adhoc reports Generating adhoc reports to give better view of progress for all employees Headcount Reconciliation and maintaining updated headcount list, SAP Validation Handling all queries related to ID Management Stack preparation on a weekly and monthly basis; Prepare SOP & documentations and specifications Help write and optimize in-application SQL statements Preferred candidate profile : Good verbal & written communication & presentation skills Excellent Interpersonal skills with out of the box problem solving approach Ability to handle demanding working environment and work under pressure Ability to maintain focus while working with voluminous data Effective Organizational and time management skills Knowledge of data, data analytics * data mining processes Knowledge of SQL, Tableu and Power BI, Qlik Sense, Must posses Data Analytcs experience Required Candidate Specification : • 3+ years of Data Analytics & MIS experience • 3+ years of IT/ITeS industry experience • Strong decision making skills • Strong analytical skills • Flexibility to work shifts • Ability to work under pressure • Ability to handle varied products and clients