Financial Data Analytics Manager

Rex Technologies GmbH; Greater London; On-site; GBP 75,000 - 110,000; Full time

Job summary

Marex are seeking a Finance Data Specialist to build centralised datasets for trading systems and finance reporting. You will work with data engineers and analytics teams to ensure datasets align with the general ledger, P&L reporting and statutory requirements.

You will help automate workflows, expose data to AI tools, and train the Finance team on new datasets and tooling. The role requires regulated-finance experience, strong Excel skills and a proactive, collaborative approach.

Qualifications

• Extensive experience in Finance within a regulated environment.
• Strong problem solving and analytical skills.
• Detail-oriented with a focus on accuracy and controls.
• Demonstrated ability in data manipulation and data quality.
• High proficiency in Microsoft Excel and data analysis tools.

Responsibilities

• Develop centralised core datasets for trading systems and Finance reporting.
• Build reconciliations to link datasets with the general ledger using EUC tools such as Alteryx.
• Collaborate with data engineers and analytics teams to validate datasets across the firm.
• Manage builds with IT and standardise processes for adoption by Finance.
• Design and execute UAT testing for all tools and updates.
• Document datasets, provide training to Finance, and ensure smooth adoption.
• Long-term migration of tools to IT-owned platforms.

Skills

Finance experience

Problem solving

Detail-oriented

Data manipulation

Excel expertise

Education

Qualified accountant (ACA/ACCA/CIMA)

Tools

Alteryx

Power BI

MS Access

VBA

Python

Power Query

Job description

About Marex

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.

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