Apply on Employer Site

Progyny, Inc. · 14 hours ago

Data Engineer

New York, NY

Full-time

Hybrid

Mid Level

$140K/yr - $155K/yr

3+ years exp

Progyny, Inc. is a global leader in women’s health and family building solutions, and they are seeking a Data Engineer to join their team. The role involves designing, developing, and delivering data solutions, as well as maintaining data systems to meet business specifications.

FertilityHealth CareMedical

Comp. & Benefits

No H1B

Responsibilities

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

Qualification

SQLPythonData Pipeline ArchitectureData TransformationAmazon AWS RDSApache AirflowDockerGitData SecuritySoft Skills

Required

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

Benefits

Paid family and parental leave

Preconception, fertility and family building benefits (including egg freezing, IVF, and adoption support)

Family and pet care fund

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)

Onsite meals and snacks for employees reporting into our NY office

Company

Progyny, Inc.

Glassdoor3.8

Progyny (Nasdaq: PGNY) is a transformative fertility, family building and women’s health benefits solution, trusted by the nation’s leading employers, health plans and benefit purchasers.

Founded in 2008

New York, New York, USA

501-1000 employees