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.
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; 9% 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
- Demonstration of HTeaO's Mission, Vision, and Guiding Principles
- Delivery of exceptional service to internal and external stakeholders
- Contribution to team and company goals
- Commitment to accountability, continuous improvement, and growth
Acknowledgment
This job description is intended to describe the general requirements and responsibilities of the position and is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the role.
Work Authorization Requirement: Candidates must be legally authorized to work in the United States. HTeaO does not sponsor employment-based visas now or in the future for this position.
