FP&A Analytics Intern: Power BI & Excel Insights

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

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,