ETL Data Engineer - ETRM/SSRS-Houston, TX

iSphere Global Pty Ltd; Houston (TX); Hybrid; USD 110,000 - 150,000; Full time

Job summary

iSphere is seeking an ETL Data Engineer to join a fast‑moving energy environment in Houston. You will own data integration, ETL processes, and reporting across trading, operations, and analytics platforms.

The role requires expert SQL Server and SSIS experience, Oracle data skills, and Python development for data pipelines and governance. Experience with ETRM/energy trading data is highly valued.

Qualifications

• Expert‑level Microsoft SQL Server experience including design, query optimization, performance tuning, stored procedures and SSIS.
• Strong experience developing and maintaining SSRS reports or comparable enterprise reporting solutions.
• Hands‑on Oracle experience including data extraction, integration, SQL development, and performance analysis.
• Strong Python development experience focused on ETL, data engineering, APIs, automation, and data transformation.
• Experience with Pandas, NumPy, and other data‑processing libraries.
• Experience designing and supporting data pipelines across multiple internal and external systems.
• Strong understanding of data warehousing, dimensional modeling, data quality, governance, and metadata management.
• Experience supporting ETRM platforms and energy trading related processes.
• Experience working with large datasets and data cleansing, reconciliation, and integration from multiple sources.
• Strong analytical, troubleshooting, documentation, and communication skills.

Responsibilities

• Build, improve, and support data flows between trading, operational, reporting, and analytical platforms.
• Design databases, tune queries, write stored procedures, and troubleshoot performance problems in ETL processes.
• Develop and maintain SSRS reports and other enterprise reporting solutions.
• Work with Oracle, Python, SSRS, Power BI/Tableau, and Power Platform tools to support data needs.
• Enable data pipelines across multiple systems and datasets including energy trading data.

Skills

SQL Server

SSIS

SSRS

Oracle

Python

ETL

Pandas

NumPy

Data pipelines

Data warehousing

ETRM

Energy trading

Big data

Data cleansing

Documentation

Communication

Tools

Power BI

Tableau

Power Apps

Power Automate

Job description

ETL Data Engineer – ETRM / SSRS

Houston, TX | Hybrid | Must Live in the Houston Area | 12+ Month Contract.

iSphere is looking for an ETL Data Engineer who knows their way around SQL Server, SSIS, Python, and ETRM data and can step into a fast-moving energy environment without needing six months to figure out how everything connects.

This is a hands‑on consulting role supporting a team that works heavily with data pipelines, data warehousing, reporting, and Energy Trading and Risk Management systems. You will be building, improving, and supporting the data flows that move information between trading, operational, reporting, and analytical platforms.

A strong Microsoft SQL Server and SSIS background is essential here. You should be comfortable designing databases, tuning queries, writing stored procedures, troubleshooting performance problems, and building ETL processes that can handle large volumes of data without becoming tomorrow morning's emergency.

You will also work with Oracle, Python, SSRS, Power BI or Tableau, and Microsoft Power Platform tools. The environment includes market data, pricing, forecasting, time‑series data, and other datasets tied to energy trading and risk, so experience in ETRM or commodity trading will make a big difference.

What We Need

• Expert‑level Microsoft SQL Server experience, including database design, query optimization, performance tuning, stored procedures, and SSIS
• Strong experience developing and maintaining SSRS reports or comparable enterprise reporting solutions
• Hands‑on Oracle experience, including data extraction, integration, SQL development, and performance analysis
• Strong Python development experience focused on ETL, data engineering, APIs, automation, and data transformation
• Experience with Pandas, NumPy, and other data‑processing libraries
• Experience designing and supporting data pipelines across multiple internal and external systems
• Strong understanding of data warehousing, dimensional modeling, data quality, governance, and metadata management
• Experience supporting ETRM platforms and understanding energy trading, scheduling, settlements, risk, or related market processes
• Experience working with large datasets and validating, cleansing, reconciling, and integrating data from multiple sources
• Strong analytical, troubleshooting, documentation, and communication skills

Experience with Power BI, Tableau, Power Apps, and Power Automate will also be useful, especially if you have used them to improve reporting, automate workflows, or give the business better access to the data.

Time‑series data, market data, pricing models, forecasting models, and commodity trading datasets are all big pluses.

This is a good fit for someone who likes getting into the weeds of a data problem and figuring out why the numbers do not tie before anyone starts blaming the report. You should be comfortable moving between SQL, ETL, Python, reporting, and business conversations and understand that in an energy environment, bad data can become an expensive problem pretty quickly.

If SQL Server, SSIS, Python, and ETRM data have been a major part of your world, this one should be worth a conversation.