Senior Analyst, Data & Business Intelligence

Position Information

• Position Title: Senior Analyst, Data & Business Intelligence
• Department: Information Technology
• Reports To: Head of Information Technology
• FLSA Status: Exempt
• Location: Fort Worth, TX.

About HTeaO

What started as a small family side business serving iced tea in Amarillo, Texas, has grown into the nation's leading iced tea franchise. Since officially launching the HTeaO brand in 2018, we've expanded across multiple states while staying true to the values that got us here. At HTeaO, we exist to refresh lives together; one cup, one person, one community at a time. Our vision is to become every community's most enjoyed beverage brand.

Our Guiding Principles

Put People First - Create meaningful connections at every opportunity.

Keep It Simple - Focus on what matters most; consistency, real tea, brewed fresh.

Build Genuine Partnerships - Work together with humility and transparency.

Own It - Be accountable to the outcomes, the successes, and the mistakes.

Position Summary

The Senior Analyst, Data & Business Intelligence is HTeaO's day-to-day owner of business reporting, ensuring leaders across Operations, Finance, Marketing, and the support center have accurate, consistent, and timely information to make decisions. This role picks up the Snowflake and Power BI assessment underway with an outside partner and leads the practical work that follows: cleaning up Power BI, defining shared metrics, and building reliable reporting on Snowflake.

The Senior Analyst works alongside an outside data engineering partner, who leads Snowflake architecture and complex integrations, and grows into broader platform ownership over time. This role offers a clear development path toward Manager, Data & Business Intelligence as the data function expands, with company support for relevant certifications such as SnowPro and Microsoft PL-300.

Key Responsibilities

Assessment Transition & Roadmap Support

Serve as HTeaO's internal point of contact for the Snowflake and Power BI assessment; absorb the outside partner's findings and ensure knowledge transfers to the internal team.

Help turn assessment findings into a prioritized work plan with IT leadership.

Coordinate day-to-day with the outside data partner, tracking deliverables, open items, and project milestones.

Provide regular status updates on reporting and data work to IT leadership and business stakeholders.

Power BI Reporting & Modernization

Rationalize existing Power BI reports and datasets; retire duplicate and unused content.

Build and maintain shared semantic models on Snowflake so reports use one source of truth.

Apply workspace, publishing, refresh, and access standards across Power BI.

Train and support report builders across the organization.

Snowflake Data Modeling

Write SQL models in Snowflake that move business logic out of Power BI, following standards set with the outside data partner.

Document data sources, models, and transformations so they are current and easy to find.

Monitor data freshness and pipeline results; investigate issues and escalate to the data partner or vendors as needed.

Grow ownership of Snowflake architecture, access, and transformation tooling (e.g., dbt) over time.

Systems Integration Support

Support onboarding of the new POS, Paytronix, Bikky, Crunchtime, and 7shifts data into Snowflake alongside existing OLO data.

Validate new data against source systems before it is used in reporting.

Help map NetSuite financial data so operational and financial reporting reconcile.

Maintain shared reference data, including locations, menu items, and calendar.

Metric Definitions & Data Standards

Build and maintain a company-wide metric catalog, including net sales, transactions, average ticket, comparable store sales, labor percentage, cost of goods, and loyalty engagement.

Partner with business owners to approve and maintain each key metric definition.

Follow access and security practices for sensitive data, including guest and employee information.

Cost Monitoring

Produce a monthly Snowflake cost and usage report, including cross-region data transfer from sources outside AWS US West.

Flag unusual spend and recommend savings, such as warehouse settings and query improvements, to IT leadership and the data partner.

Business Partnership

Serve as the go-to data partner for Operations, Finance, Marketing, and leadership.

Translate business questions into dashboards, reports, and analysis.

Support decisions on new locations, menu, labor, loyalty, and marketing with clear, reliable data.

Model HTeaO's Guiding Principles—Put People First, Keep It Simple, Build Genuine Partnerships, and Own It—through service, transparency, and follow-through.

Support special projects and strategic initiatives as assigned.

Qualifications

Education & Experience

Bachelor's degree in Information Systems, Business Analytics, Computer Science, or related field, or equivalent relevant experience.

3–5 years of experience in business intelligence, reporting, or data analytics.

Strong Power BI experience, including data modeling, DAX, and report design.

Experience writing SQL against a cloud data warehouse; Snowflake experience strongly preferred.

Experience cleaning up or consolidating an existing reporting environment preferred.

Experience within restaurant, QSR, retail, hospitality, franchise, or other multi-unit environments preferred.

Knowledge, Skills & Abilities

Strong SQL and data modeling fundamentals.

Exceptional attention to detail and data accuracy.

Ability to explain data clearly to operators, finance teams, and leaders.

Familiarity with restaurant systems such as OLO, Paytronix, Bikky, Crunchtime, 7shifts, POS platforms, and NetSuite preferred.

Interest in growing into data engineering skills such as dbt, Git, and cloud cost management.

Comfortable working with outside partners and taking over work in progress.

Ability to prioritize multiple projects while working independently and collaborating across departments.

Continuous improvement mindset with strong problem-solving abilities.

Key Performance Indicators (KPIs)

KPI

Target

Key Tactics

Assessment Transition

Knowledge transfer from the outside partner completed within 60 days; work plan agreed with IT leadership within 90 days

Shadow partner sessions, document current state, prioritize findings with IT leadership, track open items

Reporting Modernization

30% reduction in duplicate or unused Power BI reports and datasets in year one; core dashboards running on shared semantic models

Audit report usage, consolidate datasets, retire redundant content, train report builders

Business Logic in Snowflake

Business logic for the top 10 priority reports moved into Snowflake models in year one

Prioritize reports with stakeholders, build SQL models to partner standards, validate results before cutover

Metric Consistency & Trust

100% of core business metrics defined, documented, and approved by business owners

Build metric catalog, hold review sessions with metric owners, apply definitions in shared models

Data Quality & Integration Support

100% of new system data validated against source before go-live; data issues escalated within one business day

Reconcile new feeds to source reports, monitor daily loads, coordinate fixes with partner and vendors

Cost Visibility

Monthly Snowflake cost and usage report delivered; unusual spend flagged within one week

Review usage dashboards, track cross-region transfer, recommend savings to IT leadership and partner

Business Partnership & Service

Data requests acknowledged within one business day; ≥90% stakeholder satisfaction

Maintain request intake process, set clear timelines, gather stakeholder feedback quarterly

How Success Is Measured

Success at HTeaO is measured through:

Achievement of role-specific responsibilities and KPIs