Job Description

Title: Data Management ExecutiveExperience: 1- 3 yearsLocation: Delhi (Chandni Chowk)Key Skills:-

• Google Sheets, Forms, Dashboard and Integration of google sheets with external dabases like Oracle, MySQL. Also understanding of PL/SQL.
• Advanced Excel (VLOOOKUP,HLOOKUP, INDEX,MATCH,PIVOT TABLE ,SUMMIF,
• COUNTIF,ROUNDUP, ROUND, ROUNDOWN,PROPER, TRIM,CONCATNENATE,CHART, CONDITIONAL FORMATING,MAIL MERGE ,etc.)

Job OverviewWe are seeking a dedicated Data Management Executive to join our team in Delhi. This is a full-time, junior-level position ideal for individuals with 1 to 3 years of work experience. The successful candidate will play a crucial role in managing data systems and ensuring the integrity and accessibility of our data.Qualifications and Skills:

• Responsibility for maintain MIS and create report on daily basis.
• Make Flow chart monitoring sheets (FMS) and Project Monitoring sheets (PMS) on Google sheets.
• Manage Multiple Google FMS Sheet, IMS Sheet, PMS Sheet
• Depth knowledge of advance functions like - Pivot table, Array, Query, V-lookup , H-lookup, Mail
• merge, import range other advance functions in Excel and Google sheets. Google forms and dashboard.
• Maintain Google Sheets, Stock audit reports, Procurements report, Variance Analysis, Target Achievement reports, charts and presentation as required by the Directors.
• Automation of the all reports or daily work of operations to make it easier and smooth for team.
• Ability to think differently and incorporate suitable changes on existing reports.
• Ability to convert raw data in to statistical data which can be presented to the higher management
• Ability to plan and organize when faced with multiple tasks
• Create monthly, weekly and daily reports from various databases
• Analyze data to ensure correctness of reports created.
• Handle the Database on SQL & provide data to client.
• Automation report vba/macro writing on daily bases
• Daily MIS floating and coordination concern department.

Roles and Responsibilities

• Manage and maintain data systems to ensure data integrity and accessibility.
• Utilize Advance Excel, MySQL, and MIS for data analysis and reporting.
• Collaborate with various departments to gather data requirements and ensure accurate data entry.
• Develop and implement data management policies and procedures.
• Create detailed documentation on data management processes and systems.
• Analyze data trends and provide actionable insights to improve data quality.
• Troubleshoot and resolve data-related issues promptly.
• Assist in the development and maintenance of databases, including Oracle and Google Sheets.

Expertia AI Technologies