Data Engineer

Thank you for considering Progyny!

• 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.

• 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, 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 events to 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 an Equal Opportunity and Affirmative Action employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills and 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 [email protected]. 

#LI-BG1