I am a dynamic and results-driven Data Analyst with a strong foundation in data analytics, digital marketing, and social media strategy. My expertise spans across data analytics, programming, digital marketing, and project management, enabling me to deliver impactful solutions that drive engagement and business growth.With a proven track record in managing social media operations and developing effective marketing campaigns, I have successfully increased user engagement by leveraging insights from market research and data analytics. My ability to create and optimize content on platforms like TikTok, Red, and Weibo has led to significant improvements in follower count and engagement rates.My technical proficiency includes tools like Google Analytics, Power BI, Tableau, and programming languages such as SQL, Python, and R. I specialize in using data visualization, A/B testing, and predictive modeling to inform strategic decisions and optimize marketing efforts. I am passionate about leveraging data to identify trends and opportunities, ensuring every strategy is backed by comprehensive analysis.I am adept at cross-functional collaboration, client-facing communication, and executing digital strategies that align with organizational goals. Passionate about staying ahead of industry trends and continuously improving my skills, I am dedicated to creating value through innovative marketing solutions and insightful data analysis.
-
Data AnalystInternational Institute Of Green Finance Oct 2023 - Oct 2024Toronto, Ontario, Canada● Utilized SQL for data cleaning and processing large datasets while integrating Python for trend analysis, enhancing the monitoring and reporting of the institute's WeChat and video account performance by creating automated, accurate reports that informed strategic decision-making.● Improved user segmentation and trend identification through k-means clustering and topic modeling techniques in Python, enabling the identification of key user behavior patterns, which directly supported green finance initiatives by refining audience targeting and improving outreach effectiveness.● Boosted user engagement by 35% by conducting detailed SQL metric analysis combined with Python-based visualizations, allowing for the identification of underperforming content and optimized release schedules, leading to significantly higher user interaction and retention.● Analyzed past social media performance using Power BI to develop interactive dashboards and applied Excel pivot tables to evaluate historical trends, resulting in over 1,500 impressions and a 20% increase in click-through rates, optimizing both content delivery and marketing focus.
-
Data AnalystBeijing Hei Qiao Music Studio May 2022 - Jan 2023Toronto, Ontario, Canada● Designed and implemented A/B tests on TikTok content strategies while leveraging SQL to analyze key performance metrics such as follower count, likes, traffic, and click-through rates, identifying high-performing content that led to a 15% increase in click-through rates and improved the effectiveness of future content planning.● Set up automated SQL-based systems for tracking engagement metrics and created real-time Power BI dashboards, enabling the marketing team to monitor performance in real-time, optimize campaigns more effectively, and adjust content strategies based on real-time insights to enhance engagement.● Utilized Python for segmentation, cohort analysis, and predictive modeling, analyzing user behavior patterns and forecasting engagement trends to refine content strategies, which resulted in a 25% increase in user retention through targeted scheduling and personalized content delivery.● Evaluated social media performance using SQL and TikTok Analytics, integrating data to optimize content creation and marketing approaches, ultimately contributing to the studio's growth to over 1 million TikTok followers, significantly expanding audience reach and engagement.
-
Strategy AnalystGfl Environmental Inc. Oct 2021 - Nov 2021Toronto, Ontario, Canada● Led cross-functional meetings weekly with stakeholders and teams to ensure smooth project execution and timely delivery, coordinating efforts to align with business goals.● Utilized SQL and Python to extract, clean, and analyze large datasets related to GFL's business model, services, and financial performance, identifying critical strategies that contributed to the company’s rapid growth and operational improvements.● Conducted market research using SQL and Tableau, analyzing both quantitative and qualitative data on competitors, with a particular focus on accounts payable models, uncovering trends and providing actionable insights that enhanced GFL’s competitive edge.● Developed detailed reports and visualizations using Excel and Tableau dashboards, integrating financial and operational data to propose strategies that optimized accounts payable processes by 10%, significantly improving overall operational efficiency.
Li Si Xuan Education Details
-
Gpa: 3.87 -
Cgpa: 3.62
Frequently Asked Questions about Li Si Xuan
What is Li Si Xuan's role at the current company?
Li Si Xuan's current role is Data Analyst | Data Visualization & Marketing Analytics | SQL, Python, Power BI.
What schools did Li Si Xuan attend?
Li Si Xuan attended University Of Toronto, University Of Toronto.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial