Data analyst with expertise in Power BI, Tableau, Python, and SQL, seeking an individual contributor role in data and marketing analytics. Experienced in data integration and data validation, analysis of donor information, and reporting. Strong foundation in statistics, marketing, and data visualization. Committed to continuous learning and professional growth, leveraging extensive experience in both educational and B2C web marketing contexts.
Hi, I'm Juan. I've worn a lot of hats with eleven years of experience across six industries. My years as a teacher, marketer and data professional have taught me a wide array of useful skills:
Communication
Creativity and problem-solving
Attention to detail
Interpersonal skills
Leadership
Writing
Data management
Data-ethics
AGILE methodology
Statistical visualization
Data-driven decision making
Statistical programming
Data analysis
Data collection
Databases, data lakes, data warehouses
Building ETL and ELT Pipelines
Probability and statistics
Education
University of Illinois at Chicago | Chicago, IL Jan. 2022 - Present || M.Ed Measurement, Evaluation, Statistics & Assessment | Exp. May 2023
San Jose State University | San Jose, CA Jan. 2018 – May 2019 || Single Subject Credential – English | Cleared June 2021
University of California, Berkeley | Berkeley, CA Jan. 2010 - May 2014 || B.A. Philosophy | May 2014
Google Analytics, Google Ads, Google Tag Manager, Salesforce, Tableau, HTML, CSS, AMP, WordPress, Content Management Systems, MailChimp, Trello, Slack, Hive, Project management softwares, Google Suite (Sheets, Word, Meet, Slides, Forms, Classroom), Microsoft Suite (Excel, Word, PowerPoint, Power BI), SPSS, R, SQL, SAS, SEM, Editing, SEO
Jewish United Fund | Chicago, IL November 2023 – Current Data Analyst
Designed, built and maintained ETL pipelines with SQL that connected email deliverability, open, and clickthrough data with CMS Salesforce data to improve email practices. Combined with a regular dashboard and annual report monitoring unsubscribes, these practices resulted in a 61% decline in unsubscribes without negatively impacting CTR or open rates.
Designed & implemented interactive dashboards tracking donor behavior for direct response mail and email campaigns in Tableau and Power BI with DAX and mQuery that allowed end-users to customize views with drill-downs by key demographics.
Crafted reports to tell data-driven stories on topics including donations through direct response campaigns, engagement with our organization in various capacities, and donations as a function of demographic over time, steering fundraising, planning, allocation, and communications policy decisions at the senior level.
Proactively monitored and identified trends in ad spend to improve ROI for holiday ad spends by 120%.
Proactively monitored and identified trends in ad spend to improve ROI for holiday ad spends by 120%.
Collaborated with analysts in different departments to define a model for assigning Contacts an engagement score based on seven unique criteria then constructed a working model in PowerBI and PowerPivot Excel, using histograms to display the real distribution of scores across the existing population.
Nuts.com | Sunnyvale, CA December 2015 – December 2016 Web Content Strategist
Built and rebuilt content calendars based on data-driven decisions and reports made with Google Analytics, Mailchimp and more and organized team of content writers, health experts and developers with Slack
Designed, launched and spearheaded Nuts.com Scholarship which received more than 4,000 submissions and 30 high authority backlinks, improving the domain rank on a logarithmic scale and resulting in increased traffic and brand awareness
Coded responsive emails with HTML and CSS design, writing email copy for dynamic content in MailChimp, using the paid platform to manage dynamic sends for more than 500,000 active recipients
HealthyPets, Inc. | Union City, CA August 2013 – December 2015 Web Content Strategist
Crafted a style guide to ensure a consistent brand voice used across thousands of product descriptions, articles, video descriptions, newsletters, blog posts and content guides to establish and maintain a consistent voice for various channels published across three e-commerce websites, dozens of veterinary clinics, and brick and mortar stores
Slashed overhead costs to increase company net revenue by more than 2% through the development of a short expiry program, in which I worked with the warehouse manager as co-lead and managed a team of marketers and designers to set prices for perishable goods based on average and seasonal demand of each item after creating a program in Google Sheets with more thousands of lines of JavaScript code and a Standard Operating Procedure more than sixty pages in length
Reported key metrics including revenue, organic traffic, search engine rankings, and retention from content and promotion pages with Google Analytics, Google Ads, BrightEdge and Trello
Whitney M. Young Magnet High School (CPS) | Chicago, IL October 2022 – Present Pathways in Education Illinois (CPS) | Chicago, IL August 2021 – October 2022 Independent Study Teacher Fremont Unified School District | Fremont, CA July 2019 – June 2021 English Language Arts Teacher Mission Valley Swim Team Mission San Jose High School & Irvington High School | Fremont, CA August 2016 – July 2021 Varsity and JV Girls Water Polo Coach and JV Boys' and Girls' Swim Coach, Assistant Swim Coach (Ages 5-18)
Audit English curriculum intensively to improve outcomes for students and remove poorly developed items from assessments, resulting in three course changes and significant improvements in STAR scores for 80% of students with adjusted curriculum
Administer of Illinois Science Assessment to our school site for all juniors after completing required training, coordinated administration of STAR assessment for all students, and worked as a room monitor for the SAT and PSAT tests
Analyze STAR, Edmentum and Student Trac assessment data to create predictive models of student performance based on existing curricula so as to inform assignment of various tasks and to guide further instruction and response to intervention strategies
Pioneered the implementation of standards-based content units that were aligned to California Common Core standards within the English department, presenting an exhaustive analysis of its efficacy based on STAR and i-Ready assessment results
Developed new culturally inclusive curriculum that taught standards with short stories, poems, videos and novels from authors of varying races, genders, and sexualities with appropriately challenging and relevant material for seventh grade ELA students
Composed weekly newsletters that informed students and parents about changing practice, game and tournament schedules, special events, important dates and recruiting opportunities for collegiate play
Led teams to winning seasons, qualification for California Interscholastic Federation North Coast Section tournament and one team to win the Mission Valley Athletic League championship
College Advising Prep | Remote September 2019 – Present Tutor
Tutored English, Math, creative writing and formal logic for students ranging from fourth grade to high school seniors.
Created new and engaging content and lessons for students and used in combination with existing materials for the tutoring organization.
Shareably | Remote July 2017 – August 2019 Copywriter
Wrote, edited and designed articles for Shareably through Wordpress to create viral content that drives traffic and retention
Collaboratively managed workflow with Trello for articles from topic suggestion through publication
Researched article topics based on viral trends to determine topics and proposed topics for approval
Nuts.com | Sunnyvale, CA December 2015 – December 2016 Web Content Strategist
Built and rebuilt content calendars based on data-driven decisions and reports made with Google Analytics, Mailchimp and more and organized team of content writers, health experts and developers with Slack
Designed, launched and spearheaded Nuts.com Scholarship which received more than 4,000 submissions and 30 high authority backlinks, improving the domain rank on a logarithmic scale and resulting in increased traffic and brand awareness
Coded responsive emails with HTML and CSS design, writing email copy for dynamic content in MailChimp, using the paid platform to manage dynamic sends for more than 500,000 active recipients
HealthyPets, Inc. | Union City, CA June 2013 – December 2015 Web Content Strategist
Slashed overhead costs to increase company net revenue by more than 2% through the development of a short expiry program, in which I worked with the warehouse manager as co-lead and managed a team of marketers and designers to set prices for perishable goods based on average and seasonal demand of each item after creating a program in Google Sheets with more thousands of lines of JavaScript code and a Standard Operating Procedure more than sixty pages in length
Analyzed key metrics including revenue, organic traffic, search engine rankings, and retention from content and promotion pages with data generated in Google Analytics, Google Ads, BrightEdge and Trello and proposed marketing campaigns based with compelling visualizations of the data and digestible interpretations
Crafted a style guide to ensure a consistent brand voice used across thousands of product descriptions, articles, video descriptions, newsletters, blog posts and content guides to establish and maintain a consistent voice for various channels published across three e-commerce websites, dozens of veterinary clinics, and brick and mortar stores
Dereliq Designs | Fremont, CA May 2012 – October 2012 Director of Sales & Marketing | Co-founder
Performed outreach to secure press coverage in TechCrunch, B&H magazine, WSJ, and more while presenting a specific brand-image to promote our product, the camera lens shot glass
Increased net profits by 15% from initial offer through a carefully negotiated wholesale contract with established e-tailer PhotoJojo
Appcelerator, Inc. | Palo Alto, CA May 2012 – October 2012 Content Marketing Intern
Researched and wrote two marketing white papers on HTML5 Fragmentation and the importance of native app development
Wrote app descriptions for promotional website as service to apps
Other Interests
Juan enjoys cooking, caring for his cats, studying mathematics and literature, and writing poetry and prose. Juan has completed two Ironman triathlons, one in 2017 and another in 2019, both in Santa Rosa, California. Juan has had two poems published in SabrToothTiger Magazine.
