Data Operations Analyst (ETRM, MDM & Automation)

Castleton Commodities International, LLC; Greater London; Ibrido; GBP 65.000 - 90.000; Tempo pieno

Descrizione del lavoro

Castleton Commodities International, LLC seeks a Data Operations Business Analyst to move data work toward automated, controlled processes in London. You will clear backlogs, map reference data, and design data workflows, while supporting ETRM systems and reconciliation with MDM teams.

The role blends business analysis with data operations tasks, requiring strong SQL, data profiling and collaboration across stakeholders, IT and offshore teams. London posting.

Competenze

• 3+ years experience in commodities, energy trading or financial services.
• Strong SQL and data analysis skills with handling large datasets.
• Experience turning operational issues into structured requirements and acceptance criteria.

Mansioni

• Provide trade support across ETRM systems, monitor exchange limits and flag breaches.
• Reconcile ETRM data against master data and work with MDM to resolve breaks.
• Test and embed solutions with business and technology teams; define acceptance criteria.
• Clear reference data backlog including unmapped trades and expiry dates.
• Document mappings, rules, data definitions, and source-to-target requirements.
• Own trade failure log in ServiceNow end to end; track root causes and KPIs.

Conoscenze

SQL

Data analysis

Data mapping

Master data

Data quality

ETRM knowledge

Strumenti

EBX

ServiceNow

Atlan

Monte Carlo

APIs

Python

Descrizione del lavoro

Castleton Commodities International, LLC seeks a Data Operations Business Analyst to move data work toward automated, controlled processes in London. You will clear backlogs, map reference data, and design data workflows, while supporting ETRM systems and reconciliation with MDM teams.

The role blends business analysis with data operations tasks, requiring strong SQL, data profiling and collaboration across stakeholders, IT and offshore teams. London posting.