Requirements: English
Company: TN Switzerland
Region: Pully , Vaud
Social network you want to login/join with:
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 as 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 companys 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 modeling, 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 & 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.
- Conduct testing of solutions developed and assist in validating outputs, conduct troubleshooting, and support existing solutions.
- Work in complex environments while 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 in order to fully utilize the solutions and gather feedback of future solutions.
- Maintain a global database of all prior Power BI reports that any future PC or manager could access or adapt for their own bespoke purposes.
We are looking for individuals who follow this profile:
- Excellent mathematical and/or statistics skills, data mining, and data visualization techniques.
- Bachelors 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 how to troubleshoot and find opportunities for automation.
- Experience in Microsofts wider portfolio of products is an advantage.
- Assist in Power BI System Governance & Tenant Management.
- Strong experience in devel