Data Engineer

Thank you for considering Progyny!

We are looking for a Data Engineer to join our team. You will be responsible for all aspects of the design, development and delivery of data and database solutions.

What you'll do...

• Design, develop and implement data solutions. This may  include architecture design, prototyping of concepts to proof of concept, development of standards, design and development of test plans, code and module design, development and testing, data solution debugging, design and implementation of a solution that follows efficient design techniques and development that meets and exceeds the intent of the design of the data solution.

• Develop, construct, test and maintain optimal data pipeline architecture

• Support and maintain data and database systems to meet business delivery specifications and needs.

• Partner with a team of developers to effectively meet the deliverables and schedule of a data solution component within a larger application project.

• Lend support to various business and technology teams as necessary to ensure solid, scalable, robust solutions.

• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Postgres, Python and ETL Tools

• Assemble large, complex data sets that meet functional / non-functional business requirements.

• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

• Prepare data for predictive analysis & use data to discover tasks that can be automated  

• Partner with internal stakeholders including the BI & Finance teams to assist with data-related technical issues and support their data infrastructure needs.

About you...

• 3-5 years of experience in a Data Engineer role

• Degree in Computer Science, Statistics, Information Systems, equivalent field, and or comparable experience

• Advanced working SQL knowledge and experience working with relational databases

• Proven experience with Data Transformations & Integrity testing by using test-driven development methodologies.

• Demonstrated experience with EXPLAIN, indexing and query optimizations

• Prior experience with object-oriented/object function scripting languages: Python, Java, C++

• Prior experience with Amazon AWS RDS & Aurora

• Demonstrated experience with at least one DAG-based orchestration tool such as Apache Airflow, Dagster, Azure Data Factory and/or its derived systems.

• Working knowledge of with Docker, Git & SDLC Methodologies

• Knowledge of Salesforce Data APIs and SOQL

• Experience building (or redesigning) and optimizing data pipelines, architectures and data sets.

• Knowledge of non-SQL data sources: such as JSON, MongoDB, and consuming data from APIs

• Prior experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

• Proven experience building processes supporting data transformation, data structures, metadata, dependency and workload management.

• Demonstrated experience with data security, encryption, HIPAA

Please note: This is not a digital nomad or remote international position; candidates must be based in the United States. 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