Emerson Jerome
Chicago,IL
Overview
5
5
years of professional experience
Work History
Senior Analyst
Starcom
07.2021 - 01.2024
- Built and maintained multiple directly client-facing Tableau dashboards connected to live data feeds.
- Oversaw and executed aggregation of data for Media Mixed Modeling, which involved working across various teams and contacts to gather and clean millions of rows of data.
- Validated results and performed quality assurance to assess accuracy of data.
- Generated insights based on data compiled and visualized using Excel macros.
- Complete ad-hoc reporting requests using data exploration to turn questions and curiosities into answers and insights.
Analyst
Starcom
07.2019 - 07.2021
- Completed bi-weekly reporting for live display and social campaigns for five retail clothing brands. Pulling, merging, cleaning, and visualizing data from DCM (Google Campaign Manager), FB Ads, and MOAT.
- Conducted social and press listening research for retail clothing brands and their competitors using NetBase and Quid (formally Zodiac) to be used in monthly newsletters.
- Updated, maintained, and published client-facing Tableau dashboards. Created user guide for the client-facing dashboard interface. Created internal dashboard for KPI benchmarking.
- Completed monthly reporting for a large telecom company. Worked with data from Google Campaign Manager, The Trade Desk, five social media platforms, Flashtalking, and Double Verify. Data aggregation, merging, cleaning, analyzing, and visualizing to build client deliverables.
Education
Bachelor of Science in Marketing - Advanced Marketing Analytics
Illinois State University College of Business
Normal, IL2019
Skills
- Advanced Excel and Tableau skills
- Knowledgeable in Python, R, SQL, SPSS, and SAS
- Excellent written, verbal, and presentation skills
- Insight generation
- Quality assurance and attention to detail
- Data-related investigations and problem solving
- Knowledge of business operations
Timeline
Senior Analyst
Starcom
07.2021 - 01.2024
Analyst
Starcom
07.2019 - 07.2021
Bachelor of Science in Marketing - Advanced Marketing Analytics
Illinois State University College of Business
Similar Profiles
YaChu(Wendy) ChangYaChu(Wendy) Chang
Senior Manager at StarcomSenior Manager at Starcom
Anastasia ZioriAnastasia Ziori
SEO Account Manager at StarcomSEO Account Manager at Starcom
Yenitzie VelasquezYenitzie Velasquez
Investment/Strategy Associate at StarcomInvestment/Strategy Associate at Starcom
GINA ZUMAGINA ZUMA
Digital Media Planner at StarcomDigital Media Planner at Starcom
Chamere GraysChamere Grays
Payroll Assistant at Select RehabilitationPayroll Assistant at Select Rehabilitation