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.