Senior Analyst, Data & Business Intelligence
About The Position
The Senior Analyst, Data & Business Intelligence is HTeaO’s day-to-day owner of business reporting, ensuring that leaders across Operations, Finance, Marketing, and the support center have accurate, consistent, timely information for decision-making. The role takes over work from an external partner’s Snowflake and Power BI assessment and carries out the resulting practical work, including rationalizing Power BI content, establishing shared metric definitions, and building reliable reporting on Snowflake. The Senior Analyst works alongside an external data engineering partner, who leads Snowflake architecture and complex integrations, and gradually assumes broader platform ownership. The position offers a 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. The role partners with business teams to translate questions into dashboards, reports, and analysis; supports operational and strategic decisions; and maintains dependable data standards, integrations, and cost reporting. Candidates must be legally authorized to work in the United States. HTeaO does not sponsor employment-based visas for this position.
Requirements
- Bachelor’s degree in Information Systems, Business Analytics, Computer Science, or a 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.
- Strong SQL and data modeling fundamentals.
- Exceptional attention to detail and data accuracy.
- Ability to explain data clearly to operators, finance teams, and leaders.
- Ability to prioritize multiple projects, work independently, and collaborate across departments.
- Comfort working with outside partners and taking over work in progress.
- Continuous improvement mindset and strong problem-solving abilities.
- Legal authorization to work in the United States; employment-based visa sponsorship is not available.
Nice To Haves
- Snowflake experience.
- Experience cleaning up or consolidating an existing reporting environment.
- Experience in restaurant, QSR, retail, hospitality, franchise, or another multi-unit environment.
- Familiarity with restaurant systems such as OLO, Paytronix, Bikky, Crunchtime, 7shifts, POS platforms, and NetSuite.
- Interest in developing data engineering skills such as dbt, Git, and cloud cost management.
Responsibilities
- Serve as HTeaO’s internal point of contact for the Snowflake and Power BI assessment, absorb the external partner’s findings, and ensure knowledge transfer to the internal team.
- Help turn assessment findings into a prioritized work plan with IT leadership.
- Coordinate day-to-day with the external data partner, tracking deliverables, open items, and project milestones.
- Provide regular status updates on reporting and data work to IT leadership and business stakeholders.
- Rationalize Power BI reports and datasets, retiring duplicate and unused content.
- Build and maintain shared semantic models on Snowflake so reports use a single source of truth.
- Apply Power BI workspace, publishing, refresh, and access standards.
- Train and support report builders across the organization.
- Write Snowflake SQL models that move business logic out of Power BI, following standards established with the external data partner.
- Document data sources, models, and transformations so documentation remains current and accessible.
- Monitor data freshness and pipeline results, investigate issues, and escalate them to the data partner or vendors as needed.
- Grow ownership of Snowflake architecture, access, and transformation tooling such as dbt over time.
- Support onboarding of 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.
- 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 key metric definitions.
- Follow access and security practices for sensitive guest and employee data.
- Produce a monthly Snowflake cost and usage report, including cross-region data transfer from sources outside AWS US West.
- Flag unusual Snowflake spending and recommend savings, such as warehouse setting or query improvements, to IT leadership and the data partner.
- Serve as the go-to data partner for Operations, Finance, Marketing, and leadership.
- Translate business questions into dashboards, reports, and analysis.
- Support decisions about new locations, menu, labor, loyalty, and marketing with clear, reliable data.
- Model HTeaO’s Guiding Principles through service, transparency, and follow-through.
- Support special projects and strategic initiatives as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
