Senior Data Engineer - Core Data

Thank you for considering Progyny!

Data is the lifeblood of healthcare, and Progyny as a company depends on the accurate, timely, and secure management of data to achieve our company mission at the highest level. This role will be directly responsible for implementing the data foundation for a modern, event-driven platform leveraging best in class components for core data persistence, streaming, transformation, and integrated analytics leveraging machine learning. As data systems are constantly evolving, this role will also be expected to help challenge and mature the existing patterns, practices and toolchains for the Data engineering discipline at Progyny; as such, a successful candidates should be motivated by a desire to help optimize and shape their environment, not simply follow the established status quo.  

Success in this role is measured by the following: 

• Development of data pipelines that meet or exceed our quality goals 

• Ability to leverage your knowledge of various data patterns/frameworks/tools to help guide implementation to best possible solutions 

• Staying curious and ensuring currency in a fast-evolving technology discipline while also supporting growth/maturity of your peers & stakeholders 

• Working “without a net”: navigating past ambiguity through the application of your judgment and experience 

• Ability to find pragmatic options to tactical vs. strategic implementation dilemmas 

What you’ll do…

• Working with technology stakeholders to design and implement numerous data transformation pipelines, with a focus on all functional/non-functional quality goals 

• Design and implementation of test, monitoring, and observability strategies for data systems and processes 

• Support for outage incident response and return-to-service activities for data systems in your purview 

• Supporting evaluation of related tools, frameworks and dev/test/deploy patterns as needed to evolve the platform capabilities for data support 

About you…

• 5+ years of relevant experience building and maintaining production ETL pipelines and demonstrated understanding of different loading patterns and practices, with an ability to discuss tradeoffs between them 

• Bachelor’s degree in Computer Science, Information Systems, or similar field of study  

• 5+ years of consistent, professional SQL development experience 

• 2+ years of Python development experience with focus on Data frame manipulation (preferably with Pandas or Polars) 

• 3+  years of experience with well-known data pipeline/transform tools / platforms (DAG-based options like Dagster, Airflow, Prefect, etc.) 

• Experience with data transformation models (ex: DBT) 

• Experience with data access patterns (caching, partitioning, sharding) 

• Familiarity with data modelling best practices / data structures 

• Experience with data access optimization (ex: indexing) 

• Working experience with data serialization models like Apache Arrow desirable 

• Working experience with JSON-based storage models (example: FHIR) desired 

• Strong communication skills  

Please note: Progyny is unable to provide visa sponsorship for this position. Candidates must be authorized to work in United States without the need for sponsorship, now or in the future.  

About Progyny:   

Progyny (Nasdaq: PGNY) is a global leader in women’s health and family building solutions, trusted by the nation’s leading employers, health plans and benefit purchasers. We envision a world where everyone can realize dreams of family and ideal health. Our outcomes prove that comprehensive, inclusive and intentionally designed solutions simultaneously benefit employers, patients and physicians. 

Our benefits solution empowers patients with concierge support, coaching, education, and digital tools; provides access to a premier network of fertility and women's health specialists who use the latest science and technologies; drives optimal clinical outcomes; and reduces healthcare costs.  

Our mission is to empower healthier, supported journeys through transformative fertility, family building and women’s health benefits.  

Headquartered in New York City, Progyny has been recognized for its leadership and growth as a TIME100 Most Influential Company, CNBC Disruptor 50, Modern Healthcare's Best Places to Work in Healthcare, Forbes' Best Employers, Financial Times Fast