SQL Server Integration Engineer

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

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).