Membership Data Sr. Analyst

The Nature Conservancy • Arlington, VA

236d • $76,500 - $111,400 • Remote

About The Position

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. The analyst will work 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 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.

Requirements

• Bachelor's degree in quantitative field and 3 years' experience or equivalent combination.
• End user support experience.
• Experience with Microsoft Office programs.
• Experience manipulating relational data.
• Experience with SQL, advanced Excel features, data warehousing tools, and statistical software (SAS, Python, R, or similar).
• Proficiency in relational database architecture, ETL processes, and data management principles.
• Experience with direct response marketing revenue and expense analysis.
• Experience with sales funnels and analyzing CRM data.
• Experience in building dashboards and enterprise reports (PowerBI, Tableau, Looker).

Nice To Haves

• Multi-lingual skills experience appreciated.
• Ability to work in partnership with others in a collaborative or advisory role.
• Excellent analytical and quantitative skills.
• Excellent verbal and written communication skills.
• Experience developing, managing, and implementing goals, plans, and complex processes.
• Advanced expertise in Microsoft Excel, including complex pivot tables and advanced formulas.
• Demonstrated experience as project manager.
• Experience with accounting.
• Strong organizational skills and attention to detail.
• Superior planning and problem-solving skills.
• Demonstrated experience working across cultures and countries.
• Experience with Google Analytics and Big Query.
• Experience working with cross-functional teams.

Responsibilities

• Design, develop, deploy and continuously improve PowerBI and Google Analytics dashboards.
• Build extracts and live data feeds that populate visualizations.
• Conduct data cleaning and preparation.
• Communicate regularly with stakeholders to gather requirements.
• Identify key business questions and conduct ad-hoc analytics.
• Develop insights and recommendations to drive revenue and donor growth.
• Manage the development of budgets, forecasts, and revenue/expense analysis.
• Establish fundraising and operational in-market tests and conduct statistical analysis.
• Work with data engineers to improve data accuracy and completeness in CRM systems.

Benefits

• Health care benefits.
• Flexible spending accounts.
• 401(k) plan with an 8% employer match.
• Parental leave.
• Accrued paid time off.
• Life insurance.
• Disability coverage.
• Employee assistance program.
• Other life and work well-being benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Religious, Grantmaking, Civic, Professional, and Similar Organizations
• Education Level: Bachelor's degree