Este perfil está escrito em inglês
Business Analytics Advisor – Finance
Demonstrated experience with Power BI.
Demonstrated experience with Tableau.
Demonstrated experience with dashboard design for non-technical users.
Demonstrated experience with advanced Excel.
Demonstrated experience with SQL.
Professional profile
Own the Power BI dashboards and reports the Finance organisation uses to track its business metrics (around 50 users): gather requirements, build data models, develop DAX measures and maintain them in production.. Designed advanced DAX models with 12-month rolling windows, using disconnected axis tables and TREATAS, to surface trends and period-over-period changes.. Extract and model data in SQL from Snowflake and SAP S/4; automated recurring data preparation workflows in Alteryx that had been assembled manually.. Ensure data accuracy and consistency across reporting platforms through reconciliation and validation checks across SAP, Snowflake, Tableau and Power BI.. Migrated four business-critical dashboards from Tableau to Power BI; two were rebuilt from scratch, including new data models, after a datasource change.. Documented data lineage between SAP S/4 and Snowflake while moving reporting off legacy tools, and delivered the applied statistics module of the internal analytics training programme.
Built and maintained the market-data dashboards the freight trading desk used for daily monitoring.. Analysed tanker markets and crude trade flows to identify trends, risks and opportunities for desks in Europe, Asia and the Americas; produced market forecasts with supply and demand scenarios.. Monitored PnL and market exposure together with the desk and presented insights for its daily decisions.
Processed macroeconomic and financial data (FX rates, interest rates, inflation) to assess counterparty risk and adjust payment strategy; wrote the macro and FX section of the quarterly financial presentations.
Tracked the impact of inflation on procurement costs and proposed cost-saving measures.
Supported the administration of international mining contracts and reconciled accounting discrepancies.