Financial Data Analytics Manager

Marex Group; Greater London; Hybrid; GBP 70,000 - 110,000; Full time

Job summary

Marex Group seeks a Finance Data Specialist to develop centralized datasets for trading systems, enabling management P&L reporting, balance sheet substantiation and statutory reporting.

You will build datasets, reconcile to the general ledger using EUC tools like Alteryx, Power BI and VBA/Python where needed, and partner with IT and analytics teams to ensure robust, auditable data for finance across the firm.

Qualifications

• Extensive experience working in Finance within a regulated environment.
• Advanced Microsoft Excel skills and data manipulation experience.
• Interest in data-manipulation techniques and data governance.

Responsibilities

• Develop core datasets for Marex's trading systems for P&L, balance sheet and statutory reporting.
• Build reconciliations to link datasets to the general ledger using EUC tools such as Alteryx.
• Partner with enterprise data engineers and analytics teams to validate data and ensure adoption by Finance.

Skills

Excel expertise

Problem solving

Data manipulation

Attention to detail

Regulated finance knowledge

Tools

Alteryx

Power BI

Microsoft Access

VBA

Python

Job description

Marex Group plc (NASDAQ: MRX) is a diversified global financial services platform providing essential liquidity, market access and infrastructure services to clients across energy, commodities and financial markets.

The group provides comprehensive breadth and depth of coverage across four core services: clearing, agency and execution, market making, and hedging and investment solutions. It has a leading franchise in many major metals, energy and agricultural products, with access to 60 exchanges. 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. With more than 40 offices worldwide, the group has over 3,000 employees across Europe, Asia and the Americas.

For more information visit https://www.marex.com/

Role Summary

Develop centralised core datasets for Marex’s trading systems, globally across the firm, to the standards of a listed environment for purposes such as:

• Enterprise level dataset integration
• Management P&L reporting
• Balance Sheet Substantiation
• Statutory Reporting

Build an extensive knowledge of Marex’s business operations, covering booking models, source systems and data flows, to work towards the systematic development of the required data sets.

Build tools that make use of these datasets, for example:

• Reconciling them to the general ledger
• Using them to automate parts of Finance’s workload
• Exposing them to AI tools

Partner with the enterprise data engineers, and data analytics teams working towards the target state solution for sourcing and reporting data for the firm. Become SME for these datasets and tools, document them and ensure smooth adoption by Finance and robust integration into enterprise datasets to describe the firm in granular and timely terms.

Responsibilities

• Work with internal teams to develop core datasets for the various trading systems in use at Marex. Refine these datasets to ensure they meet Finance’s requirements for management P&L reporting, balance sheet substantiation, statutory reporting including ensuring they can be effectively interpreted by AI tools.
• Build reconciliations and similar to ensure these datasets tie to the general ledger and to assist Finance in using them for the abovementioned tasks. Typically, the build will take place using End User Computing (“EUC”) applications such as Alteryx.
• Partner with the enterprise data engineers and analytics teams to validate integrated datasets against the general ledger and act as the liaison and representative for Finance into enterprise level dataset creation and maintenance across the wider firm.
• Work with IT department to manage any parts of the build not being implemented through EUCs.
• Design and execute UAT testing for all tools built and any subsequent changes.
• Become subject matter expert on these datasets and associated tools. Document the datasets and tools and provide training to the wider Finance team to ensure effective adoption.
• Crosstrain others within the Finance Change team on the tools built to ensure coverage.
• Longer term, work with the IT department to migrate these tools onto IT-owned platforms.

Skills and Experience:
Required

• Extensive experience working in Finance in a regulated environment, and knowledge of the risk and compliance requirements associated with this
• Exceptional problem solving skills
• Control-focused and detail-oriented mind-set
• Demonstrable interest in data-manipulation techniques
• Highly advanced, up-to-date knowledge of Microsoft Excel

Beneficial

• Qualified accountant
• Experience working in Product Control or a related Finance function. Roles involving balance sheet substantiation and/or control design and implementation are especially valuable
• Understanding of a range of Financial products (e.g. equities, futures, FX, options and other derivatives)
• Experience with platforms such as Alteryx, Power Query, Power BI (or even Microsoft Access)
• Knowledge of a programming language (e.g. VBA, Python)

Competencies:

• A collaborative team player, approachable, self-efficient and influences a positive work
• Environment.
• Demonstrates curiosity.
• Resilient in a challenging, fast-paced environment.
• Ability to take a high level of responsibility in a fast pace and high-volume environment.
• Excels at building relationships, networking and influencing others.
• Strategic collaborator with insight and agility, able to anticipate future challenges, ensuring
• operational effectiveness.

Conduct Rules

• Act with integrity
• Act with due skill, care and diligence
• Be open and cooperative with the FCA, the PRA and other regulators
• Pay due regard to the interests of customers and treat them fairly
• Observe proper standard of market conduct
• Act to deliver good outcomes for retail customers

Company Values

Acting as a role model for the values of the Company:

Be collaborative - by working together across the organisation, we foster teamwork, can better respond to challenges and successfully deliver for our clients

Act with integrity - we pride ourselves on our honesty and high ethical standards. We apply these values when working with all our clients, colleagues and other stakeholders

Be adaptable and entrepreneurial - we embrace change as markets evolve to constantly increase our efficiency and create innovative solutions for our clients. We are interested in the world around us and inquisitive about understanding the challenges and opportunities our clients face.

Be respectful - how we treat each other, and our clients says everything about who we are. We always act respectfully and treat people fairly in everything we do.

Nurture talent - we aim to grow our own talent and make Marex the place ambitious, hardworking and talented people choose to build their career. This means giving and taking stretch opportunities, taking risks, and committing to career development and support - for ourselves and our teams.

Marex is fully committed to being an inclusive employer and providing an inclusive and accessible recruitment process for all. 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.