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 youll 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 womens health and family building solutions trusted by the nations 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 womens health specialists who use the latest science and technologies; drives optimal clinical outcomes; and reduces healthcare costs.

Our mission is toempower healthier supported journeys through transformative fertility family building and womens 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 Healthcares Best Places to Work in Healthcare Forbes Best Employers Financial Times Fastest Growing Companies Inc. 5000 Inc. Power Partners and Crains Fast 50 for NYC. For more information visit .

Our perks:

• Family friendly benefits: Paid family and parental leave preconception fertility and family building benefits (including egg freezing IVF and adoption support) family and pet care fund and Parents Employee Affiliation Group

• Menopause and midlife care

• Health dental vision and life insurance options for employees and family

• Free in-person virtual and text-based mental health and wellness support

• Paid time off including vacation sick leave personal days and summer flex time

• Company equity

• Bonus program

• 401(k) plan with company match

• Access to on-demand legal and financial advice

• Learning and development programs to help you grow professionally and a mentorship program

• Company social eventsto include annual volunteer day and donation matching

• Flex days (3 days a week in the office) and onsite meals and snacks for employees reporting into our NY office

In compliance with New York Citys Wage Transparency Law the annual salary wage range for NYC-based applicants is: $140000 - $155000. There are a variety of factors that go into determining a salary range including but not limited to external market benchmark data geographic location and years of experience sought/required. Progyny offers a total compensation package comprised of base salary cash bonus and equity.

Progyny is proud to be anEqual Opportunity and Affirmative Action respect and seek to empower each individual and support the diverse cultures perspectivesskillsand experiences within our workforce. All qualified applicants will receive consideration for employment without regard to race creed color religion sex sexual orientation gender identity or expression national origin disability age genetic information marital status pregnancy or related condition status as a protected veteran criminal history consistent with legal requirements or any other basis protected by law.

If you are an individual with a disability and need assistance or an accommodation during the recruiting process please send an e-mail to .

#LI-BG1