The Membership Data Analyst provides highly specialized services to the Global Membership department related to financial, fundraising and operational analysis. They are responsible for providing complex reports, dashboards and interpretive analysis for the leadership in each market. The analyst will be responsible for designing, developing, deploying and continuously improving all PowerBI and Google Analytics dashboards as well as Excel standardized reports. They must have an intimate understanding of SQL, BigQuery and Excel and be able to efficiently build all extracts and live data feeds that populate their visualizations. They must be practiced at data cleaning and preparation as well as designing easy to use dashboards and reports. They must be intimately aware of and follow SDLC and Agile principles in the development of all analytic products. They must have the ability to communicate clearly and regularly with our stakeholders in gathering their requirements and collaborating with them in the iterative design, deployment and maintenance of their visualizations. The analyst will be responsible for working closely with various Global Membership team stakeholders to identify key business questions, conduct ad-hoc analytics, and develop meaningful insights and recommendations from their analysis to drive revenue and donor growth. They respond to elaborate questions and problems based on advanced knowledge of direct response marketing and the Membership program's strategies, as well as finance procedures. They will be responsible for clearly and concisely communicating the results of their work through PowerPoint presentations and data stories to the teams they support. They will play a pivotal role in identifying areas of underperformance and future opportunities based on their analysis; and will be responsible for clearly communicating these identified opportunities and threats to key decision makers. Their analysis and interpretation will help drive the strategic plan and forecasting process as well as help TNC to focus on the areas of biggest growth opportunity in the countries we support. Finally, they will manage the development of budgets, forecasts, scenarios, and revenue / expense analysis by country and create elaborate reports and interpretive financial analysis for leadership in each market.