Joshua Varley
00jgvarley@gmail.com • linkedin.com/in/JoshVarley • github.com/varvarley • varvarley.com
Education
Utah State University, Jon M. Huntsman School of Business
Logan, UT
Bachelor of Science: Data Analytics, Information Systems – Data Engineering Emphasis
May 2026
- GPA: 3.6, working 30 hours per week
- Member: USU Skateboard Club, Covey Leadership Club, USU Snow Club, Events Committee Volunteer
Tools
Languages: Python & SQL, Object Oriented Programming, LLM Workflow Automation
Technologies: Microsoft Excel, AWS, MS SQL, AI-assisted Development tools (Claude Code, Cursor)
Projects
Utah State University, Data 5330
Logan, UT
Sportsbook Data Mart
April 2025
- Built a Python ETL pipeline (pandas, psycopg2, pymssql) to load SQL Server and NFL CSV data into a normalized PostgreSQL data mart on AWS RDS
- Designed commission logic and analytical SQL queries for sportsbook performance and customer analysis across 2,000 records and 9 NFL seasons
- Developed OLS regression models for customer lifetime value prediction and documented the system with an ERD and data dictionary
Utah State University, Data 5360
Logan, UT
Data Warehousing & Analytics Project
April 2025
- Designed a 3NF operational model and built a relational ERD (Lucidchart) to standardize source structure
- Built staging layers and authored SQL models to normalize raw Fivetran loads from AWS RDS/S3 into Snowflake
Work Experience
Utah State University – Information Technology
Logan, UT
Computer Lab Consultant
Aug 2023 – Present
- Guided students, staff, and community members on lab tech, software, and printing workflows
- Operated and maintained Bambu Lab and Prusa 3D printers using 3D printing best practices
Creo Consulting
Provo, UT
Implementation Intern
Jan – April 2026
- Migrated client sales, marketing, and deal/contact data into HubSpot CRM, ensuring data integrity across platform onboarding
- Supported RevOps consulting engagements through HubSpot implementation and workflow automation across lead management and deal progression
Volunteer / Leadership
USU Skateboard Club
Logan, Utah
Vice President
Sep 2024 – May 2026
- Led growth by organizing and promoting events, teaching beginners, and managing logistics like scheduling and campus coordination
The Church of Jesus Christ of Latter-day Saints
Lima, Peru / Reno, Nevada
Full-Time Volunteer, Spanish Speaking
Aug 2019 – 2021
- Guided 6–12 member teams in goal setting and attainment
- Nurtured daily connections with individuals from diverse cultural, social, and religious backgrounds
- Delivered weekly training sessions on time management, service, and teaching
Skills / Interests
- Fluent in conversational & written Spanish
- Avid soccer enthusiast – 5A All-State goalkeeper, School record for most shutouts at Viewmont High, USU Men's Club Soccer, Intramural Champion