SQL Server/ETL/Python Developer

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

Job summary

Donnelly & Moore Corporation in New York City seeks a Hybrid SQL Server/Python/ETL Developer for a 12+ month position. You will participate in data integration, build ETL pipelines, and support BI reporting in a fast-paced environment.

Candidates must be local to NYC and able to come onsite as needed. The role requires strong SQL Server, SSIS/SSRS, Python skills, experience with Power BI, and the ability to collaborate with stakeholders across teams.

Qualifications

• Hands on experience in SQL Server Database, SSIS/SSRS and Python
• Create BRDs and translate business needs into technical requirements
• Deliver high-quality results with attention to detail
• Apply analytical and problem-solving skills to data-driven decisions
• Manage stakeholder relationships and collaborate across functions
• Develop test plans, test cases, and UAT scripts
• Communicate clearly to nontechnical stakeholders
• Design, manage, analyze, test, or improve software systems
• Work within Scrum/Agile frameworks and use Azure DevOps
• Create and analyze Power BI reports
• Develop business process documentation and workflow artifacts

Responsibilities

• Participates in all stages of software development from research and design to programming, testing, and implementation.
• Support complex data products with ETL and integration across systems.
• Refresh, configure, and manage test environments; incident triage and root cause analysis.
• Recommend preventive measures and improvements; experience with AMI is a plus.
• Collaborate with cross-functional teams and lead discussions with stakeholders.
• Ensure robust documentation and knowledge transfer for projects.

Skills

SQL Server

Python

ETL

SSIS/SSRS

Power BI

Azure DevOps

Tools

SSIS/SSRS

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

• 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