ETRM Data Architect

Programmers.io; Houston (TX); On-site; USD 170,000 - 210,000; Full time

Job summary

Programmers.io is seeking an experienced ETRM Data Architect to support a strategic data transformation program in the energy trading domain. The role requires deep expertise in SolArc RightAngle, Endur, and other COTS trading platforms, with a strong emphasis on data architecture, governance, and product data requirements.

You will begin with debt analysis and lifecycle mapping, then drive data strategy, governance, and future-state architecture across the data landscape.

Qualifications

• 7–10+ years of experience in ETRM business analysis, data architecture, data strategy, or trading technology transformation.
• Experience with SolArc RightAngle and/or Endur; familiarity with other commodity trading platforms.
• Strong understanding of energy and commodity trading processes: trade capture, scheduling, logistics, terminals, inventory, risk, P&L, settlements.

Responsibilities

• Lead functional debt analysis and application rationalization efforts.
• Map trade lifecycles and align data flows to business processes.
• Define data grain, structures, ownership, stewardship, and data quality requirements.
• Facilitate workshops and obtain sign-off from stakeholders on recommendations.

Skills

ETRM expertise

Stakeholder management

Workshop facilitation

Data governance

Data quality

Data modeling

Tools

SolArc RightAngle

Endur

SAP

COTS Energy & Commodity Trading platforms

Job description

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
• 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

• 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
• Value-stream mapping
• Current-state / future-state process modeling

Delivery & Collaboration Tools

• SharePoint
• Visio
• ARIS / Signavio

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
• Strong workshop facilitation and stakeholder management
• Ability to translate complex business and technical findings into clear, actionable recommendation