Business Intelligence Analyst - Dallas, United States - ECOM Agroindustrial Corp. Ltd.

Description

Role:

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 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. 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 GPDR)
• 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.
• 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. 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 bespoke purposes, in order to more efficiently manage global report demands, but also ensure single best source of the truth, given multiple data sources

We are looking for individuals who following 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 (e.g. Business, Business Administration, Finance, Economics, Engineering Computer Science, Data Science, or related field other degree equivalent.
• 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 the Microsoft Power BI and how to troubleshoot and find opportunities for automation to streamline the 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 reason, and inductive reasoning to identify solutions.
• Experience in working with virtual & global team across different time zones.
• Experience working in an international environment.
• Intellectually curious; self-driven and self-motivated to experiment and play with global data with a view 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 also helpful.