JC

Jay Choksi

Data Analytics Engineer · Swanson Russell

Denver, CO

Work Experience

Data Analytics Engineer

Swanson Russell

2020 – Present

Remote • Revolutionized the organization's integration approach by implementing an ELT pipeline architecture using BigQuery and dbt which increased storage capacity by 3x and reduced costs by 30% • Built customer cohorts for E-commerce client using K-means clustering in Python to predict spending behaviors which helped acquire an additional 25% pool of quality-users • Developed dashboards to visualize multi-campaign and platform roll-up views, KPI trends, user journey, attribution modeling in Data Studio and Datorama to reduce collective time required for monthly reporting by 20 hours • Formulated ad hoc reports using SQL-based queries and Data Studio to provide insights on engaged-user trends, goal completion benchmarks, revenue share by demographics and geo-based views • Designed and tested Tags and Triggers in GTM containers to set up website conversions, events & created goals in Google Analytics • Collaborated with Social, Paid Media, PR teams to brainstorm campaign nomenclature and solutions to improve ad performance

Data Analyst Intern

Eastern Testing and Inspection Inc

2020 – 2020

, Remote • Performed extraction, manipulation and summarization of data from multiple internal sources using SQL-based queries • Designed reports in MS Excel to provide insights on Net Promoter Score (NPS) survey and bi-weekly sales performance

Data Analyst Intern

Camp Mobile- BAND

2016 – 2016

India • Collaborated with acquisition team to analyze customer acquisition metrics and reduced cost per install by 20% • Formulated content marketing campaigns improving user retention by 80% and return visitor conversion by 30% • Presented weekly reports to executive team highlighting the Key Performance Indicators (KPIs) of ongoing strategies

Education

Bachelor of Engineering in Electronics and Telecommunications

Mumbai University

2017

Bachelor of Engineering in Electronics and Telecommunications

Master of Science in Information Systems

Northeastern University

2019

Master of Science in Information Systems