Finance Intern

H

HTO EMP LLC

Posted 3 months ago

Internship

Benbrook, Texas

In Person

Smart Summary

Responsibilities

Support the FP&A team by managing Power BI reporting, conducting monthly financial variance analysis, and evaluating marketing ROI. The role also involves analyzing new store opening performance and building Excel models to support strategic business decisions.

Qualifications

You are currently pursuing a degree in Finance, Accounting, Economics, or a related field, with strong proficiency in Microsoft Excel and working familiarity with Power BI. You possess strong analytical skills, attention to detail, and clear communication abilities, enabling you to translate data into actionable insights in a fast-paced environment.

Must Have Skills for ATS

Microsoft Excel

Power BI

SQL

Job Description

About the role

Location: HTeaO Corporate Office, Fort Worth, TX 

Schedule: Tuesday – Thursday (9:00 AM – 4:00 PM) 

Duration: Summer 2026 

Compensation: $15/hour + Perks (college credit available if applicable) 

Department: Finance 

Reports To: Manager of FP&A & Analytics (with exposure to the SVP of Finance and CFO) 

Job Description 

About HTeaO 

At HTeaO, we’re all about bold flavors and even stronger communiTEAs. As one of the fastest-growing beverage brands, we focus on creativity, connection, and supporting our Franchise Partners. 

Overview 

The HTeaO Finance Intern will support the FP&A & Analytics team in delivering the financial reporting, analysis, and insights that drive decision-making across the business. This role blends hands-on Power BI reporting with Excel-based financial modeling and ad hoc analysis, giving real-world exposure to how a high-growth, multi-unit franchise organization measures performance, evaluates investments, and communicates results to executive leadership. 

The ideal candidate is analytical, detail-oriented, comfortable working with large datasets, and excited to translate numbers into clear, actionable insights in a fast-paced environment. 



What You’ll Do 

Power BI Reporting & Analytics 

  • Pull, refresh, and distribute recurring Power BI reports for finance, operations, and executive stakeholders 
  • Validate report outputs against source data and flag inconsistencies 
  • Assist in building new dashboards and visuals to answer specific business questions (a plus, not required) 
  • Help maintain and document existing reports, data sources, and KPI definitions 
  • Support ad hoc data requests from Finance, Operations, Marketing, and Franchise Development 

Monthly Financial Analysis & Business Insights 

  • Assist with the monthly close and reporting cadence, including variance analysis (actuals vs. budget, forecast, and prior year) 
  • Help prepare materials for the Monthly Business Review (MBR) and other executive recurring meetings 
  • Identify trends, anomalies, and drivers in the data, and summarize findings in clear, executive-ready formats 
  • Partner with department leaders to understand the “why” behind the numbers and turn data into insight 

Marketing ROI Analysis 

  • Analyze the financial performance of marketing campaigns, promotions, and LTOs (limited time offers) 
  • Measure incremental revenue, transaction lift, and ROI against marketing spend 
  • Partner with the Marketing team to evaluate campaign effectiveness and inform future investment decisions 

New Store Opening (NSO) Analysis 

  • Track and analyze sales performance of newly opened franchise locations against pro forma and system benchmarks 
  • Help maintain NSO ramp curves and assist in updating assumptions used in forecasting and underwriting 
  • Build comparisons across cohorts (by region, build type, opening month) to identify performance drivers 
  • Support the franchise development team with data and reporting on the opening pipeline 

Ad Hoc Financial Modeling 

  • Build and maintain Excel models to support business cases, pricing decisions, capital projects, and special analyses 
  • Assist in scenario and sensitivity analysis to evaluate the financial impact of strategic decisions 
  • Help refine and stress-test existing forecasting and operating models 
  • Support the FP&A team during the annual operating plan (AOP) and long-range plan (LRP) cycles 

Cross-Functional & Executive Support 

  • Prepare clean, well-formatted deliverables suitable for VP, CFO, and ownership review 
  • Take notes and follow up on action items from finance meetings as needed 
  • Contribute ideas in team discussions and bring a curious, problem-solving mindset to projects 
  • Help wherever needed across the Finance & Operations team 

What Success Looks Like 

  • Recurring reports and analyses are delivered accurately and on time 
  • Data and outputs are reliable, well-documented, and easy for others to use 
  • Insights — not just numbers — make their way into business conversations 
  • Models and analyses are clean, well-structured, and easy to follow 
  • Communication with cross-functional partners is clear and professional 
  • You bring ideas, ask good questions, and take initiative 

Qualifications 

Required 

  • Currently pursuing a degree in Finance, Accounting, Economics, Data Analytics, or a related field 
  • Strong proficiency in Microsoft Excel (formulas, lookups, pivot tables, basic modeling) 
  • Working familiarity with Power BI — comfortable navigating, refreshing, and pulling reports 
  • Strong analytical and quantitative skills, with attention to detail and accuracy 
  • Clear written and verbal communication; able to translate analysis into plain English 
  • Organized and able to manage multiple projects and deadlines 
  • Reliable transportation 

Preferred 

  • Experience building Power BI reports, dashboards, or DAX measures 
  • Exposure to financial modeling, three-statement models, or scenario analysis 
  • Familiarity with SQL or other data query tools 
  • Previous finance, accounting, FP&A, or analytics internship experience 
  • Interest in franchise, multi-unit retail, or consumer/restaurant industries 
  • Junior or Senior in college 

What You’ll Gain 

  • Hands-on FP&A and analytics experience at a fast-growing franchise brand 
  • Direct exposure to senior leadership, including the VP of Finance and CFO 
  • Real ownership of analyses that inform executive and ownership decisions 
  • Practical experience with Power BI, Excel modeling, and multi-unit financial reporting 
  • Insight into how finance partners with Operations, Marketing, and Franchise Development 
  • A chance to contribute ideas and make a measurable impact 

Equal Opportunity Employer 

HTO EMP., LLC is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, or protected veteran status. Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal, state, and local ordinances. 

If you need assistance or an accommodation due to a disability, please contact us at ourteamcares@hteao.com. 

H

HTO EMP LLC

We are brewing up something incredible here at HTeaO. In January of 2018 we launched our franchise prototype store in Midland, TX. Our desire is to provide ultra-premium Tea, Water and related products that give people safe and healthy food choices in a fun and clean environment. We are committed to providing the absolute best quality iced tea money can buy in a retail environment. With the incredible support of our customers we are entering into a season where we teach, train and mentor franchisees in growing their own successful business. Would you like to join us?
Runway Icon
Boost Your Interview Chances

With Runway

See Your Fit for This Role

1-5 min

Your Score

?

Top Applicants

90%

Your Job Search Advantage

Key Gaps & Next Steps:

Address these in your resume & Interview

Top Strengths For This Role

Highlight these in your cover letter & interview

Your Interview Guide

A Personalized Interview Strategy

Freshest Opportunities

Never Miss a Good Fit

Get notified when jobs mach your criteria