Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Data Operations Business Analyst role.
Rezi rewrites your resume against Castleton Commodities International's job description. Free.
Tailor your resume to this Data Operations Business Analyst role.
Rezi rewrites your resume against Castleton Commodities International's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data Operations Business Analyst posting at Castleton Commodities International — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data Operations Business Analyst posting at Castleton Commodities International — free, in seconds.
About the Role
This role leads the onshore transformation of Data Operations from manual, intervention-led work to an automated, controlled, and workflow-driven operating model. It involves clearing the current reference data backlog, identifying root causes, control gaps, and automation opportunities, and translating these into Data Operations requirements. The role combines business analysis with day-to-day Data Operations tasks.
Responsibilities
- Provide trade support across ETRM systems.
- Maintain the Exchange Limits View (ELV) and flag breaches and near-breaches to Compliance.
- Reconcile ETRM counterparty, strategy, and reference data against master data, working with the MDM team to resolve breaks.
- Work with business stakeholders and technology teams to test and embed solutions, confirming each change removes the underlying issue.
- Translate recurring issues into Data Operations requirements for MDM, workflow, integration, and controls, with clear acceptance criteria.
- Clear the reference data backlog, including unmapped trades, ETRM reference data gaps, and incorrect expiry dates.
- Use SQL and data profiling to investigate issues, find recurring patterns, and determine root causes.
- Document mappings, business rules, data definitions, process flows, and source-to-target requirements.
- Design and maintain EBX approval workflows and ServiceNow intake for master data change requests.
- Define SLAs and runbooks for repeatable EBX updates to run offshore to a consistent standard.
- Resolve exceptions escalated by the offshore team and the business.
- Own the trade failure log end-to-end in ServiceNow: ticket, categorise, assign, and close every failure, trace each to its origin, drive upstream fixes with IT and the trading desks, and report volumes, root-cause trends, and resolution times.
- Track exceptions and Data Operations KPIs, and use the evidence to prioritise the transformation roadmap.
Requirements
- 3+ years experience in commodities, energy trading, or financial services, with practical ETRM/CTRM knowledge.
- Strong SQL and data analysis skills, with the ability to work through complex datasets independently.
- Solid understanding of data mapping, reference and master data, data quality, and control concepts.
- Working knowledge of relational data models, data lineage, and system-to-system data flows.
- Experience turning operational problems into structured requirements and acceptance criteria.
- Able to bridge operational, business, and technical teams, with a practical continuous-improvement mindset.
Skills
- SQL
- Data analysis
- Data mapping
- Reference data
- Master data
- Data quality
- Control concepts
- Relational data models
- Data lineage
- System-to-system data flows
- ETRM/CTRM
- MDM platforms
- EBX
- ServiceNow
- Data catalog tools
- Data quality tools
- Atlan
- Monte Carlo
- APIs
- System integration
- Python
- Exchange-traded product reference data
- Contract specifications
- Expiry calendars
Location
- London
Work Type
- Onshore
- Full-time
Experience Level
- 3+ years