ETRM Data Architect

Programmers.io; United States; On-site; USD 140,000 - 190,000; Full time

Job summary

Programmers is seeking an experienced ETRM Data Architect to lead data architecture, governance, and strategy for a strategic data transformation program. The role focuses on functional debt analysis, trade-lifecycle mapping, and application rationalization, with later emphasis on data strategy and governance for Gold Data products.

Responsibilities include modeling current and future-state processes, defining data ownership, and partnering with Trading and IT stakeholders.

Qualifications

• 7-10+ years of experience in ETRM data architecture, governance, and trading technology transformation.
• Strong knowledge of SolArc RightAngle and Endur, with familiarity across other trading platforms.
• Experience mapping end-to-end trade lifecycles and aligning data flows to business processes.
• Ability to define data grain, structures, entities, rules, ownership, stewardship, and data quality.
• Experience with data governance frameworks, policies, and controls.

Responsibilities

• Map the end-to-end commodity trade lifecycle across systems and processes.
• Overlay RightAngle, Endur, SAP and other trading applications against business processes to identify overlaps and gaps.
• Develop current-state and future-state process models using BPMN 2.0 and related techniques.
• Support application rationalization, consolidation, and decommissioning efforts.
• Define data strategy, governance, and metadata requirements for Gold Data Products.
• Lead workshops with stakeholders and facilitate validation and sign-off of recommendations.

Skills

ETRM data architecture

Data governance

Data quality

Metadata

Data products

Stakeholder management

Process modeling

Tools

SolArc RightAngle

Endur

SAP

Databricks

Unity Catalog

Collibra

MDM tools

Power BI

Tableau

Azure DevOps

Jira/Confluence

SharePoint

Job description

Job Description: ETRM Data Architect

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.

The role is responsible for analysis, architecture, documentation, facilitation, and recommendations.Final business and technology decisions remain with the client.

Key Responsibilities

ETRM Process & Application Architecture

• Map the end-to-end commodity trade lifecycle in a system-agnostic manner across trade capture, scheduling, logistics, terminal operations, inventory, blending, freight, risk/exposure, P&L, settlements, and working capital.
• Overlay RightAngle, Endur, SAP, and other trading applications against business processes to identify:
  • Functional overlaps and duplication
  • Sequential or complementary workflows
  • Manual workarounds and functional debt
  • Application, interface, and data dependencies
• Develop current-state and future-state process models using BPMN 2.0, SIPOC, swimlanes, value-stream mapping, and process decomposition.
• Evaluate overlapping business capabilities and provide inputs to application rationalization, consolidation, and decommissioning.
• Develop actionable recommendations defining what should consolidate, what can be decommissioned, where capabilities and data should reside, and the proposed future-state process.
• Identify quick wins, dependencies, risks, sequencing, and transition considerations.
• Facilitate business review, validation, and sign-off of process and application recommendations.

ETRM Data Strategy & Architecture

• Assess the current-state data landscape across RightAngle, Endur, SAP, COTS trading platforms, interfaces, reporting platforms, and downstream applications.
• Support development of the target-state ETRM data strategy and architecture aligned to business processes and application rationalization.
• Define business and technical data requirements including:
  • Data domains and entities
  • Data grain and structure
  • Business definitions and rules
  • Data ownership and stewardship
  • Source-to-target data flows
  • Interfaces, lineage, and downstream consumption
• Identify data duplication, reconciliation gaps, quality issues, inconsistent transformations, and unclear ownership.
• Translate application rationalization and future-state process decisions into actionable data architecture requirements and roadmap inputs.

Gold Data Products

• Lead/support requirements gathering for Gold Data Products, working with Data/AI teams and Trading business stakeholders.
• Define:
  • Business purpose and consumers
  • Source systems and data scope
  • Data entities, attributes, and grain
  • Business rules and calculations
  • Data quality and reconciliation requirements
  • Refresh/latency expectations
  • Ownership and stewardship
  • Metadata and lineage
  • Security, sensitivity, and access requirements
• Ensure data products support relevant trading, operations, risk, finance, reporting, and analytical use cases.
• Support multiple Gold Data Product domains as program priorities evolve.

Data Governance, Quality & Metadata

• Support development and adoption of data governance frameworks, policies, standards, and controls.
• Define critical data elements, ownership, stewardship, business definitions, and quality expectations.
• Support data profiling and validation using SQL, Excel, Power BI, Tableau, or approved data-quality tools.
• Define data-quality rules, KPIs, thresholds, remediation tracking, and governance dashboards.
• Support metadata, business glossary, lineage, and catalog population and maintenance.
• Work with platforms and tools such as Databricks, Unity Catalog, Collibra, MDM solutions, and data modeling/profiling tools.
• Support classification of data sensitivity and definition of appropriate environment access and handling requirements.

Stakeholder & Program Support

• Facilitate workshops with Trading, Scheduling, Logistics, Risk, Finance, Operations, Data, and Technology stakeholders.
• Conduct stakeholder interviews, gap analysis, root-cause analysis, duplication assessment, and RACI development.
• Maintain traceability across business processes, requirements, applications, interfaces, data elements, and data products.
• Present findings, architecture options, risks, and recommendations to client stakeholders for validation and decision.
• Review change-management materials for process, application, operational, and data impacts.
• Support milestone tracking, PMO reporting, workstream dependencies, and established governance forums.
• Maintain requirements and deliverables in Azure DevOps (ADO), Jira, Confluence, SharePoint, and other approved repositories.
• Leverage AI-assisted tools, where approved, to accelerate analysis and documentation, with all outputs validated by relevant business and technology SMEs.

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