Looking for a job

Ethan Johnson

@ethanjohnson1

Message

Data analyst skilled in SQL, Python, and Power BI who turns data into actionable business insights.

United States

Message

What I'm looking for

I seek a data-focused role leveraging SQL, Python, and BI tools to drive product/marketing decisions, with opportunities for impact and growth.

I am a data analyst with strong academic performance and hands-on experience in SQL, Python, Power BI, and Excel, focused on transforming raw data into actionable insights. I have built end-to-end analyses — from data cleaning and feature engineering to visualization — to support marketing, product, and sponsorship decisions.

My projects include endorsement-targeting analysis for NBA athletes, multi-year bike-share behavior studies, and a secure hospital appointment system; I also founded and ran an ecommerce clothing brand where I applied analytics to drive customer acquisition and conversion improvements.

Experience

Work history, roles, and key accomplishments

Current

Founder & Owner

Current

Yeden

Dec 2021 - Present (4 years 2 months)

Founded and managed a direct-to-consumer clothing brand, increasing customer engagement 60% through targeted social media campaigns and driving a peak of 718 monthly store sessions while maintaining a 3% conversion rate.

Facebook Ads Instagram Ads SEO Excel Product Copywriting Google Analytics Social Media Marketing

Systems Developer (Project)

Hospital Appointment System

Apr 2023 - May 2023 (1 month)

Led development and testing of a secure hospital appointment system using SQL and MS Visio, designing ER models and data flows and ensuring reliable handling of patient and appointment data.

SQL MS Visio Database Design Data Security E R Model

Data Analyst (Project)

NBA Athlete Endorsement Analysis

Feb 2026 - Present (0 months)

Built a data-driven endorsement scoring model using SQL and Python to rank NBA athletes by endorsement upside and delivered multi-page Power BI dashboards to inform targeting and brand opportunities.

SQL Python Power BI Web Scraping Data Cleaning Data Visualization

Data Analyst (Case Study)

Cyclistic Bike Share Analysis

Jan 2026 - Present (1 month)

Analyzed multi-year bike-share data with SQL and Power BI to compare casual vs. member usage, uncovering behavioral differences to inform membership conversion and targeted marketing strategies.

SQL Power BI Excel Pivot Tables Data Cleaning Time Series Analysis Seasonality Analysis Data Visualization

Education

Degrees, certifications, and relevant coursework

California State University, Fullerton

Bachelor of Science, Information Systems and Decision Sciences

2019 - 2023

Grade: 3.83 GPA, magna cum laude

Activities and societies: Dean's List (2019-2023); member of Delta Sigma Pi (marketing, scholarship, recruitment, interchapter, finance, social committees).

Graduated magna cum laude with a cumulative GPA of 3.83 while completing coursework in information systems and decision sciences and making the Dean's List.