Badges
Certifications
dianadeloslopez has not earned any certificates yet.
Work Experience
Data Analyst
goPuff• August 2021 - Present
- Manage 9 of the top 10 US dashboards used company-wide with over 2 million dashboard runs and 42 million query runs since start of employment - Create 10+ dashboards (multi-viz reports) and 30+ looks (single viz reports) with 300,000+ runs and write 2000+ lines of LookML/SQL to surface key KPI metrics including inventory, order quality, and ops performance - Maintain and oversee change management of 60+ Looker data products, which includes updating filters, removing/adding new measures, writing LookML, and considering Looker performance - Implement a new SQL/LookML model to identify expiration request compliance, providing further insight into our overall damaged and expired inventory workflow - Consult 6+ different support teams on their data-centered initiatives including KPI definitions, Looker report creation, Looker performance considerations, and pipeline work needed - Partner with the Data and Analytics Engineering on reviewing and completing 200+ ops-related data requests
Epidemiology Research Fellow
National Institutes of Health• August 2018 - January 2022
- Analyzed over 15,000 rows of data in R/Rstudio and SAS using advanced statistical methods including latent class analysis, time varying effect modeling, and geographic information systems (GIS) spatial analysis - Coordinated survey and content development for a study on understanding the impact of COVID-19 on mental health and chronic diseases among immigrants - Familiar with datasets involving specialized multi-ethnic cohort, complex survey design, big data access, and qualitative methods
Education
Calvin College
Public Health, BA• August 2014 - August 2018