Hybrid ETL Developer: SQL Server & SSIS Expert

Phillips & Cohen Associates; Wilmington (DE); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Phillips & Cohen Associates, LLC, a global leader in estate account management, seeks an experienced ETL Developer to design, build, and support data integration solutions using SQL Server and SSIS. The role involves collaborating with stakeholders, maintaining data quality, and automating processes in a hybrid work environment.

Candidates should have 3–5 years of ETL experience, strong SQL skills, and the ability to translate requirements into scalable technical solutions while delivering

Qualifications

• Three to five years of experience developing and supporting ETL and data integration solutions.
• Hands-on experience with SQL Server, T-SQL, and SQL Server Integration Services (SSIS).
• Experience developing and supporting relational databases, stored procedures, functions, views, and triggers.
• Experience troubleshooting production environments and performing root cause analysis.
• Strong understanding of data validation, reconciliation, and data quality best practices.
• Ability to gather and interpret business requirements and translate them into technical solutions.
• Strong analytical, problem-solving, and organizational skills.
• Excellent written and verbal communication skills.

Responsibilities

• Design, develop, test, deploy, and maintain ETL processes using SSIS.
• Develop, optimize, and support SQL queries, stored procedures, views, functions, and database objects.
• Build and maintain data integration processes supporting inbound and outbound data movement across multiple systems and platforms.
• Analyze business requirements and translate them into reliable, scalable technical solutions.
• Monitor, troubleshoot, and resolve production issues, ETL failures, and data integrity concerns.
• Create and maintain technical documentation including data mappings, process flows, and operational procedures.
• Collaborate with internal stakeholders and clients to gather requirements, communicate solutions, and ensure successful delivery.
• Support data validation, reconciliation, reporting, and continuous process improvement initiatives.
• Identify opportunities to automate manual processes and improve operational efficiency.

Skills

ETL development

SQL Server

SSIS

Data integration

Root cause analysis

Data validation

Requirements gathering

Communication skills

Analytical thinking

Tools

SSRS

Python

PowerShell

REST APIs

FTP/SFTP automation

Job description

Phillips & Cohen Associates, LLC, a global leader in estate account management, seeks an experienced ETL Developer to design, build, and support data integration solutions using SQL Server and SSIS. The role involves collaborating with stakeholders, maintaining data quality, and automating processes in a hybrid work environment.

Candidates should have 3–5 years of ETL experience, strong SQL skills, and the ability to translate requirements into scalable technical solutions while delivering