Yu Guo
Marketing Analyst | Data Analyst | Business Consultant @ New York City
- Role
- Marketing Data Analyst at RKD Group
- Location
- Brooklyn, NY, US
- LinkedIn followers
- 500 followers
About Yu Guo
A solution-driven business analyst with industrial experience in using data analytics to…
Experience
Marketing Data Analyst
Sep 2022 — Present · NY, US
Supported the delivery of outcomes for over 200 clients at one of the nation\'s largest fundraising agencies, instrumental in raising over $7 million in capital value within a span of 2 fiscal years- Co-created automated analytical pipelines (using SQL, SAS, Excel, and PowerPoint) with the data engineering team. Standardized 5+ analyses, including customer relationship value analysis, campaign insight analysis, long-term net analysis, and market penetration reporting, saving 100 hours per week in manual calculations- Advised Client Service teams on fulfilling over 10 ad-hoc requests per week, utilizing SQL Server (50K+ lines of code) and SAS (100K+ lines of code) for all clients. Collected donor data, streamlined the discovery process, and pitched strategies to management, leading to a 25% increase in ROI within one year- Researched and analyzed market inefficiencies, competitive advantages, and prospective growth opportunities. Led our team in developing more than 5 efficient automation models, resulting in acquiring 10 new clients- Created 30+ visually impactful presentations to highlight analytical outputs and critical insights. Presented to 30+ clients, contributing to an average 21% increase in new donors and a 12% boost in gross revenue per client.
Skills
- Teaching
- Public Speaking
- Nonprofit Organizations
- Social Media
- Higher Education
- Microsoft Office
- Community Outreach
- Management
- Event Planning
- Communication
- Fundraising
- Marketing Strategy
- Research
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.