SQL Server/ETL/Python Developer

Our Utility Client in NYC is looking for a Hybrid SQL Server/Python/ETL Developer for a 12+month position. Must be local to come onsite for this role.

Technical Skills

Must Have

• Hands on experience in SQL Server Database, SSIS/SSRS and Python
• Manage multiple projects and competing priorities in fast-paced, changing environments, adapting as goals and needs evolve.
  
  

Build consensus under pressure through strong interpersonal and facilitation skills.

• Create comprehensive Business Requirements Documents (BRDs), manage requirements for complex data products, and translate business needs into clear technical requirements.
• Deliver high-quality results with strong attention to detail.
• Apply analytical and problem-solving skills to make data-driven decisions and support business collaboration.
• Manage stakeholder relationships and collaborate across functions and multidisciplinary teams while working independently.
• Develop test plans, test cases, and scripts for user acceptance testing (UAT).
• Communicate clearly in writing and verbally, explaining technical concepts to nontechnical stakeholders.
• Bring experience designing, managing, analyzing, testing, or improving software systems.
• Work within Scrum/Agile frameworks and organize tasks using a software ticketing system, preferably Azure DevOps.
• Create and analyze Power BI reports.
• Develop business process documentation and workflow artifacts.
  
  

Job Description

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.

#IND1