The American College of Surgeons (ACS) is seeking a Membership Data Analyst to leverage modern analytics tools and data-driven insights to enhance services, strengthen member engagement, and drive growth by transforming complex data into actionable intelligence for strategic decision-making.
Requirements
- Advanced proficiency in Power BI (data modeling and custom visualizations)
- Familiarity with optimizing the visualization of information and awareness of user experience best practices
- Candidates should have experience with cohort analysis, segmentation, and predictive modeling
- Experience with statistical analysis (including regression, correlation, and hypothesis testing); A/B testing and experimental design is a plus
- SQL query writing and database management experience
- Some exposure to Python or R for statistical analysis and data manipulation
- The ideal candidate should have experience with data warehousing concepts and ETL processes, as well as advanced Excel skills (including pivot tables, VLOOKUP, and statistical functions)
Responsibilities
- design and execute approaches to collect, clean, and organize membership data using both primary and secondary sources
- analyze data sets to identify trends, patterns, and insights into membership demographics, engagement, and retention
- conduct research on key membership and practice trends in the surgery field and share updates with internal stakeholders
- oversee both quantitative and qualitative data tasks such as survey development, coding interviews, and creating dashboards or reports to communicate findings
- build and maintain dashboards in Power BI (or other visualization tools) to track membership growth, engagement, retention, and other key performance indicators
- partner with IT and other experts to maintain enterprise architectures, data models, governance, and best practices
- design and maintain scalable analytics systems and reporting processes
Other
- 3+ years experience specifically in membership, customer, or donor analytics.
- Excellent verbal and written communication skills.
- Strong working knowledge of Microsoft Office products (Outlook, Word, Excel, and PowerPoint).
- Excellent research skills and the ability to find, review, synthesize, evaluate, and translate qualitative and quantitative research findings into relevant insights.
- Experience presenting complex data insights to Leadership and Employees; demonstrated ability to translate business questions into analytical frameworks; experience working in matrixed organizations with multiple stakeholders.
