ETL Data Engineer - ETRM/SSRS

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.

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.