Responsibilities :
- Create and edit Web Intelligence and Desktop Intelligence documents based on business requirements.
- Develop VB Macros and Microsoft Excel or PowerPoint reports using various data types and expected result sets.
- Automate data analysis processes by creating Excel-based macros to improve efficiency.
- Create or modify SQL queries as per data gathering and analytical needs.
- Generate reports in HTML, PDF, or RTF formats as specified by business teams.
- Analyze statistical results to develop insights and provide actionable forecast plans.
- Manage and maintain data for seamless integration with data mining and analytical tools.
- Extract and transform data into meaningful structures for decision-making and reporting.
- Perform report generation, data analysis, and other related analytical tasks as required from time to time.
Knowledge and Experience :
Basic proficiency in English (written and verbal) with confidence to contribute to value-adding services.Hands-on experience with Excel Macros and Pivot Tables.Working knowledge of SQL queries (editing and creation).Familiarity with Crystal Reports or similar report creation tools.Strong understanding of data analysis concepts and various analytical models.Awareness of Cloud and SaaS environments.Effective communication, interpersonal, and collaborative skills.Ability to adapt to company culture and comply with organizational policies.Skills Required
Excel Macros, Pivot Tables, Sql, Cloud, Sass, Data Mining