Senior Developer IT

Seeking a senior-level SQL Server and ETL developer with deep expertise in SQL Server 2022/2025 advanced T-SQL SSIS data integration and analytics. The role owns client data onboarding master data management ETL development production support and data quality. Candidates with practical AI skills to automate data ingestion validation monitoring and accelerate data analysis and insight generation will be highly preferred. 
 
Detailed Responsibilities 
    Lead client onboarding and implementation projects. 
    Design develop maintain and support SSIS packages. 
    Manage daily weekly monthly quarterly and 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 implementation activities and after-hours support as required.

Qualifications :

    6 years Microsoft SQL Server experience particularly with Microsoft SQL Server 2019 or later
    5 years hands-on SSIS development. 
    Advanced T-SQL skills including stored procedures views functions reconciliation and data analysis. 
    Experience supporting enterprise ETL and operational data environments. 
    Strong problem-solving communication documentation and analytical skills. 
    Must be authorized to work in the United States on a full-time basis for any employer
    Bachelors degree in computer science engineering mathematics information technology Business Administration required Or masters degree in computer science computer application or Business Administration required

    Healthcare payer claims eligibility provider or membership data experience. 
    Power BI and Tableau experience. 
    Advanced T-SQL and SSIS experience. 
    Data warehouse and master data management concepts. 
    Current AI usage: data summarization intelligent fax processing automated task creation software development productivity. 
    Drive expansion of AI-enabled data operations. 
    Identify ETL automation opportunities. 
    Implement AI-assisted validation reconciliation monitoring onboarding and analytics. 
    Leverage Microsoft Copilot GitHub Copilot Cursor AI Claude AI ChatGPT/OpenAI and related platforms. 

    Recommend measurable AI initiatives. 
    Reduce manual effort through automation. 
    Accelerate analytics and business insight generation. 
    Improve data quality and operational efficiency using AI-assisted workflows. 

    SQL Server 2022/2025 
    SSIS 
    Power BI / Tableau 
    SSRS/SSAS (nice-to-have)
    On-Prem Microsoft Data Platform 

Additional Information :

Compensation Disclosure

The base salary range for this position is $130000 - $150000 annually. This represents the base pay range that we reasonably expect to offer for this position.

Final compensation will be determined based on a variety of factors including but not limited to the candidates experience education skillset and location.

In addition to base pay this role may be eligible for performance-based bonuses incentive pay or commissions which are not included in the listed base salary range.

WNS complies with all applicable federal state and local pay transparency laws including those in California Colorado New York Washington and Illinois.

Note: For complete compensation information please refer to the job posting on our official careers page.

Benefits Overview

Our benefits package includes (but is not limited to):

- Medical dental and vision insurance

- Paid time off (PTO) holidays and sick leave

- 401(k) with company match or other retirement plan

- Life and AD&D Insurance

- Employee Assistance Program

Equal Opportunity Employer Statement

WNS is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

All qualified applicants will receive consideration for employment without regard to race color religion sex (including pregnancy childbirth or related medical conditions) sexual orientation gender identity or expression national origin age disability genetic information veteran status or any other status protected under federal state or local law.

We also provide reasonable accommodations to individuals with disabilities and for sincerely held religious beliefs in all aspects of employment including the application process.

How to Apply

Please submit your application including a resume and optional cover letter through our careers page or email to
 

Remote Work :

Yes

Employment Type :

Full-time