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. The role will act as an internal consulting service to businesses and senior management, on request, for special analytics related to bespoke requests and studies. The person is therefore responsible for both collecting and analyzing data to support near real-time performance and risk monitoring and future business decisions. Duties include data modelling, designing data analysis methodologies and compiling reports primarily for senior management. Business acumen and analysis experience are the priority skillsets, combined with Power BI expert user knowledge, given the focus on providing valuable insight to our business.

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.
• Review and opine on data collection processes and validity of information stored.
• 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 Power BI strategy for managing multiple Power BI initiatives across the group company.
• Developing visual reports, dashboards and KPI scorecards using Power BI.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Keeping Power BI efficient and lite which will allow quick and fast reporting/simulations.
• Excellent in analytical thinking for translating data into informative visuals and reports.
• Act as Workspace Admin, create and grant access to a new workspace.
• Serve as the conduit between the client business stakeholders and the IT team.
• Conduct testing of solutions developed and assist in validating outputs.
• Work in complex environments while performing multiple activities on concurrent development projects.
• Set up and automate Power BI platform-related activities using scheduled refresh, subscriptions, and power automate.
• Work independently with Senior Stakeholders.
• Develop Export User network within the organization to fully utilize the solutions.
• Maintain a global database of all prior Power BI reports for future use.

We are looking for individuals who follow this profile:

• Excellent mathematical and/or statistics skills, data mining and data visualization techniques.
• Bachelor’s Degree in any subject that requires an understanding of data management, business processes and operations.
• 5+ years of experience working with data analytics and prior Power BI proven experience.
• Expert experience with the Microsoft Power BI and troubleshooting.
• Experience in Microsoft’s wider portfolio of products is an advantage.
• Assist in Power BI System Governance & Tenant Management.
• Strong experience in developing visual reports, dashboards and KPI scorecards using Power BI.
• Design and develop datasets, dataflows, and row level security.
• Ability to effectively communicate in writing and orally with a wide range of audiences.
• Ability to work within time constraints and manage multiple tasks against critical deadlines.
• Ability to perform basic problem solving and apply critical thinking.
• Experience in working with virtual & global teams across different time zones.
• Experience working in an international environment.
• Intellectually curious; self-driven and self-motivated.
• Problem solving skills and creative thinker; highly methodical and organized.
• Commodities experience preferred.
• Experience in project management and overseeing processes is also helpful.