Career Opportunities

Business Intelligence Analyst

London, GB Full-Time IT

Marex is an essential tech-enabled liquidity hub, connecting clients to global energy, metals, agriculture and financial markets. Across our businesses we provide critical high value-add services in Market Making, Commercial Hedging, Price Discovery and Data & Advisory. Headquartered in London, we have 18 offices worldwide with over 1,000 employees across Europe, Asia and North America.

The Role:

The BI Analyst will be part of a data team responsible for all aspects of data management and BI within Marex including Database Systems, NoSQL databases and Log analytics, and BI.
Having recently undertaken a transformation from legacy BI platforms to Power BI to provide a modern, intuitive, self service BI offering to all areas of the business, the BI Analyst will perform a central role in the analysis and design of BI requirements and deliverables.
In addition, the BI Analyst will be an integral member of the team responsible for increasing the value and insight of data within Marex Spectron through enhancements to our data warehouse, ETL functionality, and adoption of cloud-based data services.

The Person:

The team interfaces with all areas of the business and so the person should be comfortable communicating concepts and issues to both technical and non-technical audiences.
Also, as the team is responsible for a broad set of data and technologies the person should be comfortable assisting in other, perhaps unfamiliar, areas such as high-level DBA activities when required.
In summary the person should be
• A strong team player
• Take ownership of tasks and work autonomously when required
• Clear written and verbal communication skills
• Ability to work as part of a team and outside of current skill sets
• Eager to develop and keep up to date with new and enhanced technologies

Key Skills:

• Power BI Development including the data model, DAX, and visualizations
• Power BI Administration
• Relational and Dimensional (Kimball) data modelling
• Proficiency in SQL (T-SQL and PL/SQL)
• SQL Server Database
• Oracle Database
• Knowledge of ETL Tools and processes (e.g SSIS, ODI, Informatica, Data Factory)

Key Technologies:

• Power BI
• SQL Server Database
• Oracle Database
• Splunk

Desirable Technologies:

• Microsoft BI Stack (SSIS/SSAS/SSRS)
• Knowledge of analytic database functionality (partitioning, compression, column-store technologies)
• Business Objects administration and development
• MongoDB
• Cloud Data Technologies (Mainly Azure – SQL Database, Data Lake, HD Insight, Data Factory etc)

If this sounds like the role you’re ready for, we’d love to hear from you!

Marex Spectron is fully committed to the elimination of unlawful or unfair discrimination and values the differences that a diverse workforce brings to the company.