BI Developer

CMC Markets; London; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading financial services firm in London seeks a Business Intelligence – Data Analyst/Developer to support a key business project through operational and ad-hoc reporting. This role requires strong Oracle SQL skills, analytical thinking, and proficiency in Excel. The ideal candidate will engage with stakeholders to convert data requirements into scalable solutions. This is a 12-month fixed-term contract offering a supportive work environment.

Qualifications

• Strong analytical and problem-solving skills with attention to detail.
• Proven track record in providing information and data reporting to relevant business units.

Responsibilities

• Responsible for operational and ad-hoc reporting to support a key business project.
• Translate data requirements provided by business units into scalable data solutions.
• Engage with key business stakeholders to understand processes, define data assets, and gather reporting requirements.

Skills

Advanced Oracle PL/SQL skills

Experience developing data mart/data warehouse solutions

Advanced Oracle SQL skills including data discovery, querying, data manipulation, and data analysis

Proficiency in Excel to report large datasets

Experience in Spread Betting and CFD derivatives or similar financial products

Job description

CMC Markets is a global leader in CFD trading and share investing. Our vision is to provide the ultimate online trading experience so everyone can achieve their financial potential. Since our launch in London in 1989, we’ve expanded globally with offices across Europe and Asia Pacific. Over 1.2 million clients make 67 million trades with us every year, and we’re still growing.

CMC offers an award-winning online and mobile trading platform, enabling clients to trade up to 10,000 financial instruments across shares, indices, foreign currencies, commodities and treasuries through contracts for difference.

The Group’s values centre on quality, clients and integrity.

• Put clients first
• Lead with quality
• Set the standards

*Please note: this is a 12 month fixed-term contract*

Role and Responsibilities:

As a Business Intelligence – Data Analyst/Developer, you will be responsible for the operational and ad-hoc reporting to support a key critical business project. You will be enabling data-driven decision-making by working with CMC’s operational and functional teams.

What is in it for me?

You will contribute to a key business project by translating data requirements provided by business units and SMEs into scalable data solutions. You will be backed and supported in a can-do, supportive structure.

• Possess strong analytical and problem- solving skills with attention to detail

• Analyse large datasets using Oracle SQL to extract, manipulate and report data.

• Be able to develop robust, accurate and scalable data solutions from operational data.

• Perform application and data analysis to understand business processes.

• Engage with key business stakeholders to understand processes, define data assets, and gather reporting requirements.

• Analyse and document existing reports and processes

Key skills and Experience:

• Advance Oracle PL/SQL skills

• Experience developing data mart/data warehouse solutions

• Advanced Oracle SQL skills including data discovery, querying, data manipulation, and data analysis

• Experience in understanding requirements and developing data-related reports/extracts

• Proficiency in the use of using Excel to report large datasets

• Proven track record in providing information and data reporting to relevant business units to agreed deadlines

• Experience in Spread Betting and CFD derivatives, Shares, or similar financial products is desirable

Competencies:

• Effective communication

• Organisation skills

• Teamwork

• Customer focus

• Resilience and adaptability

• Problem-solving

• Resourcefulness

• Attention to detail, resilience and adaptability

CMC Markets is powered by our people. We are an equal opportunities employer and are committed to creating a diverse and inclusive workplace, where our people feel confident to be themselves, feel valued and are able to do their best work. We don’t just value differences and unique perspectives, we seek them out and we invite them in, because we know it will lead to better outcomes for everyone