Job Purpose
Results driven Business Analyst specializing in
Business Intelligence (BI) and Financial Reporting
, with extensive experience transforming complex data into strategic narratives and visual dashboards. Expert in designing and optimizing data models to track
critical KPIs
, profitability, and regional vendor/reseller performance. Proven track record of bridging the gap between traditional finance and technology, enabling executive decision-making through automation and predictive analysis.
Essential Duties & Resp Required
- Prepare and present compensation models for analyzing compensation plans and metrics for business units.
- Lead collaborative meetings and partner with assigned stakeholders in the business to drive profitability.
- Develop presentations and data visualizations relevant to analyze KPIs that impact the profitability of each business unit.
- Prepares and analyze overachievement per business unit and have meetings with leaders to follow up business results.
- Calculate sales commissions
- Actively participate and add value to ad hoc Finance initiatives and inter-departmental projects.
Core Competencies
- Advanced Financial Reporting: Specialist in financial statement consolidation, margin analysis, budget tracking, and reconciliation of complex corporate performance metrics.
- Data Modeling & ETL: Architecture and structuring of relational databases, large-scale data cleansing, and optimization of data flows from multiple sources.
- Performance Visualization: Creation of interactive, dynamic, and high-impact dashboards tailored for the C-Suite and regional management.
- Operational Efficiency: Automation of manual reports to reduce processing times, mitigate human error, and ensure data integrity (Single Source of Truth).
Technical Skills (Tech Stack)
- Analysis & Modeling: Advanced Excel, Power Pivot, Power Query, and DAX language.
- Visualization & BI: Power BI.
Qualification, Knowledge & Skills Required
Bachelor's degree in finance