Summary
Overview
Work History
Education
Skills
Awards
Timeline
Generic

Jillian Johnson

Mansfield,Tx

Summary

Experienced analyst with a Master's in Business Analytics and proficiency in Python, SQL, Power BI, and Alteryx. Skilled at converting intricate data into actionable insights, creating dashboards, and improving reporting processes. Seeking to shift from consulting to a role centered on driving business results through analytics and model development.

Overview

2
2
years of professional experience

Work History

Data Analyst

Capitalize Consulting
08.2024 - Current
  • Analyzed large, complex datasets using SQL, Alteryx, and Power BI to support strategic decision-making
  • Designed and maintained data pipelines to produce YTD dashboards; used forecast modeling to track POS and AUR trends
  • Led group trainings (50+ attendees) on data automation tools; collaborated with client teams to define KPIs and business goals
  • Customized SharePoint UI using JSON to streamline data access and improve reporting UX

MSBA Capstone Project Consultant

Brilliantly Warm
01.2024 - 05.2024
  • Conducted market segmentation and statistical analysis across 3 core customer groups, identifying 2 segments with high potential for conversion growth
  • Designed predictive dashboards in Power BI using industry and behavioral data, improving targeting strategies and informing 3 new campaign decisions
  • Presented modeling insights to stakeholders and recommended strategies aligned with 10–15% projected lift in customer lifetime value and improved ROI projections

Operations Coordinator

Accelerate DFW
05.2023 - 09.2023
  • Organized and hosted 10+ events focused on innovation and entrepreneurship, working with city stakeholders and tech founders
  • Used HubSpot CRM to track contacts, automate follow-ups, and segment leads for outreach campaigns
  • Partnered with business leaders and small business owners to gather qualitative data on resource needs

Education

Master of Science - Business Analytics

Texas Christian University, Neeley School of Business
Fort Worth, TX
05.2024

BBA - Business Information Systems

Texas Christian University, Neeley School of Business
Fort Worth, TX
05.2023

Skills

  • Software Skills: SQL, Python, Excel, Tableau, SAP, Git Hub, Power BI, ETL, Alteryx, Ui Path, PowerPoint
  • Certifications: Microsoft office (Word, Excel, PowerPoint), Alteryx Advanced, Alteryx Cloud, Alteryx Designer
  • Data quality assurance processes
  • Systems Thinking
  • Visual data representation
  • Data formatting
  • Project management
  • Robotic Process automation
  • Large dataset manipulation
  • Business requirements gathering
  • Database management
  • Agile framework

Awards

TCU High Jump and Heptathlon School Record holder, Chancellor invitee for NYSE bell-ringing, TCU Investors Society Panel Speaker, All-Academic Team, NCAA Division 1 All-American, Athletic Scholarship Recipient

Timeline

Data Analyst

Capitalize Consulting
08.2024 - Current

MSBA Capstone Project Consultant

Brilliantly Warm
01.2024 - 05.2024

Operations Coordinator

Accelerate DFW
05.2023 - 09.2023

Master of Science - Business Analytics

Texas Christian University, Neeley School of Business

BBA - Business Information Systems

Texas Christian University, Neeley School of Business

Similar Profiles

CREATE PROFILE