Senior SQL & ETL Architect – AI-Driven Data Ops

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

Benefits offered by this job

Medical, dental, vision insurance

Paid time off

401(k) with company match

Life and AD&D Insurance

Employee Assistance Program

Job summary

WNS, part of Capgemini, seeks a senior SQL Server and ETL developer to own client data onboarding, master data management, ETL development and data analytics. Expertise in SQL Server 2022/2025, SSIS, and BI tooling is required to design, optimize, and support data integration pipelines.

Ideal candidates will automate data ingestion, validation, and monitoring, and contribute to AI-assisted data operations. This role includes production support and occasional after-hours coverage in a dynamic,

Qualifications

• 6+ years Microsoft SQL Server experience (2019+).
• 5+ years SSIS development experience.
• Advanced T-SQL, stored procedures, views and functions.
• Experience with enterprise ETL and data environments.
• Strong problem-solving, communication, and documentation skills.
• US work authorization for full-time employment.

Responsibilities

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

Skills

SQL Server

SSIS

T-SQL

Data quality

Analytical skills

Communication

Education

Bachelor's degree in CS/Engineering/IT

Master's degree in CS/IT/Business Administration

Tools

Power BI

Tableau

SSRS/SSAS

On-Prem Microsoft Data Platform

Job description

WNS, part of Capgemini, seeks a senior SQL Server and ETL developer to own client data onboarding, master data management, ETL development and data analytics. Expertise in SQL Server 2022/2025, SSIS, and BI tooling is required to design, optimize, and support data integration pipelines.

Ideal candidates will automate data ingestion, validation, and monitoring, and contribute to AI-assisted data operations. This role includes production support and occasional after-hours coverage in a dynamic,