Jay Choksi
Data Analytics Engineer · Swanson Russell
Denver, COWork Experience
Data Analytics Engineer
Swanson Russell2020 – 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 Inc2020 – 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- BAND2016 – 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 University2017
Bachelor of Engineering in Electronics and Telecommunications
Master of Science in Information Systems
Northeastern University2019
Master of Science in Information Systems