John Linford

About

I'm that weird blend for times when it isn't quite a quantitative project... but it's not fully for sales or marketing either. I understand how to do complex data gathering, analysis, and dashboarding just as easily as doing problem interviews or stakeholder presentations. Call me your analytical Swiss-army knife. Looking forward to chatting soon.

Experience

• Chief of Staff · Scan12308-01-2023

  Contributing member of the executive team, responsible for market/competitive strategy, research, & insights Drove $53.5K in new market ARR from data-validated research & an end-to-end GTM plan Built data pipeline to a Sheets dashboard of 21 inter-departmental metrics w/ Python, AppScript, SQL, and Zapier

• Data Analyst · Castiron04-01-2023 – 07-01-2023

  Built 79 analyses & 27 dashboards, with data housed in BigQuery, ProfitWell, Amplitude, Segment, Hotjar, & GA4 Wrote 3 publicly published blog articles for artisans pricing based on 128 lines of SQL code, joining 7 databases Revamped the OKR structure from ~15 different goals to 7 concrete, measurable quarterly goals for the exec. team

• Strategy Analyst · Philo Ventures (VC)01-01-2023 – 05-01-2023

  Designed 7 presentation decks for 2 portfolio companies, shown to 38 potential clients, partners, and large customers Created 5 rev. models, used to sign 3 new clients with unique fee structures and uncleaned data (123K total rows) Drafted a financial pro forma for a Portco., projecting opex, cash flow, expenses, and profit for the next 5 years

• Business Analyst · OPTIO02-12-2022 – 08-31-2022

  Formulated complex founding stories and financial data to build 17 client pitch decks (Keynote) in a team of three Created a Python script to scrape 8,708 investor portfolios to an Airtable as an add-on resource for clients Designed a sales funnel and operations playbook (ClickUp) that shortened the project timeline from 21 to 10 days

• Managing Director · The Social Venture Academy11-01-2021 – 05-01-2022

  -The Social Venture Academy is a incubator for student ventures, providing training in ideation, validation, pitching, and raising capital -Led a team to curate a new curriculum for class seminars, including hands-on assignments and real-world application in pitching ideas -Mentored dozens of new startup founders to receive tens of thousands in funding through the BYU Ballard Center

• Business Analyst · Cougar Consulting Group12-20-2021 – 04-20-2022

  -Consulted with a multi-media customer care company to create a market expansion recommendation -Utilized cold calling, market research, and KPI analytics to understand the market, all folded into a final PowerPoint presentation to the client

• Sales Manager · Edge The Service Company04-17-2020 – 10-20-2021

  Door to door representative generating my own sales while leading a team to generate half a million in revenue over a summer. Worked daily without supervision to knock 8-10 hours a day and trained multiple first-time knockers to success.

• Research Assistant · BYU Harold B. Lee Library08-20-2020 – 04-20-2021

  -Utilized Excel to code for a project on explanations of anger in the Christian canon of scripture -Conducted literature reviews on topics such as gender interactions in the workplace, ego depletion, and motivation -Contributed to a paper published in AMCAP

• Professional Magician (Self-employed) · Linford Magic01-20-2017

  -Performed and paid consistently for work parties, family reunions, birthday parties, group dates, and young adult group activities

• Data Analyst · Jan Garbett for Utah Congress03-17-2018 – 06-17-2018

  -Created geographical profiles and personally contacted influencers to invite them to the local caucus meetings for the candidate. -Designed and implemented a group-think style discussion panel. Critiqued public speaking and stylistic attributes of a public political image.

Education

• Brigham Young UniversityBachelor's Degree, Statistics

Similar talent on Pangea

Mohammed E.BI Analyst | Building end-to-end insight systems that guide leadership decisions before questions arise | Power BI, Fabric, SQL, PythonAbu Dhabi - United Arab EmiratesReed G.Senior Data Scientist & Venture Capital AssociateSan Clemente, CASarah S.Data Analyst | Driving Data-Driven Decisions |Colorado Springs, CORolonda H.Transforming Business with Data & Strategy | | Empowering Growth Through AnalyticsNorth Carolina, USA