Lead Business Analyst

Progyny; Northern, New York (KY, NY); Hybrid; USD 115,000 - 125,000; Full time

Benefits offered by this job

Family and parental benefits

Company equity

401(k) plan with company match

Flexible work arrangements

Job summary

Progyny in New York City seeks a Lead Business Analyst to join the Medical Economics and Analytics team. You will partner with Product, Marketing and Member Services to deliver analyses that evaluate product health and inform strategic decisions that improve performance.

The role requires 5–7 years in healthcare analytics, advanced SQL, and proficiency with Tableau/Power BI/Looker. You will build scalable data models, dashboards, and insights for executives.

Qualifications

• Bachelor's degree with an analytical focus in healthcare or related field.
• 5–7 years of relevant experience in healthcare, insurance, analytics, or related field.
• Advanced SQL skills with large, complex datasets (30M+ rows).
• Experience with BI tools (Tableau/Power BI/Looker) and IDEs; AI-enabled tools are a plus.

Responsibilities

• Serve as analytics subject matter expert for our products, developing a deep understanding of member eligibility, enrollment, communications, service utilization, referrals, surveys, claims, and outcomes.
• Own and evolve holistic end-to-end data models that connect interactions across the member journey, incorporating new data sources as products expand.
• Define meaningful progression across product lines; establish KPIs and translate nonlinear journeys into actionable analyses.
• Build, maintain, and optimize scalable analyses, data models, dashboards, and reporting using SQL, Excel, and modern analytics tools, leveraging AI where possible.
• Lead analytics narratives for executive reviews, surfacing key insights and guiding decisions.

Skills

Advanced SQL

Data visualization

Tableau

Power BI

Looker

Analytical thinking

Education

Bachelor's degree in a related field

Tools

Visual Studio Code

Cursor

PyCharm

Job description

## Lead Business AnalystApply: New York, New York: Full time: Posted Today: JR101139Thank you for considering Progyny!Progyny [NASDAQ: PGNY] is a leading healthcare company reshaping family building by providing innovative fertility benefits to millions of people. We are hiring a Lead Business Analyst to join the Medical Economics and Analytics team in New York City. This role will primarily support the Product team.Our team develops data, analytical insights, and tools across Progyny’s product portfolio and digital ecosystem. In this role, you’ll partner closely 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 improve product performance.**What you'll do...*** Serve as the analytics subject matter expert for our products, developing a deep understanding of member eligibility, enrollment, communications, service utilization, referrals, surveys, claims, and outcomes.* Own and evolve holistic, end-to-end data models that connect interactions across the member journey, incorporating new data sources as products expand.* Define what meaningful progression looks like across product lines and engagement channels; establish clear KPIs and translate complex, nonlinear 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 and visualization tools, while leveraging AI tools to accelerate development and improve reporting workflows.* Monitor product performance and utilization, proactively identifying emerging trends, risks, and opportunities; lead targeted deep dives and evaluate the impact of initiatives across marketing, digital experiences, and operational workflows.* Partner closely with cross-functional operational teams, including Product, Marketing, and Member Services to evaluate performance against KPIs, identify opportunities, and deliver insights that inform operational and strategic decision-making.* Lead the analytics narrative for executive and business reviews by shaping agendas, preparing data-driven presentations, surfacing the most important insights, and guiding stakeholders toward aligned decisions and next steps.**About you...*** 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) and 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, with demonstrated experience developing effective dashboards and data products for business stakeholders.**Please note:** 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* 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 officeIn compliance with New York City's Wage Transparency Law, the annual salary [wage] range for NYC-based applicants is: **$115,000 - $125,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 [e-mail].