Senior Data Integration Developer

Talan

Houston (TX)

Hybrid

USD 120,000 - 165,000

Full time

34 hours ago
Be an early applicant
Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

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 an international group that supports its clients in their end-to-end Data & AI transformation by combining management consulting with technological expertise.

With over 6,000 employees across five continents, we accelerate our clients' transformations through long-term partnerships, creating measurable and sustainable impact.

Our value proposition is built on a structured innovation ecosystem: 2,500 Data & AI experts, proprietary solutions built on advanced models, and an applied research, experimental development, and innovation laboratory.

Talan is an international group that supports its clients in their end-to-end Data & AI transformation by combining management consulting with technological expertise.

With over 6,000 employees across five continents, we accelerate our clients' transformations through long-term partnerships, creating measurable and sustainable impact.

Our value proposition is built on a structured innovation ecosystem: 2,500 Data & AI experts, proprietary solutions built on advanced models, and an applied research, experimental development, and innovation laboratory.

In Americas, our multidisciplinary teams bring over 30 years of experience helping business leaders across key industries achieve measurable performance and strong ROI, designing, building, and scaling solutions that enable companies to grow more efficiently.

Job Description

Location: Houston (Hybrid – at least 3 days onsite/week)

Visa Sponsorship: We offer sponsorship under specific treaty-based U.S. work visas, including TN and E-2 (for eligible Canadian, Mexican, and French citizens). We do not support or transfer other visa types (e.g., H-1B).

We are looking for a Senior Data Integration Developer to support a business-critical Energy Trading and Risk Management environment for one of our key energy clients

The role sits within a small technical team supporting FIS Aligne, a legacy on-premise ETRM platform, and its broader data ecosystem. The successful candidate will take significant ownership of the platform's integrations, data pipelines, databases, and downstream applications.

The environment supports approximately 300+ data pipelines, 150+ reports and dashboards, 4–6 custom applications, and 250 business users across Front Office, Middle Office, Market Risk, Settlements, and other operational teams.

Key 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 continues its migration toward its future trading platform.
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.
Nice to have
  • Experience within energy trading, commodities, or ETRM environments.
  • Understanding of concepts such as P&L, positions, trade types, market data, pricing data, and front-to-back trading workflows.
  • Experience with FIS Aligne is highly desirable but not required.
  • Experience with other ETRM platforms such as Openlink / Endur is also relevant.
  • DBA / database administration experience is a strong plus.
Company’s Benefits

At Talan, we invest in our employees' well-being and empower them with benefits, including:

  • USD $120000 - US$165000
  • 401(k) retirement plan with company matching
  • 15 days of paid vacation per year at hire and up to 27 according to seniority (annual untaken vacation days are cashed out)
  • 8 paid holidays + 5 sick days + 2 personal days per year
  • Company health, dental, and vision insurance plans + FSA
  • Voluntary STD and LTD
  • Commuter/transit benefits

All your information will be kept confidential according to EEO guidelines.

Get your free, confidential resume review.
or drag and drop your file here.
Similar jobs

Similar jobs worth comparing

Senior Data Integration Developer
Senior Data Integration Developer

Socket.dev • Houston (TX)

Hybrid
USD 120,000 - 165,000
Competitive salary USD 120000-165000
401(k) retirement plan
Vacation days 15–27 per year
+1
Senior Data Integration Developer
Senior Data Integration Developer

Talan Group • Houston (TX), Northern (KY)

On-site
USD 120,000 - 165,000
USD $120000- US$165000 salary range
401(k) retirement plan with company 8%
Paid vacation 15 days + 27 with senior
+3
Aligne Specialist - Business Analyst - Power/Energy
Aligne Specialist - Business Analyst - Power/Energy

Talan • Houston (TX)

On-site
USD 120,000 - 150,000
Competitive USD salary 120000-150000
401(k) retirement plan with companying
Paid vacation 15 days + up to 27
+3
Senior Software Engineer C# - Pretrade
Senior Software Engineer C# - Pretrade

Talan Group • Houston (TX)

Hybrid
USD 100,000 - 140,000
401(k) retirement plan with company matching
15 days of paid vacation per year, increasing with seniority
Comprehensive health, dental, and vision insurance
Trade Control / Back Office – Senior Business Analyst
Trade Control / Back Office – Senior Business Analyst

Talan • New York (NY)

Hybrid
USD 110,000 - 170,000
401(k) retirement plan
15-27 days paid vacation
Health, dental, and vision insurance
Trade Control / Back Office – Senior Business Analyst
Trade Control / Back Office – Senior Business Analyst

Talan Group • New York (NY)

Hybrid
USD 110,000 - 170,000
401(k) retirement plan with company matching
15 days of paid vacation per year
Company health, dental, and vision insurance plans
IT Support Front Office Trading - Fixed Incomes and Cash Applications
IT Support Front Office Trading - Fixed Incomes and Cash Applications

Talan Group • New York (NY)

Hybrid
USD 90,000 - 110,000
401(k) retirement plan with company matching
15 days of paid vacation per year
8 paid holidays + 5 sick days + 2 personal days per year
+2
IT Support Front Office Trading - Fixed Incomes and Cash Desk
IT Support Front Office Trading - Fixed Incomes and Cash Desk

Talan Group • New York (NY)

Hybrid
USD 90,000 - 110,000
Annual salary range of US$90,000 - US$110,000
401(k) retirement plan with company matching
15-27 days of paid vacation per year
+3
Senior Software Engineer C# - Pretrade
Senior Software Engineer C# - Pretrade

Talan Group • Houston (TX)

Hybrid
USD 100,000 - 130,000
401(k) retirement plan with company matching
15 days of paid vacation per year at hire
8 paid holidays plus sick and personal days
+1
IT Support Front Office Trading - Fixed Incomes and Cash Applications
IT Support Front Office Trading - Fixed Incomes and Cash Applications

Talan Group • New York (NY)

Hybrid
USD 90,000 - 110,000
401(k) retirement plan with company matching
15 days of paid vacation per year
Company health, dental, and vision insurance plans