SQL Server Integration Engineer

Job Title:- SQL Server Integration Engineer

Location:- New York, New York (Willing to take a ropes code challenge (not required for all roles - a lot of these are reserved for exclusive openings) Looking only local with local DL

proper LinkedIn with no single word update in resume

Hybrid NYC - MUST be local and able to interview on site.
Contract

Role Overview

Participates in all stages of software development, from research and design to programming, testing, and implementation. The role requires expertise in file-based and real-time system integration to support efficient data flow and operations; a strong background in ETL tools (SSIS/SSRS), Microsoft SQL Server, data flow, and data mapping; and the ability to adapt business processes to leverage technology solutions.

Key Responsibilities & Outcomes

Participate in all stages of software development, from research and design to programming, testing, and implementation.

Collaborate with the ConEd Infrastructure team to refresh, configure, and manage test environments.

Perform incident triage, remediation, and root cause analysis.

Recommend preventive measures, including HPI.

Manage environments for concurrent projects, incident and defect management, and corrective actions following major events.

Build strong business relationships, communicate effectively with stakeholders, and lead team discussions.

Qualifications & Requirements

Required:

Must be local to NYC and able to interview on-site.

Expertise in file-based and real-time system integration.

Strong background in ETL tools (SSIS/SSRS), Microsoft SQL Server, data flow, and data mapping.

Ability to adapt business processes to leverage technology solutions.

Strong documentation skills and the ability to learn new technologies quickly.

Experience with regression, SIT, SAT, and UAT testing.

Experience with Agile methodologies.

Preferred:

Utility project experience, particularly with Advanced Metering Infrastructure (AMI).

Recruiting Strategy

Target local Tri-State area candidates exclusively, as the hybrid schedule and mandatory on-site interview require a realistic commute to NYC.

Focus searches on integration-heavy data professionals who highlight Microsoft stack ETL tools (SSIS, SSRS) rather than just general database administrators.

Prioritize candidates who list enterprise testing phases (SIT, SAT, UAT) on their resumes, as this shows they understand full-lifecycle enterprise deployments.

Screen for communication and stakeholder management during the initial call; the candidate must be able to lead team discussions and build business relationships.

Look for backgrounds in highly regulated or complex infrastructure industries (utilities, telecom, energy) where incident triage and defect management are critical.