Job Description

Job Title: EDRC MIS Coordinator

• General Description:
  

As EDRC MIS Coordinator, the person shall be responsible for all the activities related to planning, monitoring, MIS, reports, and control aspects for all EDRC actives. EDRC MIS coordinator shall monitor all the costs, sales and manhours spent by Engineering Team and shall be responsible for accurate allocation and monitoring of costs on a month-on-month basis.

• Roles & Responsibilities of EDRC MIS Coordinator:
  

• Responsible for Preparing dashboard reports (Using Power BI) tools for each project wise which should contain the status of Engineering deliverables.

• MIS Coordinator shall be responsible for preparing various PowerPoint presentation (with graphical, charts) and submit the same to the Top-level management.

• Coordinate with IT team & ensure to implement all required automation of reports & digitalization of MIS activities.

• Work closely with all Heads of Engineering of different team within EDRC, Project Engg Managers, Tech leads to collect the various data for analysis.

• Collate and analyze the raw data (like Manpower, MHs, invoice, budget, cost etc.) & understand data points, and prepare reports to facilitate the decision making.

• Review and consolidation of the weekly reports for the various projects and compile a consolidated report for each team.

• Proactive interaction with engineering & project execution team for monitoring the critical path activities.

• Interact closely with Finance team on regular basis, provide accurate cost debits to the different projects and tenders.

• Need to Co-ordinate & closely work with HR team for the manpower analysis (based on current workload manpower requirement, and wrt budget, resignation, TAR.)

Work with stakeholders across onshore and offshore in gathering data and prepare the reports as per business need. (Data like External Engg cost, Front office cost etc.).

• Education & Experience Required:
  
  • Diploma OR Any UG (Bachelor\xe2\x80\x99s degree with certification/PG in Advanced Excel/Macro/data Analytics)
  5~8 Years\xe2\x80\x99 experience in MIS coordination/Data Analytics in construction/Engineering Companies, invoicing & collections.
  

• Skills Required:
  
  • Must be capable of Multitasking.
  • Effective Communication skills both verbal and in Writing.
  • Effective Analytical & Problem-Solving Skills.
  • Advance MS Excel: Shall be an advanced user (Graphs, Pivot Tables, Lookup techniques, Graphs & Charts, Functions, Formula\xe2\x80\x99s, Data validation, Advanced Excel List)
  • Power Point presentation \xe2\x80\x93 Shall be able to make the Slides with icons, animations, links etc.,
  • MS Word skills \xe2\x80\x93 Shall have the basic skills
  • MS Outlook \xe2\x80\x93 Shall have advanced skills
  • Basic Knowledge on share point & share folder usage.
  • Google Forms \xe2\x80\x93 Shall be able to create Surveys and report
  • Experience in use of Power BI (Desktop Version), Macros, VBA, SQL, Dashboard Creations, Planning tools like primavera, MS project etc will be an added advantage.