Data Analyst

London, England, United Kingdom

12/19/2024

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.

For more information visit www.marex.com

Marex has unique access across markets with significant share globally both on and off exchange. The depth of knowledge amongst its teams and divisions provides its customers with clear advantage, and its technology-led service provides access to all major exchanges, order-flow management via screen, voice and DMA, plus award-winning data, insights and analytics.

The Technology Department delivers differentiation, scalability and security for the business. Reporting to the COO, Technology provides digital tools, software services and infrastructure globally to all business groups. Software development and support teams work in agile ‘streams’ aligned to specific business areas. Our other teams work enterprise-wide to provide critical services including our global service desk, network and system infrastructure, IT operations, security, enterprise architecture and design.

Role

The IT Group runs our enterprise-wide services to end users and actively manages the firm’s infrastructure and data. Within IT, Marex Technology has established a Data team that enables the firm to leverage data assets to increase productivity and improve business decisions, as well as maintain data compliance. The Data Team encompasses Data Analysis, Data Architecture, Data Intelligence and Machine Learning expertise. In recent years, they have developed a Data Lakehouse architecture, that is relied upon by different departments across the firm. Marex now seeks to strengthen its capabilities further and elevate the role of data in the operating models of Marex's businesses, directed by a strategy that aims to:

• Decentralise access for discovering and consuming data. Empower the data-savvy, entrepreneurial business leaders and citizen developers with the tools to interrogate data sets to explore and unlock opportunities for new or data-driven products and services.
• Provide a market-beating digital experience for clients by providing greater insight into their own data.
  
  

As a Data Analyst within the Enterprise Data team, you will be working daily within the Cross Sell business stream. You will act as a bridge between the business and Technology, cultivating relationships with data creators, data owners and data consumers and helping to ensure that data assets are properly defined and maintained within a central data catalogue.

You will be joining a dynamic and fast growing team and will have the opportunity to help shape how data is used, adding significant value to Marex’s client engagement strategies and cross-sell agenda through your work. You will help to enable growth whilst automating and improving reporting and efficiency.

You will develop a deep understanding of how internally generated and externally sourced data is used and how it flows through the firm. You will help to identify datasets suitable for ingestion into Marex’s Data Platform and will work closely with other members of the Data Team to ensure the data is efficiently ingested, correctly modelled and well governed, for use in downstream Business Intelligence and Machine Learning solutions. Through your work you will unlock greater value from data, automating repetitive reporting tasks, and improving scalability across the firm.

Responsibilities

• Identify and analyse structured and unstructured data across Client Insights – both internally generated and externally sourced (e.g. market data). Document how it relates to other datasets, how it flows through the organisation, how it is stored and how it is used.
• Identify datasets for ingestion into Marex’s Data Platform and work closely with other members of the Data Team to ensure the data is efficiently ingested and correctly modelled to deliver insights to the business and Technology.
• Identify data cost optimisation opportunities e.g. through alternate data offerings, rationalisation and/or centralisation.
• Identify and cultivate relationships with key data creators, data owners and data consumers.
• Ensure data assets are properly defined and maintained within a central data catalogue.
• Data modelling to transform operational data into analytic/reporting structures such as Kimball style multi-dimensional models.
• Take ownership of data issues through to resolution, working with IT and other internal stakeholders.
• Perform and automate data validation to improve data quality and integrity.
• Identify potential data quality improvements.
• Develop and maintain procedures, workflows and other documentation relating to data management.
• Keep up to date with key industry and technology developments as they relate to data management best practice in the financial services industry.
• Work with the Data Team, to translate business requirements into business intelligence visualisations / dashboards that can be easily understood and used.
• Locate and define new data-related process improvement opportunities.
  
  

Competencies

• A collaborative team player, approachable, self-efficient and influences a positive work environment.
• Demonstrates curiosity.
• Resilient in a challenging, fast-paced environment.
• Excels at building relationships, networking and influencing others.
• Strategic collaborator with insight and agility, able to anticipate future challenges, ensuring operational effectiveness.
• Ability to segment client bases, behaviour, demographics, profitability, engagement, cross-sell and upsell opportunities and other factors.
• Proficiency in applying statistical techniques to gain insights into client behaviour.
  
  

Essential

Skills and Experience:

• Experience creating BI models and dashboards in Power BI.
• Data modelling, cleansing and enrichment, with experience in conceptual, logical, and physical data modelling.
• Familiarity with data warehouses and analytical data structures.
• Experience of data quality assurance, validation, and lineage.
• Knowledge of software development methodologies (Sprints/Agile) and project management software (Jira).
• Excellent verbal and written communication skills.
  
  

Technical Skills

• Familiarity with SQL Server.
• Advanced SQL scripting (T-SQL, PL/SQL, Databricks SQL).
• Familiarity with ETL/ELT tools and experience navigating data pipelines.
• Experience using scripting languages (e.g. Python, PowerShell etc.) to extract insights from file-based storage.
• Familiarity with Git or other source control software.
• Knowledge of Orchestration Tools and processes (e.g. SSIS, Data Factory, Alteryx)
• Power BI Development including the data model, DAX, and visualizations.
• Relational and Dimensional (Kimball) data modelling.
  
  

Desirable

• Databricks (or Alternative Modern Data Platform such as Snowflake)
• Experience working in a regulated environment and knowledge of the risk and compliance requirements associated with this.
• Oracle Database
• MongoDB
• Cloud Data Technologies (Mainly Azure - SQL Database, Data Lake, HD Insight, Data Factory etc.)
• Knowledge of advanced analytics for client segmentation, lifetime value analysis, cross-sell opportunities and campaign impact evaluation.
• Familiarity with CRM tools and platforms such as Salesforce or HubSpot.
• Familiarity with Google Analytics / Data Studio.
  
  

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.