> Markdown version of [/jobs/ext/3368172-etrm-data-engineer](https://www.wearedevelopers.com/jobs/ext/3368172-etrm-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETRM Data Engineer

- **Company:** Resourcesoft, Inc.
- **Location:** Houston, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Query Performance, Application Programming Interfaces (APIs), Data Integration, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Database Design, Database Queries, Dimensional Modeling, Microsoft SQL Server, NumPy, Oracle Databases, Oracle (Applications), Power BI, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, Systems Integration, Enterprise Data Management, Scripting, Enterprise Software Applications, Pandas, Restful APIs
- **Published:** September 2, 2026
- **Apply:** https://www.dice.com/job-detail/865f42f4-28ca-47c1-9064-ccccee7bde3e

## About the Role

* 6 or more years of experience in enterprise data engineering and ETL pipeline development.
 * Proficiency in Energy Trading and Risk Management (ETRM) platforms and commodity trade lifecycle data.
 * Experience with Microsoft SQL Server database design, advanced stored procedures, and SSIS packages.
 * Experience in Python scripting for data transformation utilizing Pandas, NumPy, and REST APIs.
 * Experience with Oracle database querying, cross-platform integration, and query performance optimization.
 * Experience in enterprise data warehousing, dimensional modeling, SSRS reporting, and Power BI dashboards.
 * Excellent verbal and written communication skills.

## Description

* Architect and maintain high-throughput ETL data pipelines integrating ETRM platforms with enterprise applications.
 * Develop custom Python scripts to automate complex data transformations, validation rules, and API connections.
 * Optimize enterprise SQL Server stored procedures, indexing schemes, and high-volume database queries.
 * Build and manage production-grade data integration packages utilizing SQL Server Integration Services (SSIS).
 * Extract, transform, and integrate energy trading datasets across heterogeneous Oracle and SQL Server environments.
 * Implement automated data quality validation frameworks and dimensional models for the enterprise data warehouse.
 * Deliver operational trade reporting solutions and interactive analytical dashboards using SSRS and Power BI.