Juan Madrigal | Chicago-based Data Analyst

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

Jewish United Fund | Chicago, IL November 2023 – Current
Data Analyst

Engaged in learning opportunities and practices to understand JUF / Federation structure and Jewish culture & history
Completed DREAM, tech & Salesforce trainings for software tools, including Salesforce DREAM, Lyris List Manager, Google Analytics 4, and SQL
Researched existing capabilities of and possible alternatives for email marketing solutions that would allow for A/B testing, segmentation, and automation
Developed and presented several reports for promotions and databases with statistical analysis and data visualization software
Evaluated and documented history of A/B testing and procedures for designing and conducting A/B tests, and collaboratively ran and reported two A/B tests and began planning future, recurring tests
Developed and maintained monthly dashboard to track Contacts opting out of email contact (4 months and ongoing)
Audited Dream Reports folder and met with stakeholders to improve both workflow of departments and data validation across organization, examining existing usage and recommending alternative organizations / heirarchies
Performed ad hoc reporting from DREAM, GA4 and Lyris LM and trained others on using these platforms to access, understand and utilize data
Develop and pursue MMM / MTA project to improve reporting and data–driven decisions for MarCom

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

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:

Email Me

Education

TECHNICAL SKILLS