Business Intelligence Analyst

Marex is a diversified global financial services platform, providing essential liquidity, market access and infrastructure services to clients in the energy, commodities and financial markets.

The Group provides comprehensive breadth and depth of coverage across four core services: Market Making, Clearing, Hedging and Investment Solutions and Agency and Execution. It has a leading franchise in many major metals, energy and agricultural products, executing around 50 million trades and clearing 205 million contracts in 2022. The Group provides access to the world’s major commodity markets, covering a broad range of clients that include some of the largest commodity producers, consumers and traders, banks, hedge funds and asset managers.

Marex was established in 2005 but through its subsidiaries can trace its roots in the commodity markets back almost 100 years. Headquartered in London with 36 offices worldwide, the Group has over 1,800 employees across Europe, Asia and America.

The BI Analyst will contribute to the development and delivery of the Business Intelligence Platform. This will involve acting as part of a centre of excellence, liaising with Data Analysts, Engineers, and Business stakeholders to deliver a self-service solution utilising our modern data platform.

Responsibilities:

1. Perform a prominent role in the centre of excellence for business intelligence defining best practices for wider self-service adoption.
2. Mentor business champions building solutions for their specific departments.
3. Business Intelligence platform architecture and administration.
4. Liaise with data analysts and business stakeholders to gather requirements.
5. Translate requirements into technical solutions.
6. Advanced data modelling skills.
7. Data visualisation.
8. Proficient in performance analysis and tuning.
9. Ensure data security policies are applied appropriately.

Skills and Experience:

Essential:

1. Advanced Power BI (Modelling, Visualisation, Security, Platform Architecture and Administration).
2. DAX expressions.
3. Advanced SQL skills (SQL, T-SQL, PL/SQL).
4. Knowledge of Kimball data modelling methodology.
5. Experience of the Azure Data Platform including Azure Databricks.

Desirable:

1. Knowledge of wider Microsoft Fabric platform.
2. CICD (Git, Azure Devops, Bitbucket).
3. Semi-structured data stores and formats (MongoDB, JSON).
4. Experience of working in an Agile/SCRUM environment.
5. Knowledge of Financial Markets.

Soft Skills:

1. Able to communicate effectively with varied colleagues ranging from senior stakeholders in different business areas through to the technical implementation teams.
2. Think long-term, but deliver iteratively, and show value in small but frequent advancements.
3. Understand industry trends and best practice and be selective about what is applicable for Marex.

If you’re forging a career in this area and are looking for your next step, get in touch!

Marex is fully committed to being an inclusive employer and providing an inclusive and accessible recruitment process for all. We will provide reasonable adjustments to remove any disadvantage to you being considered for this role. We value the differences that a diverse workforce brings to the company. We welcome applications from candidates returning to the workforce. Also, Marex is committed to avoiding circumstances in which the appearance or possibility of conflicts of interest may exist within the hiring process.

If you would like to receive any information in a different way or would like us to do anything differently to help you, please include it in your application.