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 toempower 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 Fastest Growing Companies, Inc. 5000, Inc. Power Partners, and Crain's Fast 50 for NYC. For more information, visit www.progyny.com .

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 City's Wage Transparency Law, the annual salary [wage] range for NYC-based applicants is : $140,000 - $155,000. 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 employer.We respect and seek to empower each individual and support the diverse cultures, perspectives,skillsand 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 apply@progyny.com .

#LI-BG1