Business Intelligence Analyst

The Business Intelligence Analyst will work with the Operations team across the different commodities and corporate functions with the goal of developing, supporting, and implementing business intelligence solutions using Power BI across its Commodity Trading and Risk Management system as well any other systems the company operates in.

This role will apply Microsoft Power BI across the enterprise to build new solutions for reporting and analytics, including model development, data visualizations, and governance. The position will also gather and analyze business requirements, plan, prepare, implement, and deliver solutions to production. The individual will collaborate with the Transformation team, Business Stakeholders and IT to validate the proposed architecture solution in order to enable the team to provision estimates, develop plans and prepare implementation approaches.

The company’s new global CTRM (iRely) has Power BI embedded. The company is also investing in a Microsoft CRM globally. This role aims to maximize the power of that near real time reporting CTRM with its embedded Power BI, as well as accessing non CTRM data in addition, and supporting the new future CRM, for further management reports, dashboards, business decision support, operational reviews and internal due diligence projects.

Key responsibilities :

Liaise with internal stakeholders to identify areas of the business that could benefit from analysis, or improved more accurate analysis, including replacing existing solutions if appropriate. This will later expand to external stakeholders, including future additional reporting services to customers or feeds to customer portals

Review and opine on data collection processes and validity of information stored. This includes examining and eliminating processes and procedures that contribute to unreliable or faulty data being collected and consumed, and improvement or streamlining of processes that increase efficiency

Understanding laws surrounding the collecting and processing of data and ensuring compliance in all reports and data usage (including GDPR)

Working closely with IT to ensure data collection and storage systems are secure, robust, value for money and business friendly

Use global data to gain and identify valuable insight into the way the business runs and patterns or anomalies

Prepare for predictive analytics after the CTRM and new global data lake is implemented

Developing PowerBI strategy for managing multiple PowerBI initiatives across the group company, including integration with embedded Power BI in iRely CTRM

Developing visual reports, dashboards and KPI scorecards using Power BI

Connecting to data sources, importing data and transforming data for Business Intelligence.

Keeping PowerBI efficient & lite which will allow quick & fast reporting / simulations etc

Excellent in analytical thinking for translating data into informative visuals and reports.

Act as Workspace Admin, create & grant access to a new workspace, assign user groups or individuals etc.

Serve as the conduit between the client business stakeholders and the IT team.