ABOUT ME
Hi, welcome to my homepage! I'm Jiaman Li (Lee), a data professional with over 2 years of experience in DBMS, ETL (MySQL, AWS), and BI (Power BI, Tableau, Excel), and over 1 year of experience in marketing planning and operation. This space is a great opportunity to give you a brief background on who I am, what I do, and what my site offers. I would love to share my professional journey and insight with you.
If you're interested in learning more about my qualifications, past experience, and education, please feel free to check out my CV section and download my CV.
EXPERIENCE & EDUCATION
Qualifications
Discovering My Career Path
In my early years of college, I became captivated by a marketing simulation game that challenged players to allocate a business's budget across various departments to maximize profit growth. This game mirrored my natural talents and interests: meticulous observation, uncovering hidden correlations and causations, and utilizing this insight to forecast outcomes and refine decision-making.
​
Choosing Marketing Analytics as the focus of my study directly responded to my career aspirations. It equipped me with the skills to translate shifts in customer behavior and market trends into quantitative data for analysis, enabling more effective marketing strategy adjustments. Crucially, it instilled a marketing-oriented mindset in me, which I believe is vital for sidestepping potential future disappointments in developing services and products that may not resonate with the market. Besides, marketing aligns perfectly with my passion for innovative ideas.
Driven by Curiosity
My curiosity fuels observing people's behavior and my knack for spotting connections and patterns among diverse elements. I enjoy distilling these observations into rules, leveraging simple insights to clarify and predict more complex phenomena.
I love the moment when I accurately predict things and want to quantify these observations into understandable rules. This would make the underlying patterns visible and accessible to others and also enhance the precision of my predictions.
2002-2008 Chongqing Bashu Primary School
2008-2010 Chongqing Nankai Secondary School
2011-2012 Chongqing No. 1 International Studies School (10th Grade)
2012-2014 International Division of Chongqing Bashu Secondary School (11th and 12th Grade)
June 2014 - Dec 2015
Bachelor of Science, Pennsylvania State University, Park (Main Campus)
Marketing, Marketing Analytics Track
January 2016 - Dec 2019​
Customer Service · Full-time
Da Dong Food & Beverage Investment Co., Ltd.
May 2018 - June 2018
Beijing, China · On-site
Skills: Bilingual Communications, Customer Service, Hospitality Management
Market Research Analyst · Internship
Beijing Easteat Institute
Easteat Institute
Jun 2018 - Jul 2018
Beijing, China · On-site
Skills: Process Analysis, Market Research, Global Marketing
2019 Summer Study Abroad Program
-
Brand Management
-
Photography
Integrated Marketing Planner & Analyst · Full-time
Judao Culture Media Co, LTD
Mar 2021 - Aug 2021
Shanghai, China · On-site
Skills: Marketing Analytics · Presentation Skills · Teamwork · Market Research · PowerPoint · Team Leadership
Address a World Need
I've identified a significant gap in the ability to measure marketing ROI effectively. Often, marketers can only assure their clients of enhanced brand awareness and sales spikes during major events, lacking concrete numbers to truly demonstrate marketing efficiency. This absence of quantifiable metrics makes it difficult to refine and improve marketing strategies.
​
With plans to pursue higher education, I've decided to steer my focus towards Business Analysis. This path will equip me with the necessary skills to utilize data in measuring trends and changes, allowing for a more tangible assessment of marketing initiatives. Additionally, I aim to expand my analytical skills beyond the confines of marketing, applying them across various domains to offer a broader, more versatile analytical perspective.
-
Marketing Analytics
-
Analyzing Business & Industry
-
Information Technology & Business Strategy
-
Marketing Strategy
-
Global Marketing
-
Brand Management
Fashion Operations Assistant · Seasoned
Chongqing Jiahe Lisha Clothing Co., LTD
Apr 2020 - May 2020
Chongqing, China · On-site
Skills: Data Management · Excel · Bilingual Communications
HireBeat (Startup)
Business Analyst · Internship
Aug 2021 - Nov 2021
Jersey City, NJ, United States · Hybrid
Skills: Business Analysis, Research, Pricing Strategy, AWS
​
​
Indegene
Data Analytics Consulting · Capstone Project
May 2022 - Aug 2022
New York, United States · Hybrid
Skills: Icon Design, Communication, Reporting, Machine Learning, PowerPoint, Data Analysis
​
​
​
IBM
Associate Consultant · Co-op Project
Aug 2022 - Sep 2022
Beijing, China · Remote
Skills: Consulting, PowerPoint, Communication, Research
Master of Science, Columbia University
Applied Analytics (STEM)
September 2020 - December 2022​
-
Python for Data Analysis
-
SQL & Relational Database
-
Applied Analytics Frameworks and Methods I & II (R Programming Language)
-
Strategy & Analytics
-
Storytelling with Data
-
Managing Data
-
Research Design
-
Digital Product Innovation & Entrepreneurship (Agile Methodologies)
Longevity Holdings, Inc.
Associate Data Engineer· Temporary
Apr 2023 - May 2023 · Remote
Minneapolis, Minnesota, United States
Skills: Extract, Transform, Load (ETL), Database Management System (DBMS)
​
Data Analyst · Full-time
May 2023 - Dec 2023 · Remote
Minneapolis, Minnesota, United States
Skills: Business Intelligence (BI), Data Management , Data Analysis, Data Reporting, Agile
​
NAAFIA & Chihuo, Inc.
Conference Manager, Volunteer
Jun 2024 - Aug 2024
Los Angeles, CA (Hybrid)
​Skills: Event Management, Client Communication & Service, Business Analysis & Consulting
Kepler Mission Design
​
Strategy and Data Analyst, Internship(40 hr/week)
Dec 2024 - Present
New York, United States · On-site
Skills: Process Optimization, AI/Prompt Engineering, Business Analytics, Strategic Planning,
​
Creative Marketing Specialist
Sep 2024 - Present · 5 mos
New York, United States · On-site
Skills: Social Media Operation, SEO Optimization, Content Creation, Client Communication, Collaboration and Teamwork, Data Visualization,
My Passion
I am passionate about transforming complex data into actionable insights. In today's dynamic world, I am convinced that strategic data analysis based on high-quality data could empower companies to enhance operational performance, navigate risks, seize market opportunities, and refine decision-making processes.
My Vision
My vision is to merge my marketing, technology, and innovation skills to deliver digital solutions and products that leave a positive imprint on society.
My Personality
Pymetrics assessment is a modern evaluation method using neuroscience and AI. It features games that assess cognitive and emotional traits, offering insights into a candidate's fit for specific roles. This approach focuses on inherent abilities, promoting a more equitable hiring process and supporting diversity in the workplace.
Check out my Projects!
