Finance Intern

htoemp; Fort Worth (TX); On-site; USD 17,908 - 23,419; Full time

Benefits offered by this job

College credit

Job summary

HTO EMP., LLC in Fort Worth, TX invites a Finance Intern to support FP&A and Analytics, blending Power BI reporting with Excel-based financial modeling. Youll work with the FP&A & Analytics team to deliver financial reporting, analysis, and insights for decisionmaking across the business, under the Manager of FP&A & Analytics.

The ideal candidate is analytical, detail-oriented, proficient in Excel, with Power BI familiarity, able to translate data into actionable insights in a fast-paced,

Qualifications

• 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.

Responsibilities

• 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.
• Help maintain and document existing reports, data sources, and KPI definitions.
• Support ad hoc data requests from Finance, Operations, Marketing, and Franchise Development.
• Assist with the monthly close and reporting cadence, including variance analysis.
• 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 for executives.
• Partner with department leaders to understand the “why” behind the numbers and turn data into insight.
• Analyze the financial performance of marketing campaigns, promotions, and LTOs.
• Measure incremental revenue, transaction lift, and ROI against marketing spend.
• Partner with Marketing to evaluate campaign effectiveness and inform future investments.
• Track and analyze sales performance of new franchise locations against pro-forma and system benchmarks.
• Help maintain NSO ramp curves and update forecasting assumptions.
• Build comparisons across cohorts to identify performance drivers.
• Support the franchise development team with data and reporting on opening pipeline.
• Build and maintain Excel models to support business cases and capital projects.
• Assist in scenario and sensitivity analysis to evaluate financial impact of strategic decisions.
• Refine and stress-test existing forecasting and operating models.
• Support FP&A during annual operating and long-range planning cycles.
• Prepare clean, well-formatted deliverables for VP, CFO, and ownership review.
• Take notes and follow up on action items from finance meetings.

Skills

Excel

Power BI

Financial analysis

Analytical thinking

Communication

Time management

Reliable transportation

Education

Pursuing a degree in Finance, Accounting, Economics, or Data Analytics

Tools

SQL

DAX

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 communicat…

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 [e-mail].