ETL Developer

Phillips & Cohen Associates Ltd. • Kirkland, QC

1d • Hybrid

About The Position

Phillips & Cohen Associates, LLC, a global leader in estate account management, is seeking an experienced ETL Developer. This role is responsible for developing, maintaining, and supporting data integration solutions that are crucial for business and client-facing operations. The position involves ETL development, database programming, production support, and process automation to ensure accurate, efficient, and timely data delivery. The ETL Developer will collaborate with business stakeholders, technical teams, and clients to translate requirements into scalable solutions and identify opportunities for performance improvement and process streamlining. The ideal candidate is a self-starter with strong SQL Server and SSIS experience, comfortable in a fast-paced environment, and enjoys tackling complex data challenges. This is a hybrid position requiring employees to reside in the United States or Canada and be within commuting distance of our offices in Wilmington, DE; Columbus, OH; or Montreal, Canada.

Requirements

• 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.
• Ability to work independently, manage multiple priorities, and deliver results in a fast-paced environment.

Nice To Haves

• Experience with SQL Server Reporting Services (SSRS).
• Experience with Python and/or PowerShell scripting.
• Knowledge of REST APIs and API-based integrations.
• Experience with FTP/SFTP file transfer automation.
• Familiarity with data warehousing concepts and large-volume data environments.
• Bachelor's degree in Computer Science, Information Systems, MIS, or a related field.

Responsibilities

• Design, develop, test, deploy, and maintain ETL processes using SQL Server Integration Services (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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level