Data 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.

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.

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.
• Build communities of practice around data management. Increase awareness and raise the profile of the data-driven opportunities for the firm.
• Ensure that the capabilities and tools of the Data Intelligence team infuse with the goals and operating models of each business within the firm.
• Ensure paid-for data is used efficiently, in a manner that aligns with our commercial agreements, and that such usage can be audited with any associated costs fairly attributed across data beneficiaries.

As a Data Analyst within the Enterprise Data team, you will be working daily within the Compliance 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 the Compliance function through your work. You will help to enable growth whilst automating and improving reporting & 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 Compliance and the wider firm.

Responsibilities:

• Identify and analyse structured and unstructured data across Compliance – 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, Skills and Experience:

Skills and Experience
Essential:
• 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).
• Experience creating BI models and dashboards, ideally in Power BI.
• Excellent verbal and written communication skills

Technical Skills:
• Familiarity with SQL Server.
• Advanced SQL scripting.
• 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
• Proficiency in SQL (T-SQL, PL/SQL, Databricks SQL)

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.)

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.

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.

#LI-MH1

•

Last updated on Sep 19, 2024