Lead Data Analyst Commodities & Energy Trading - Front office Up to £115k + Bonus, Benefits Hybrid LDN

Lead Data Analyst Commodities & Energy Trading - Front office London, Hybrid up to £115k + Bonus, Benefits

Lead Data Analyst A leading global asset manager, responsible for assets under management across energy, precious metals, agriculture, FX, absolute return, multi-asset and specialist investment strategies. Is looking to add to their Data team, by hiring a Lead Data Analyst, coming from a financial services / Trading House background with knowledge around Risk, regulations, Compliance, Trade Surveillance etc

The Lead Data Analyst will join the Data Centre of Excellence, encompassing Data Analysis, Data Architecture, Data Intelligence and Machine Learning experts. This Data team helps the Investment Management House make use of their data to help make investment and risk decisions.

Lead Data Analyst role offers a unique opportunity to lead and shape the organisation's data strategy, processes, and governance. As a hands-on leader, you will mentor team members while overseeing the design and implementation of data capabilities that drive data-driven decision-making and transformative business outcomes. This role requires good leadership, technical expertise, and a collaborative mindset to align data initiatives with business objectives and ensure the team delivers high-quality results.

As a Lead Data analyst you will be responsible for proactively overseeing the design and implementation of data capabilities to create P&L impacting value for the Trading business. Specifically within compliance, understanding the data needed from the business to make decisions, bridging the gap between the Business & Data technical experts.

The salary on offer for this Lead Data Analyst Role is up to £115,000 + Bonus and Benefits package.

The company works a hybrid model, with 3 days per week in the office, close to major tube stations, including Liverpool Street.

As a Lead Data Analyst, you will:

• Analysing Risk data sourcing, how it flows and is housed in the organisation. You will map how to acquire data from primary and secondary sources and maintain data systems.
• The migration of the legacy data warehouse to the strategic data platform.
• Identifying, collecting and migrating data to and from a range of systems into the central Data Platform, working closely with the Data Management Team.
• Analysis of normalised transactional data and analytic data sources.
• Analysis of semi-structured and file-based data extracts.
• Data modelling to transform operational data into analytic/reporting structures such as Kimball-style multi-dimensional models.

Strong SQL, Sigma, PowerBI, Matilion, DBT, Python

Essential Skills for the Lead Data Analyst:

• Proven Data Analyst experience of at least 5 years, within a Financial Services environment, with particular emphasis on Risk or cross asset derivatives areas.
• Data modelling, cleansing and enrichment, with experience in conceptual, logical and physical data modelling and data cleansing and standardisation.
• Familiarity with Data warehousing and analytical data structures.
• Data quality assurance, validation and linkage.
• Experience creating BI models and dashboards, ideally in Power BI.
• Software development methodologies (Sprints/Agile) and project management software (Jira Software).
• SQL Server Database
• Databricks (or Alternative Modern Data Platform such as Snowflake)
• Knowledge of Orchestration Tools and processes (e.g SSIS, ODI, Informatica, Data Factory)

If you are interested in this Data Analyst role, please reply with your latest CV or send it to

Lead Data Analyst Commodities & Energy Trading - Front office London, Hybrid up to £115k + Bonus, Benefits