Internship @ RVNG (Ongoing)

🎧 Intro: Data with Soul

When I joined RVNG Intl., I knew I wasn’t stepping into a typical tech company: I was joining a record label that thrives on creativity, intuition, and artistic freedom. But even the most experimental label still needs numbers to tell its story. My job was to help shape those numbers into something human.

🚀 Mission

RVNG had data, but it was scattered across multiple sources such as Shopify, Bandcamp, and Secretly Distribution. Secretly Distribution is a worldwide digital and physical distributor that helps RVNG to promote catalogs globally. I was tasked with building a unified backend system and analytics dashboard that would let the team see how their music was performing: financially, globally, and artistically.

🔧 What I Built

📦 1. Data Pipeline & ETL (Extract → Transform → Load)

Automated ingestion of reports (monthly, sometimes messy) into Google Cloud Storage, totaling over 130MB+ of financial and streaming data per batch.

Used Python, pandas, and MySQL to clean, standardize, and transform fields like currency, product ID, and territory codes across datasets.

Implemented Cloud SQL pipelines and scheduled tasks using cloud_sql_proxy and bash automation.

🧱 2. Relational Database Design

Designed normalized relational schemas:

digital_revenue_all, physical_sales, streaming_lookup, track_artist_album, etc.

Created foreign keys to link data across platforms for artist-centric views.

Set up pre-aggregated summary tables for faster queries.

📊 3. Interactive Dashboards with Looker Studio

Built dynamic dashboards to visualize:

💰 Net revenue per platform (Shopify vs. Bandcamp vs. DSPs)
🌍 Sales by country & region
🔁 Track-level performance over time

Reduced query time through query optimization and table redesign.

🔍 4. Experimental Work & Narrative Support

Worked with label heads Matt and Warren to explore:

🤖 Integration of Luminate data for artist storybuilding
📈 Weekly trend summaries from UsageDate metadata
🧪 Potential integration of Spotify for Artists backend

💡 Key Takeaways

RVNG taught me that data isn’t just technical: it’s personal. A song’s performance isn’t just about revenue, it’s also a reflection of connection. I learned how to design systems that respect artistic vision while enabling business growth, and how to communicate technical concepts to creatives.

This internship blended my love for music with my skills in data science. It was more than building a dashboard, it was about helping a label hear its own story more clearly

Work Presentations:

This dashboard provides a six-month overview of RVNG’s digital revenue performance, including:

Source-level, DSP, country, album, track, and artist breakdowns

Time-series analysis of revenue and quantity trends

Detailed track- and album-level performance analytics