JH

Jonathan Hernandez

Senior Data Analyst

jhernandezj590@gmail.com 951-478-4899 github.com/lordblah LinkedIn Profile
Moreno Valley, CA

Professional Summary

Highly analytical and detail-oriented Senior Data Analyst with a proven track record of solving complex data challenges. Possesses 6+ years of experience in developing robust data models, insightful visualizations, and comprehensive reports using SQL, Python, and Looker. Adept at extracting meaningful insights from large datasets, identifying anomalies, and delivering data-driven solutions. Skilled in translating technical findings into clear, concise presentations for stakeholders at all levels, driving informed decision-making.

Work Experience

Bizops Data Analyst/Analytics Engineer

Axonius

08/2023 - 05/2025
  • Designed and maintained robust data models within the data warehouse, ensuring data accuracy and accessibility
  • Utilized dbt to transform raw data into refined models, facilitating efficient analysis across the organization
  • Developed LookML to empower teams with self-service analytics capabilities, driving data-driven decision-making
  • Created insightful dashboards, analyzed data trends, and provided actionable recommendations to drive strategic initiatives
  • Maintained and monitored Fivetran data pipelines, ensuring reliability, data accuracy, and timely replication
  • Implemented GitHub Actions workflows to automate testing, notifications, and deployment related to dbt Transformations
  • Designed and implemented an end-to-end ETL pipeline resulting in significant cost savings and enhanced operational visibility
  • Spearheaded a data migration project within 3 months, enhancing fiscal year reporting accuracy across Looker dashboards

PDCI Senior Data Analyst

Wayfair

Perris, California, United States

02/2019 - 03/2023
  • Applied quantitative skills to answer high-level business and global strategy questions supporting operational initiatives
  • Expertise in designing and deploying data visualizations using Looker, Microsoft Power BI, and Tableau Desktop
  • Worked with 3PLs and 16 North American fulfillment sites, monitoring and reporting on KPIs
  • Utilized LEAN or Six Sigma methodology for multiple kaizen events
  • Drove end-to-end product development of Process Insights dashboard, improving IB Yard Dwell Compliance from 59.3% to 89.4%
  • Led the Oversold Clearance project, saving 200,000 tickets, 173 hours of labor, and $4,000 in analytics costs

CTE Worker II

Moreno Valley College

Moreno Valley, California, United States

06/2018 - 12/2020
  • Assisted staff, faculty, peers, and participants in support and training of technical tasks
  • Supported microcontrollers configuration and project assembly
  • Assisted in debugging source code (C++ and Python)

Technical Skills

Top Skills

CI/CD Fivetran ETL GitHub Actions

Programming & Databases

Python SQL TSQL C++ Google BigQuery Git

Analytics & Visualization

Looker LookML Tableau Desktop Power BI dbt

Tools & Platforms

Datadog Grafana Kibana

Methodologies

ETL Dimensional Modeling LEAN Six Sigma

Domain Expertise

Finance & Logistics GTM Product Data SaaS Metrics

Key Projects

ETL Transformation Layer Migration

Axonius

Designed and implemented an end-to-end ETL pipeline with a robust data transformation layer in GitHub Actions using Python, dbt, and Bash, resulting in significant cost savings and enhanced operational visibility through proactive monitoring and automated alerts.

IB Yard Dwell Compliance Improvement

Wayfair

Drove the end-to-end product development of a Process Insights dashboard, which enabled the identification and subsequent improvement of IB Yard Dwell Compliance from 59.3% to 89.4% through proactive operational alerts Network wide.

Cost Savings Initiative

Wayfair

Collaborated with MM and HDO teams to generate operational reports and provide process improvement suggestions, saving the company $500K in labor and lost product.

Education

Associate of Science in Computer Science

Moreno Valley College, Moreno Valley, CA

GPA: 3.2

06/2018 - 01/2026

Awards & Scholarships

Southern California Edison STEM Scholarship - May 2019

Scholarship for underrepresented students with financial needs pursuing STEM fields.