Senior ETL Developer

Piper Companies is seeking a Senior ETL Developer to join a leading financial services and investment organization based in Wayne, PA. This role plays a critical part in building and optimizing data pipelines, enhancing data integration workflows, and ensuring consistent delivery across onshore and offshore teams.

RESPONSIBILITIES:

• Design, build, and optimize ETL/ELT pipelines to support analytics and operational data needs

• Translate business requirements into technical specifications and scalable data solutions

• Develop and improve data models to support reporting and downstream systems

• Collaborate with architects, analysts, and offshore engineers to ensure consistent delivery and adherence to standards

• Conduct code reviews and enforce best practices across data development work

• Troubleshoot performance issues, data bottlenecks, and pipeline failures

• Maintain documentation for data workflows, processes, and development standards

QUALIFICATIONS:

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, or related field

• 5+ years of hands‑on ETL/ELT development experience

• Strong SQL skills and experience with tools like DBT, Talend, Matillion, Informatica, or Python-based ETL

• Experience working with cloud data platforms such as Snowflake, Azure Synapse, or Redshift

• Knowledge of CI/CD processes and version control (Git or similar)

• Prior experience collaborating with or guiding offshore teams

• Strong communication, problem‑solving skills, and ability to work across technical and business groups

COMPENSATION:

• Salary Range: $100,000 – $140,000

• Hybrid Schedule: 4 days onsite per week in Wayne, PA

• Comprehensive Benefits: Medical, Dental, Vision, 401(k), PTO, Sick Leave as required by law, and Holidays

This job opens for applications on (02/25/2026). Applications will be accepted for at least 30 days from the posting date.

Keywords: Senior ETL Developer, ETL, ELT, SQL, Data Engineering, Data Pipelines, Cloud Data, Snowflake, Azure Synapse, Redshift, DBT, Talend, Matillion, Informatica, Git, CI/CD, Data Modeling, Data Warehousing, Offshore Collaboration, Financial Services Data

#LI-LR1 #LI-HYBRID