FirstBank Jobs

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 (http://www.marex.com/)

As a Data Analyst within the Data team, you will act as a bridge between business streams 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.

Through your work 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 and correctly modelled for use in downstream Business Intelligence and Machine Learning solutions.

You will be familiar with market data offerings from the likes of Bloomberg and Refinitiv and will work closely with the Head of Data and the Market Data team to understand usage of market data across the firm. Helping to enhance existing models that monitor the usage and cost of this data.

Responsibilities:

• Identify and analyse structured and unstructured data across business streams – 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

Skills and Experience:

Essential:

• Data modelling, cleansing and enrichment, with experience in conceptual, logical, and physical data modelling.

• Experience of working with market data (e.g. Bloomberg BPipe, Bloomberg Data License, Refinitiv, exchange data etc.) and usage monitoring (e.g. vendor provided usage reports, logging etc.)

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

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