• Location: New York NY
• Type: Perm
• Job #26710

Company Overview:
A leading employee benefits firm with over 35 years of experience, serving nearly 5,000 clients across the United States, is seeking a Senior Data Engineer to join their development team. This role focuses on building and integrating data pipelines and platforms to support the company's applications and business decisions.

Job Responsibilities:

• Lead the design, development, and evolution of end-to-end data pipelines, integrations, data models, and platform capabilities.
• Own production data systems and contribute to their availability, monitoring, incident response, root-cause analysis, and continuous improvement.
• Translate business and technical requirements into clear architecture, implementation plans, and incremental deliverables.
• Design and implement scalable ETL/ELT workflows that ingest, transform, validate, and deliver data from various sources.
• Define and improve standards for data quality, testing, documentation, lineage, observability, security, governance, and access control.
• Review architecture, technical designs, pull requests, and operational changes to identify risks and improve maintainability and performance.
• Lead the modernization of legacy data processes towards secure, automated, cloud-based solutions.
• Diagnose complex data, pipeline, performance, and reliability issues and drive both immediate mitigation and durable prevention.
• Optimize queries, storage, processing, and infrastructure for performance, scalability, and cost efficiency.
• Collaborate with various stakeholders to deliver trusted data solutions.
• Mentor junior and mid-level engineers through pairing, code reviews, technical guidance, documentation, and knowledge sharing.
• Evaluate emerging technologies and make recommendations that support the company's long-term data and engineering strategy.

Qualifications:

• Bachelor’s or Master’s degree in computer science, data engineering, information systems, mathematics, or a related field—or equivalent experience.
• 4+ years of professional experience in data engineering, data platform engineering, software engineering, or a related role.
• Demonstrated experience designing, building, deploying, and supporting production data pipelines.
• Advanced SQL skills, including complex joins, transformations, performance tuning, and data validation.
• Strong programming experience with Python or another language used for data processing and automation.
• Strong understanding of data modeling, relational databases, analytical warehouses, data lakes, and dimensional modeling.
• Experience with AWS or another major cloud platform, including cloud storage, compute, networking, monitoring, and access-control concepts.
• Experience implementing data quality checks, automated testing, observability, logging, alerting, and operational runbooks.
• Experience with Git, pull requests, CI/CD, infrastructure as code, and modern software development practices.
• Experience working with sensitive, confidential, regulated, or financial data and applying appropriate security controls.
• Ability to work in a hybrid work environment, with one day in the office.
• Authorized to work in the US without current or future sponsorship.

Compensation:
Salary: $110,000 – $130,000, Plus Bonus