Senior ETL & Data Integration Engineer (SSIS)

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

Benefits offered by this job

USD 120k-165k salary

401(k) retirement plan with company-m​

Paid vacation 15 days increasing with/

Paid holidays 8 + 5 sick + 2 personal

Health, dental, vision insurance

STD and LTD

Job summary

Talan seeks a Senior Data Integration Developer to own the ETL pipelines and data integration for an Energy Trading and Risk Management environment in Houston. The role focuses on FIS Aligne on-premise integration, SQL Server analytics, and downstream data warehouses supporting dashboards used by Front Office, Risk, and Settlements.

You will collaborate with business users to ingest market, pricing, weather, and transactional data, troubleshoot pipelines, and contribute Python-based automation

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.
• Experience with on-premise Microsoft technologies.
• Data warehousing, ingestion, database development, and production support.
• Strong troubleshooting, analytical, and database skills.

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 during migration to future trading platform.

Skills

ETL pipelines

SSIS

SQL Server

SQL

Data integration

Python

Education

Bachelor degree in Computer Science or related

Tools

FIS Aligne

Openlink/Endur

SQL Server

Job description

Talan seeks a Senior Data Integration Developer to own the ETL pipelines and data integration for an Energy Trading and Risk Management environment in Houston. The role focuses on FIS Aligne on-premise integration, SQL Server analytics, and downstream data warehouses supporting dashboards used by Front Office, Risk, and Settlements.

You will collaborate with business users to ingest market, pricing, weather, and transactional data, troubleshoot pipelines, and contribute Python-based automation