SSIS - SSRS Developer/ SSIS & SQL Server Support Engineer

SSIS - SSRS

Developer/ SSIS & SQL Server Support Engineer Cognizant - 3.8 Hartford, CT Job Details Full-time $90,000 - $109,000 a year 18 hours ago Benefits Paid parental leave Employee stock purchase plan Paid holidays Disability insurance Health insurance Dental insurance 401(k) Paid time off Parental leave Vision insurance Life insurance Qualifications IT service management Debugging Full Job Description •Unfortunately no visa transfer or sponsorship available for this role•

Job Title:

SSIS & SQL

Server Support Engineer Location:

Hybrid at Scottsdale, AZ or Hartford, CT Enhance, support, troubleshoot, and optimize SSIS packages and SQL Server ETL workflows, requiring strong skills in package debugging, logging, and performance tuning. Collaborate with development and data engineering teams to enhance ETL design, applying knowledge of data warehousing concepts. Diagnose and resolve production SQL Server issues , leveraging expertise in T‑SQL, stored procedures, indexing strategies, and execution plan analysis. Maintain SQL Agent jobs , ETL schedules, and data pipelines, using advanced knowledge of job orchestration and failure handling. Perform root‑cause analysis (RCA) for recurring or high‑impact incidents, applying deep understanding of SQL Server internals, query optimization, and SSIS architecture. Validate, reconcile, and correct data issues across staging, warehouse, and downstream systems, requiring strong analytical and data‑quality skills. Implement performance improvements and permanent fixes using SQL tuning, SSIS refactoring, and automation tools. Maintain operational documentation, runbooks, and SOPs, demonstrating strong communication and documentation skills. Support environment changes, deployments, and patching activities, requiring familiarity with ITIL processes (Incident, Problem, Change Management). Use monitoring tools (SQL Profiler, Extended Events, SolarWinds, or similar) to proactively identify performance issues and prevent outages.

Salary and Other Compensation:

The annual salary for this position is between $90-109K depending on experience and other qualifications of the successful candidate. This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits:

Cognizant offers the following benefits for this position, subject to applicable eligibility requirements: Medical/Dental/Vision/Life Insurance Paid holidays plus Paid Time Off 401(k) plan and contributions

Long-term/Short-term Disability Paid Parental Leave Employee Stock Purchase Plan Disclaimer:

The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.