Data Analyst (Oil and Gas) at Glencore

    The Melrose Operational Risk and Trade support team is an independent services function aiming to support all global Operational Risk and Trade Support teams, by sourcing, maintaining, and reporting data, relating to the risks associated with the Oil and Gas Marketing activities. This position requires the individual to provide support and a clear, pro-active approach to communication to the Trade Support Manager, Operational Risk Manager, Risk Managers and Senior Risk Management.

  GENERAL ACCOUNTABILITY    

• Gathering and compiling data from internal and external sources, ensuring its accuracy and completeness.
• Identifying and resolving data quality issues, performing data transformations, and preparing data for analysis.
• Applying statistical methods and analytical techniques to examine data sets, uncover patterns, correlations, and trends, and extracting meaningful insight.
• Creating visual representations, such as charts, graphs, and dashboards, to present data findings in a clear and concise manner, facilitating understanding and decision making.
• Preparing reports and presentations summarizing data analysis results, highlighting key findings, and providing actionable recommendations.
• Work with others to define the business problem and identify which data-driven insights and data sources will help to solve that problem.
• Propose, robust solutions to meet the functional needs.
• Identify and implement process automation on daily tasks executed by the trade support and operational risk teams.
• Ensure practices abide by internal guidelines and external regulations.
• Liaise with line managers and project leads to ensure effective delivery of service and information.
• Provide basic trouble shooting and identify issues.
• Escalate incidents immediately when required.
• Produce daily, monthly, and annual reports where required.
• Provide support and cover to the operational risk and trade support team on daily BAUs where required. 
• Any other ad hoc duties that may be required from time to time.

      KEY RELATIONSHIPS  

• Trade Support Manager
• Operational Risk Manager
• Operational Risk Analysts
• Energy Operations Analysts
• Risk Managers
• Traders

    QUALIFICATION & SKILL REQUIREMENTS:

• Bachelor’s Degree (preferably in Computer Science, Information Systems, related field).
• Additional qualifications - SQL, Qliksense, QlikView, Python and Power BI advantageous.

    EXPERIENCE     

• Prior work experience is not a requirement however 1 to 2 years’ experience would be beneficial. 
• Trade experience advantageous.
• Awareness of market and industry trends.
• Coding skills in VBA, Python advantageous.

  COMPETENCIES

• Strong Analytical Skills – ability to use analytical tools and techniques to manipulate and analyse complex data sets effectively.
• Data Manipulation and Programming – ability to manipulate data using programming languages such as Python, VBA, SQL, Qliksense, QlikView etc.
• Data Visualisation – ability to build dashboards with data visualisation tools like Tableau, Power BI, or Excel to create compelling visualisations for data communication.
• Strong critical thinking and problem-solving skills to identify data-related challenges, develop appropriate analytical approaches, and derive actionable insights.
• Excellent verbal and written communication skills to effectively convey complex data findings to both technical and non-technical stakeholders.
• A meticulous approach to data analysis, ensuring accuracy, and paying attention to small details that may impact the results.
• A mindset of continuous learning and keeping up to date with new tools, techniques, and industry trends in data analytics.
• Multi-tasking and excellent management of time and priorities is essential.
• Ability to understand others’ perspectives and relate complex ideas to different groups at all levels, including senior management.
• Ability to challenge proposals constructively to help ensure they are robust, whilst maintaining excellent working relationships.
• Pro- active, committed and highly motivated.
• Ability to work independently.
• Ability to work well in a team.
• Adaptable, flexible, and entrepreneurial.
• Computer literate MS Office. Strong Excel & PowerPoint skills.