Role:
The Business Intelligence Analyst will work with the Operations team across different commodities and corporate functions to develop, support, and implement business intelligence solutions using Power BI across its Commodity Trading and Risk Management system as well as other systems the company operates in.
This role applies Microsoft Power BI enterprise-wide to build new solutions for reporting and analytics, including model development, data visualizations, and governance. The position gathers and analyzes business requirements, plans, prepares, implements, and delivers solutions to production. It collaborates with the Transformation team, Business Stakeholders, and IT to validate the proposed architecture solution, enabling the team to provision estimates, develop plans, and prepare implementation approaches.
The company's 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 near real-time reporting CTRM with its embedded Power BI, as well as accessing non-CTRM data, and supporting the new future CRM for further management reports, dashboards, business decision support, operational reviews, and internal due diligence projects. The role acts as an internal consulting service to businesses and senior management on request for special analytics related to bespoke requests and studies.
Key Responsibilities:
* Liaise with internal stakeholders to identify areas of the business that could benefit from analysis or improved 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 improving or streamlining processes that increase efficiency.
* Understand laws surrounding the collecting and processing of data and ensure compliance in all reports and data usage, including GDPR.
* Work closely with IT to ensure data collection and storage systems are secure, robust, value for money, and business-friendly.
* Use global data to gain 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.
* Develop PowerBI strategy for managing multiple PowerBI initiatives across the group company, including integration with embedded Power BI in iRely CTRM.
* Develop visual reports, dashboards, and KPI scorecards using Power BI.
* Connect to data sources, import data, and transform data for Business Intelligence.
* Keep PowerBI efficient and lite, allowing quick and fast reporting/simulations, etc.
* Excellent analytical thinking for translating data into informative visuals and reports.
* Act as Workspace Admin, create and grant access to a new workspace, assign user groups or individuals, etc.
* Serve as the conduit between client business stakeholders and the IT team.
* Conduct testing of solutions developed and assist in validating outputs, conduct troubleshooting, and support existing solutions.
* Work in complex environments performing multiple activities on concurrent development projects and existing production processes.
* 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 and gather feedback on future solutions. Drive adoption of this centrally provided service globally.
* Maintain a global database of all prior Power BI reports that any future PC or manager could access or adapt for their own purposes, to more efficiently manage global report demands, but also ensure single best source of truth given multiple data sources.
We are looking for individuals with the following profile:
* Excellent mathematical and/or statistics skills, data mining, and data visualization techniques.
* Bachelor's Degree in any subject requiring an understanding of data management, business processes, and operations (e.g., Business, Business Administration, Finance, Economics, Engineering, Computer Science, Data Science, or related field).
* 5+ years of experience working with data analytics and prior Power BI proven experience, including prior roles as data analyst, data reporter, or business analyst.
* Expert experience with Microsoft Power BI and how to troubleshoot and find opportunities for automation to streamline day-to-day Operations of the platform.
* Experience in Microsoft's wider portfolio of products is an advantage, including its CRM and Dynamics ERP as other core data sources and usages.
* 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, row-level security, etc.
* Ability to effectively communicate in writing and orally with a wide range of audiences and maintain interpersonal relationships.
* Ability to work within time constraints and manage multiple tasks against critical deadlines.
* Ability to perform basic problem-solving and apply critical thinking, deductive reasoning, and inductive reasoning to identify solutions.
* Experience in working with virtual and global teams across different time zones.
* Experience working in an international environment.
* Intellectually curious; self-driven and self-motivated to experiment and play with global data to 'surprise and delight' for internal customers from volunteered self-driven new reports that could help the business or reveal insights.
* Problem-solving skills and creative thinker; highly methodical and well-organized in approach.
* Commodities experience preferred given complex concepts within our commodities data and interpreting it for trends and recommendations; ideally prior experience of near real-time reporting environments involving a CTRM; prior iRely operating knowledge a distinct advantage.
* Experience in project management and overseeing processes from conception to completion helpful.