Beats By Dre logoBeats By Dre Externship via Extern
mansi bhadani portrait

Data Analytics Engineer who builds reliable data pipelines

I design ETL pipelines, data models, and cloud data solutions with Python, SQL, Airflow, Spark, and Snowflake to make analytics accurate and operational.

Work samples

Projects include a NJ Transit data engineering system, a Beats by Dre externship for consumer insight analysis, and internships delivering data platforms using Airflow, Spark, Kafka, and Snowflake.

  • Beats by Dre Consumer Behavior & Market Analysis Externship
    Beats by Dre Consumer Behavior & Market Analysis Externship
    Beats By Dre logo

    Beats By Dre · May 2025 · ✅ Verified by Extern

    Beats by Dre Consumer Behavior & Market Analysis Externship

    Learn how to understand consumer behavior, design surveys, and use AI tools to analyze data. Develop skills in research and data analysis that are valuable for careers in marketing, product development, and more.

About me

I design ETL pipelines, data models, and cloud data solutions with Python, SQL, Airflow, Spark, and Snowflake to make analytics accurate and operational.

Data Analytics Engineer with 2+ years of experience building reliable ETL pipelines, data models, and cloud data solutions using Python, SQL, Airflow, Spark, and Snowflake. Skilled in data quality and observability, large-scale migrations, real-time streaming, and integrating structured and unstructured data to support accurate analytics and operational decision-making across consumer, financial, and transit domains.

Externships

Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship

Beats By Dre

Experience

Data Engineer Project

NJ Transit Smart Management & Optimization System · Jul 2025 - Oct 2025

Data Analytics Extern

Beats by Dre · Mar 2025 - Jun 2025

Data Scientist Intern

Techcolabs Softwares Inc · Dec 2022 - Apr 2023

Data Engineer Intern

Innovative Research Labs · Jul 2022 - Oct 2022

Education

Pace University

Master of Science, Computer Science

Skills

PythonSQLAirflowSparkSnowflakeNLPOracleApache IcebergS3Kafka StreamsBERTRDSRedshiftLLM-powered applicationsGreat ExpectationsOpenLineageJavaScalaAWSGCPBigQueryPostgreSQLCassandraApache SparkPySparkApache KafkaApache FlinkHadoopHiveAvroKubernetesDockerTableaudbtETL ProcessesPipeline DevelopmentData MigrationData ModelingData WarehousingOLAP TechnologiesAPI DesignWebhooks

✅ Verified by Extern

Beats by Dre Consumer Behavior & Market Analysis Externship

Learn how to understand consumer behavior, design surveys, and use AI tools to analyze data. Develop skills in research and data analysis that are valuable for careers in marketing, product development, and more.

Overview

The externship produced a set of consumer-research artifacts for Beats by Dre, including an ideal consumer list, a customer-journey map, a 15-question analytical survey framework, coded qualitative themes from responses, and a presentation outline. Work combined survey design, manual coding, spreadsheet visualizations, and AI-assisted compilation.

Beats by Dre Consumer Behavior & Market Analysis Externship
Google Sheets
Access

What I've accomplished

I produced a complete consumer-research package: an ideal-consumer list, an AIDA customer-journey map, a 15+ question survey framework, coded themes from 20 responses, and a viewable presentation outline consolidating the findings.

Project breakdown

View all work