Sr. Engagement Data Analyst
CurrentAs the Sr. Engagement Data Analyst here at MAC I am responsible for cultivating rich data sets for the Executive Leadership Team, General Manager, and the Board of Trustees. Responsible for monthly building, maintaining, and publishing of multi-layered dashboards for key stakeholders (Tableau, Excel, and Smartsheet). Served as a link between the data and department leaders to mentor them on how to best measure their operations based on demand and data availability. This allowed them to select… Show more As the Sr. Engagement Data Analyst here at MAC I am responsible for cultivating rich data sets for the Executive Leadership Team, General Manager, and the Board of Trustees. Responsible for monthly building, maintaining, and publishing of multi-layered dashboards for key stakeholders (Tableau, Excel, and Smartsheet). Served as a link between the data and department leaders to mentor them on how to best measure their operations based on demand and data availability. This allowed them to select and understand their specific key performance indicators and become owners of their respective processes.Developed, tested, and deployed churn model that identified our most at-risk members allowing for club leadership to develop a plan to reduce membership losses. Using SQL querying, created monthly audits that in the first 6 months generated over $250k in savings. Spearheaded the implementation of multiple member feedback loops using Qualtrics. This ranged from the integration of multiple database sources, working with IT partners to ensure the SFTP automation fulfilled our expectations, and the creation of 3 separate, re-occurring member facing surveys that leverage both custom data fields and automation. I also develop ad-hoc surveys and dashboards depending on specific business requirements and stakeholder requests. Serve on a member facing sub-committee that reports membership behaviors and assess how the club can best address it's wide-ranging demographics. This includes a specifically designed regression model and resignation survey that will allow for both a quantitative and qualitative approach at identifying gaps in our member experience that can be segregated on the fly based on numerous demographic factors.Created an Innovation Funnel mechanism (through Sharepoint) that intakes employee ideas, scores them based on strategic alignment, scalability, service standard impacts, and speed. This project is being developed currently for club wide implementation. Show less