Lead Business Analyst

Progyny•New York, NY

6d•Hybrid

About The Position

Progyny is seeking a Lead Business Analyst to join the Medical Economics and Analytics team in New York City, primarily supporting the Product team. This role involves developing data, analytical insights, and tools across Progyny’s product portfolio and digital ecosystem. The Lead Business Analyst will collaborate with cross-functional teams, including Product, Marketing, and Member Services, to deliver analyses and solutions that evaluate product health and inform strategic decision-making to enhance product performance.

Requirements

Bachelor's degree with an analytical focus in healthcare, economics, finance, statistics, data analytics, or a related field.
5-7 years of relevant experience in healthcare, insurance, consulting, analytics, or a related field.
Advanced SQL skills with demonstrated experience querying, transforming, and analyzing large and complex datasets (30M+ rows).
Experience working in modern analytics environments and IDEs (e.g., Visual Studio Code, Cursor, PyCharm, or similar).
Experience using AI-enabled tools to accelerate analysis, development, or workflows.
Proficiency with data visualization and business intelligence tools such as Tableau, Power BI, Looker, or similar platforms.
Demonstrated experience developing effective dashboards and data products for business stakeholders.
Candidates must be authorized to work in the United States without the need for sponsorship.

Responsibilities

Serve as the analytics subject matter expert for products, understanding member eligibility, enrollment, communications, service utilization, referrals, surveys, claims, and outcomes.
Own and evolve end-to-end data models connecting member journey interactions and incorporating new data sources.
Define progression metrics, establish KPIs, and translate complex journeys into actionable funnel, cohort, trend, and marketing attribution analyses.
Build, maintain, and optimize scalable analyses, data models, dashboards, and reporting using SQL, Excel, and modern analytics/visualization tools, leveraging AI tools.
Monitor product performance and utilization, identify trends, risks, and opportunities, and lead deep dives to evaluate initiative impacts.
Partner with Product, Marketing, and Member Services to evaluate performance against KPIs, identify opportunities, and deliver insights for decision-making.
Lead the analytics narrative for executive reviews by shaping agendas, preparing presentations, surfacing key insights, and guiding stakeholders to decisions.

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
Company social events
Annual volunteer day
Donation matching
Flex days (3 days a week in the office)
Onsite meals and snacks for employees reporting into our NY office