Business Intelligence Analyst (Advance Excel, VBA Macros)

Job description
Leverages software and services to transform data into actionable insights to inform the organization's strategic and tactical business decisions. Collects, integrates, analyzes and presents information including from internal and external sources, developing insightful historic, current and predictive views of business operations.

Required Qualifications

Diploma or equivalent work experience required.
Minimum of 2-4 years of relevant experience or equivalent combination of education and experience in Business Intelligence.
Good business English skills (Written and spoken).
Good knowledge of Advanced Excel.
Knowledge of Visual Basic & Power BI is an added advantage.
Works closely with supported functions to understand business priorities and KPIs.
Applies accepted metrics, methods and tools to analyze appropriate datasets.
Contributes to the development and delivery of basic Business Intelligence work-streams, including: Data synthesis and report generation.
Works on standard, recurring and ad-hoc reporting needs and data analyses.
Assists in efforts to develop and enhance data pipelines, workflows and queries based on larger data sets.
Applies developed methods for identifying data patterns and trends in available information sources.
Assist with the technical design, using object-oriented design techniques.
Assistance in measuring performance, increasing efficiencies, and tracking global key initiatives.
Optimizes the reporting for speed and efficiency.
Creates visual contents in alignment with best UI experience and branding guidelines.
Clarify questions brought up by business leaders regarding the reporting.
Role: Analytics Consultant
Industry Type: IT Services & Consulting
Department: Data Science & Analytics
Employment Type: Full Time, Permanent
Role Category: Business Intelligence & Analytics
Education
UG: Diploma in Mechanical
PG: Any Postgraduate
Key Skills
Object oriented designReport generationBasicVisual BasicTechnical designBusiness Intelligence Analystpower biBusiness intelligenceMacrosBusiness operations