Avatar for Programmers.io
Your Extended Team

ETRM Data Architect

Posted: 2 weeks ago
Job Location
Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed
Skills
SQL
Excel
Endur
SolArc RightAngle

About the job

We are seeking an experienced ETRM Data Architect with strong Energy & Commodity Trading domain expertise to support a strategic business process, application rationalization, and data transformation program.

The role requires deep knowledge of SolArc RightAngle, Endur, and COTS trading platforms, combined with expertise in ETRM data architecture, trade lifecycle processes, data strategy, data governance, data quality, metadata, and data products.

The Data Architect will initially focus on functional debt analysis, trade lifecycle/process mapping, and application rationalization, followed by data strategy, Gold Data Product requirements, governance, data quality, and future-state architecture.

Required Experience & Qualifications

  • 7–10+ years of experience in ETRM business analysis, data architecture, data strategy, or trading technology transformation.
  • Strong functional and data knowledge of SolArc RightAngle and/or Endur, with familiarity across other commodity trading platforms.
  • Strong understanding of Energy & Commodity Trading processes including:
  • Trade capture and lifecycle management
  • Scheduling and logistics
  • Terminal operations
  • Inventory and blending
  • Freight
  • Risk, exposure, and P&L
  • Settlements and working capital
  • Demonstrated experience mapping end-to-end trade lifecycles and aligning applications, interfaces, APIs, and data flows to business processes.
  • Experience with functional debt assessment, application rationalization, consolidation, and decommissioning analysis.
  • Strong experience in data architecture, data strategy, governance, data quality, metadata, lineage, and data product definition.
  • Ability to define data grain, structures, entities, business rules, ownership, stewardship, data quality, and consumption requirements.
  • Experience conducting workshops and obtaining business validation/sign-off on process, data, and architecture recommendations.
  • Strong analytical, stakeholder-management, facilitation, documentation, and executive communication skills.

Technical & Methodology Skills

ETRM / Enterprise Systems

  • SolArc RightAngle
  • Endur
  • SAP
  • COTS Energy & Commodity Trading platforms

Data & Analytics

  • SQL
  • Excel
  • Power BI / Tableau
  • Databricks
  • Unity Catalog
  • Collibra
  • MDM and data-quality/profiling tools
  • Data modeling and metadata-management tools

Process Modeling

  • BPMN 2.0
  • SIPOC
  • Swimlane diagrams
  • Value-stream mapping
  • Current-state / future-state process modeling

Delivery & Collaboration Tools

  • Azure DevOps
  • Jira / Confluence
  • SharePoint
  • Visio
  • Lucidchart / Miro
  • ARIS / Signavio

Key Competencies

The successful candidate should demonstrate:

  • ETRM functional and data architecture expertise
  • Strong understanding of commodity trading data and lifecycle
  • Application-to-process and application-to-data mapping
  • Data architecture and target-state design
  • Application rationalization and functional debt analysis
  • Data governance, quality, metadata, and lineage
  • Gold Data Product requirements definition
  • Strong workshop facilitation and stakeholder management
  • Ability to translate complex business and technical findings into clear, actionable recommendation

Similar Jobs

Allston Yale company logo
Allston Yale
Turning data complexity into strategic clarity for $200M–$1B businesses