Senior Data Integration Engineer – Energy Trading

Talan; Houston (TX); Hybrid; USD 120,000 - 165,000; Full time

Benefits offered by this job

401(k) retirement plan with company  匹

Paid vacation and holidays

Health, dental, vision insurance

STD and LTD

Transit benefits

Job summary

Talan is seeking a Senior Data Integration Developer in Houston to support an Energy Trading and Risk Management environment. You will own platform integrations, data pipelines, databases, and downstream applications within a small technical team.

The role covers 300+ data pipelines, 150+ reports/dashboards, 4–6 custom apps, and 250 business users across Front Office and Risk teams. Sponsor visas under TN/E-2 for eligible citizens.

Qualifications

• Bachelor degree in Computer science, Engineering, Finance or Quantitative finance.
• 8+ years of relevant development/data integration experience, ideally in a senior capacity.
• Strong expertise in Microsoft SQL Server, SQL, SSIS, ETL, and data integration.
• Strong experience working with on-premise Microsoft technologies.
• Experience with data warehousing, data ingestion, database development, and production support.
• Python development experience.
• Strong troubleshooting, analytical, and database skills.
• Ability to work independently and take ownership within a small technical team.
• Strong communication skills and ability to interact directly with business stakeholders.

Responsibilities

• Design, develop, maintain, and troubleshoot ETL and data integration pipelines.
• Build and support SSIS / SQL Server Integration Services solutions in an on-premise Microsoft environment.
• Develop and optimize SQL queries, stored procedures, views, and database processes.
• Support data ingestion from market, pricing, weather, broker, ISO, trade, and transactional data sources.
• Maintain downstream data warehouses supporting historical reporting, KPIs, dashboards, and analytics.
• Investigate production issues, failed data pipelines, and data discrepancies.
• Support integrations between FIS Aligne and upstream/downstream systems.
• Work directly with business users across trading, risk, settlements, and operations.
• Contribute to Python-based data processing, automation, and integration solutions.
• Take ownership of critical systems while the organization migrates toward its future trading platform.

Skills

ETL

SSIS

SQL Server

Python

Data integration

Data warehousing

Troubleshooting

Communication

Education

Bachelor's degree

Tools

Microsoft SQL Server

SSIS

FIS Aligne

OpenLink / Endur

Job description

Talan is seeking a Senior Data Integration Developer in Houston to support an Energy Trading and Risk Management environment. You will own platform integrations, data pipelines, databases, and downstream applications within a small technical team.

The role covers 300+ data pipelines, 150+ reports/dashboards, 4–6 custom apps, and 250 business users across Front Office and Risk teams. Sponsor visas under TN/E-2 for eligible citizens.