SOPHIA LIAN
New York,NY
Summary
Data scientist skilled at machine learning and big data management. Demonstrated success in audience segmentation, behavioral trend analysis, and liaising with senior stakeholders to build high impact solutions aligned with business needs.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Scientist
DISH MEDIA SALES
12.2021 - Current
- Analyze big data using Python and SQL to measure media ad performance
- Utilize A/B testing to model audiences and to integrate backend technologies and platforms (Invidi, MediaOcean, Freewheel, etc)
- Monitor weekly ad impressions (pacing) to adjust for under-delivery or over-delivery
- Coach sales team in use of SSPs, DSPs, and other ad technologies
- Build Tableau reports to visualize post-campaign performance
- Present data-driven analysis to leadership and external stakeholders to jumpstart company initiatives
- Lead creative project work to realize profit opportunities
- Identify applications for existing data to optimize user experience and reach company goals
Data Science Fellow
NYC DATA SCIENCE ACADEMY
07.2020 - 12.2021
- Proficiency in SQL, Python, R, and Tableau
- Selected projects demonstrate skills in customer segmentation and trend analysis/prediction
Energy Security Consultant
COUNCIL ON FOREIGN RELATIONS (CFR)
09.2018 - 07.2020
Energy Industry Analyst
FEDERAL ENERGY REGULATORY COMMISSION (FERC)
07.2016 - 09.2018
Financial Compliance Analyst
INSTITUTIONAL SHAREHOLDER SERVICES (ISS)
01.2016 - 07.2016
Education
Master of Science - Applied Economics
COLUMBIA UNIVERSITY
New York, NY12.2014
Bachelor of Science - Statistics
UNIVERSITY OF FLORIDA
Gainesville, FL05.2008
Skills
- Big data
- Data Science
- R
- Python
- scikit-learn
- Demand side platform
- Server side platform
- DSP
- SSP
- DMP
- Ad server
- Cloud computing
- E-commerce
- Finance
- Adtech
- Coding
- Statistics
- Econometrics
- AWS
- Microsoft Excel
Certification
- AWS Developer Associate Certificate (summer 2024)
- MBA certificate
Publicspeaking
Toastmasters International. First runner up for humorous Table Topics contest (local)
Timeline
Data Scientist
DISH MEDIA SALES
12.2021 - Current
Data Science Fellow
NYC DATA SCIENCE ACADEMY
07.2020 - 12.2021
Energy Security Consultant
COUNCIL ON FOREIGN RELATIONS (CFR)
09.2018 - 07.2020
Energy Industry Analyst
FEDERAL ENERGY REGULATORY COMMISSION (FERC)
07.2016 - 09.2018
Financial Compliance Analyst
INSTITUTIONAL SHAREHOLDER SERVICES (ISS)
01.2016 - 07.2016
Master of Science - Applied Economics
COLUMBIA UNIVERSITY
Bachelor of Science - Statistics
UNIVERSITY OF FLORIDA
Similar Profiles
Lamont SmithLamont Smith
Senior Technical Operations Analyst at DISH Media Sales(Sling TV)Senior Technical Operations Analyst at DISH Media Sales(Sling TV)
Rachel O’ConnorRachel O’Connor
Account Executive at DISH Media/Sling TVAccount Executive at DISH Media/Sling TV
Maneesh C KManeesh C K
DISH 5G OSS Domain Architect/IT Product Owner at Dish Network Technologies( Formerly Sling Media)DISH 5G OSS Domain Architect/IT Product Owner at Dish Network Technologies( Formerly Sling Media)