SQL Server Integration Engineer

SQL Server Integration Engineer - Hybrid NYC

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. Strong documentation skills and the ability to learn new technologies quickly are essential for project success. Responsibilities include collaborating with the ConEd Infrastructure team to refresh, configure, and manage test environments; performing incident triage, remediation, and root cause analysis; and recommending preventive measures, including HPI. Utility project experience, particularly with Advanced Metering Infrastructure (AMI), is preferred. Experience with regression, SIT, SAT, and UAT testing is required. The role also requires experience with Agile methodologies, managing environments for concurrent projects, incident and defect management, and corrective actions following major events. Candidates must build strong business relationships, communicate effectively with stakeholders, and lead team discussions.