Learn Data Skills
Beta
Sterling Xie

Sterling Xie

Certified

Research Analyst

Pro Football and Sports Network | Connecticut

Technologies

My Portfolio Highlights

My New Workbook

Digital Marketing Campaign Analysis: Predicting Conversion and Clustering Customers

My New Workbook

Clustering WNBA Players by Shot Locations and Usage

My New Workbook

Predicting Titanic Survival Rate in R

My New Workbook

Digital Marketing Campaign Analysis: Predicting Conversion and Clustering Customers

Data Analyst and Researcher with 9+ years of experience translating complex concepts into actionable insights.

My Work

Take a look at my latest work.

DataLab

Digital Marketing Campaign Analysis: Predicting Conversion and Clustering Customers

DataLab

Clustering WNBA Players by Shot Locations and Usage

DataLab

Predicting Titanic Survival Rate in R

DataLab

Predicting 2025 NFL Draft Ranges in R

DataLab

SQL Project: Sleep Health and Lifestyle

DataLab

Digital Marketing Campaign Analysis: Predicting Conversion and Clustering Customers

My Certifications

These are the industry credentials that I’ve earned.

Data Analyst

Data Analyst

Data Analyst Associate

Data Analyst Associate

SQL Associate

SQL Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate SQL
Introduction to R
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

Pro Football and Sports Network | Sep 2024 - Present

Research Analyst

- Developed statistical models utilizing predictive and descriptive modeling techniques in R. Metrics powered company's highest-revenue web tools and dashboards and served as foundational content for web articles. Created visualizations for dashboards featuring novel metrics derived from the models. - Built and maintained databases around PFSN's metrics, accelerating database entry, upload and maintenance by leveraging LLM AI engines including Perplexity and Claude. Optimized data entry and update processes in SQL, Excel, and Google Sheets that enabled PFSN to expand total NFL and CFB databases by 6x. - Researched stat packets for distribution to external clients using TruMedia, Stathead and PFSN's internal databases. Wrote NFL and NBA analysis articles in Wordpress focusing on storytelling through statistics and advanced metrics.
Show More

ESPN | Nov 2019 - Sep 2024

Senior Researcher

- Promoted to Senior Researcher in November 2019 to lead NFL and NBA sport group teams, cross-collaboration efforts with Content departments, and training programs for new hires. Assumed Analytics liaison role, connecting the development of novel metrics with potential executions on digital, linear and social platforms. - Led cross-functional content production, editing and coordination on ESPN Stats & Info's NFL and NBA leadership teams. Strategized short- and long-term content priorities, reviewed and critiqued on-air elements, and fulfilled weekly projects for show groups and digital leaders. - Organized content discussions and priorities over multiple years working on game event crews, specifically with Monday Night Football and NBA. Demonstrated adaptability and focus under pressure in time-intensive situations generating content for on-air graphics and talent reads. Developed relationships with event graphics team and provided regular feedback on ways to improve ROI potential and workflows. Coached teammates on best content practices and ways to develop relationships with the event group, including on-air talent. - Trained 20+ new Stats & Info hires on fundamentals of research - tools usage, show research, writing, show group relations, database querying and content philosophy. Led annual training series classes on Creative Studio Treatments, Pitching Ideas in Show Meetings and Generating Content Via Excel.

ESPN | Sep 2018 - Nov 2019

Production Researcher

- Promoted to Researcher in September 2018. Role transitioned from primarily data management as a Statistics Analyst II to database creation, content editing, studio show research and event research. - Developed cross-functional relationships with 100+ producers, directors and talent on studio shows to deliver compelling visual statistical treatments and enhance the information quality of the show. Primary researcher for both 11 PM SportsCenter and NFL Live for 2+ years each. Coached teammates on how to ingratiate themselves to new show groups by pitching content that played to on-air talent's strengths while protecting against blind spots. - Wrote and edited 1-2 game notes packets per week ranging from 1,000-3,000 words covering events on ESPN's family of networks. Content contained data-backed statistical storylines, including both historical research and advanced analytical angles. Distributed packets to between 50-200 ESPN clients per event, including producers, graphics producers, directors, and on-air talent.

ESPN | May 2016 - Sep 2018

Stats Analyst II

- Leveraged SQL skills for ETL processes that maintained the company's data warehouses for college football, men's college basketball and women's college basketball. Implemented quality checks for weekly in-season data uploads and managed data security integrity for clients outside of Stats & Analysis who needed access to specific elements of the data warehouses. - Produced next level analysis that went beyond the boxscore and explained why a given team or player performed the way they did during games. Worked with production research to help explain and pitch treatments to show producers and talent.

My Education

Take a look at my formal education

Master of Science in Strategic AnalyticsBrandeis University - Graduate Professional Studies | 2023
Bachelor of Arts in English LiteratureHamilton College | 2016

About Me

Sterling Xie

With over 9 years of professional experience, my core skills lie in sports content research and data analysis. Delivering data-driven insights is my career passion, as I love the challenge of impacting business by answering the question of "so what?"

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free