Senior SQL Server & ETL Lead — AI-Driven DataOps

HealthHelp; Houston (TX); On-site; USD 120,000 - 135,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

PTO

401(k)

Job summary

WNS, a Capgemini company, seeks a senior SQL Server and ETL developer to own data onboarding, master data management, ETL development, and analytics initiatives. The role emphasizes SQL Server 2022/2025, SSIS, data integration, and production support in a healthcare-adjacent environment.

Ideal candidates bring practical AI skills to automate data ingestion, validation, monitoring and analytics, with strong T-SQL and data quality focus.

Qualifications

• 6+ years Microsoft SQL Server experience (2019 or later).
• 5+ years hands-on SSIS development.
• Advanced T-SQL skills: stored procedures, views, functions, reconciliation, and data analysis.
• Experience supporting enterprise ETL and operational data environments.
• Strong problem-solving, communication, documentation and analytical skills.

Responsibilities

• Lead client onboarding and implementation projects.
• Design, develop, maintain and support SSIS packages.
• Manage daily/weekly/monthly/quarterly/ad hoc data loads.
• Receive, validate, transform and reconcile client source files.
• Support master data integration and maintenance activities.
• Investigate and resolve data load failures, mapping issues, and data quality concerns.
• Develop SQL-based reports, extracts, and analytical datasets.
• Support Power BI and Tableau reporting initiatives.
• Create monitoring and operational support processes.
• Participate in production deployments and after-hours support as required.

Skills

SQL Server

SSIS

T-SQL

Data integration

Analytical skills

Education

Bachelor’s in Computer Science/Engineering or related field

Master’s in Computer Science/Business Administration

Tools

Power BI

Tableau

SSRS/SSAS

Job description

WNS, a Capgemini company, seeks a senior SQL Server and ETL developer to own data onboarding, master data management, ETL development, and analytics initiatives. The role emphasizes SQL Server 2022/2025, SSIS, data integration, and production support in a healthcare-adjacent environment.

Ideal candidates bring practical AI skills to automate data ingestion, validation, monitoring and analytics, with strong T-SQL and data quality focus.