SQL Server/ETL/Python Developer

Donnelly & Moore Corporation; New York (NY); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Donnelly- is seeking a Hybrid SQL Server/Python/ETL Developer in the New York City area for a 12+ month engagement. Local candidates are required to be onsite and able to work in a hybrid environment with evolving priorities.

The role emphasizes ETL tools (SSIS/SSRS), SQL Server data flows, and Agile project management. The successful candidate will create and maintain BRDs, document data mappings, develop Power BI reports, and collaborate with cross-functional teams to deliver data-driven

Qualifications

• Hands-on experience in SQL Server, SSIS/SSRS and Python.
• Experience with ETL and data integration for real-time/file-based systems.
• Experience in Agile/Scrum environments and Azure DevOps.
• Ability to translate business needs into technical requirements.
• Strong documentation skills and test planning (UAT).

Responsibilities

• Participate in all stages of software development from design to implementation.
• Collaborate with Infrastructure teams to refresh, configure and manage test environments.
• Perform incident triage, remediation and root cause analysis; recommend preventive measures.
• Support AMI/data integration related projects and data flow improvements.
• Lead team discussions and manage stakeholder communications.

Skills

SQL Server

SSIS/SSRS

Python

Agile/Scrum

Power BI

UAT testing

BRD documentation

Data mapping

Stakeholder management

Azure DevOps

Software testing

Tools

Azure DevOps

Power BI

Job description

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