Core Requirements :
Advanced Proficiency in Microsoft Excel :
- Expertise in complex formula creation such as VLOOKUP, INDEX-MATCH, IF, and
nested functions.
Skilled in data summarization and analysis using pivot tables, filters, conditionalformatting, and other dynamic tools.
Ability to automate repetitive tasks using macros or advanced Excel features (preferred)Data Handling and Transformation :
Strong understanding of data structures, data cleaning, and transformation techniquesAbility to extract, merge, and manipulate data from multiple sources for meaningfulinsights.
Proficiency in identifying data inconsistencies and ensuring data integrity in reports anddashboards.
Power BI and SQL :
Ability to build interactive dashboards and reports using Power BIExperience in writing and optimizing SQL queries for data extraction and transformationUnderstanding of data modeling and relational database conceptsWritten Communication Skills :
Ability to draft professional and concise emails for internal and external communicationVerbal Communication :
Capable of clear and effective coordination across teams, ensuring accurateunderstanding of processes and requirements.
Preferred Attributes :
Detail-oriented with strong analytical and problem-solving skillsAbility to manage large data sets with precision and efficiencyComfortable working in a fast-paced, deadline-driven environmentProgramming experience in any platform or language (e.g., Python, R, VBA,etc.) is a plus, especially for data automation and processing tasks.
Experience : 10+Years
Location : Gurugram
Work mode : WFO
Skills Required
Power Bi, Data Cleaning, Data Modeling, Filters, Macros, Sql, Pivot Tables, Vlookup, Vba, Data Structures, Microsoft Excel, Python