Progyny is a leading fertility benefits management company in the US. We are redefining fertility and family building benefits, proving that a comprehensive and inclusive fertility solution can simultaneously benefit employers, patients, and physicians. Our benefits solution empowers patients with education and guidance from a dedicated Patient Care Advocate (PCA), provides access to a premier network of fertility specialists using the latest science and technologies, reduces healthcare costs for the nation’s leading employers, and drives optimal clinical outcomes. We envision a world where anyone who wants to have a child can do so.

Our mission is to make any member’s dream of parenthood come true through a healthy, timely, and supported fertility and family building journey.

Progyny is hiring a Business Analyst to join the Business Strategy and Analytics team in New York City.  Our team is at the forefront of key strategic initiatives of the nation’s leading fertility benefits management company. In this role, you will support our sales team as a trusted advisor, recommending deal structures to achieve sales goals while minimizing risk to Progyny. You’ll advise on strategic initiatives by conducting data analysis, collaborating cross-functionally, and presenting to various internal stakeholders, including executive sales leadership. You will learn the nuances of fertility, dive into the complex world of healthcare analytics and contribute to meaningful changes in the way we approach the marketplace with our growing suite of fertility and women’s health products.

What you'll do...

• Generate book of business reporting by industry, geography, and treatment to inform the sales team of current cost trends
• Manage, optimize, and update existing SQL Queries, analytics, and reports to fully serve the sales teams as they seek effective ways to manage risk across deals.
• Maintain cross-functional relationships with customer-facing teams and collaborate on analytics for data driven conversations, presentations, and enhancements of team efficiency.
• Deliver ad-hoc analytics to facilitate innovative deal structures, advise on the cost of overrides vs base model outputs, and act as a trusted partner to the sales team, working with other sales analytics staff to ensure clear understanding of model output
• Understand how to leverage and combine various data sources (SQL, Salesforce, Sharepoint, etc) and applications (PowerBI, Excel, etc) to create solutions, dashboards, and analysis.
• Present analytical insights to key stakeholders in a way that is easy to understand and actionable

About You...

• 2+ years of relevant data analysis experience, preferably at a top-tier consulting firm or healthcare company
• Bachelor’s degree required
• Enjoys analyzing large sets of data (30M+ rows) and forming actionable insights
• Demonstrable Proficiency in Excel required
• Demonstrable Proficiency in SQL required
• Proficiency with Python preferred
• Prior experience with data visualization tools (e.g. Power BI, Cognos, Tableau, Looker) preferred
• Enjoys learning, dissecting, optimizing, and ultimately owning existing modelling methodologies
• Organized and methodical with very strong attention to detail
• Demonstrated ability to be adaptive and inquisitive; natural problem solver
• Ability to work autonomously with minimal direction on multiple endeavors at once
• Driven to deliver results with the ability to establish rapport, earn trust, and effectively collaborate with others