Data Analyst

HydroJug; Ogden (UT); On-site; USD 70,000 - 100,000; Full time

Job summary

HydroJug, Inc. is seeking a data analyst for the Finance team in Ogden, UT. The role partners with the CFO and Finance staff to deliver brand-focused reporting, FP&A support, and inventory accounting data inputs.

You will be the Finance team's primary analytics resource within the BI & Data group. You will build P&L views by brand, deliver actuals and forecasts, and create finance dashboards for self-service.

Qualifications

• 3–5 years in a data analyst, FP&A, or financial analyst role with strong analytics
• Proficiency in SQL (BigQuery preferred); write and optimize queries independently
• Experience producing brand- or segment-level P&L reporting, ideally in multi-channel retail/ecommerce
• Familiarity with FP&A workflows: actuals vs. budget, variance analysis, rolling forecasts
• Working knowledge of inventory accounting concepts (COGS, landed cost, aged inventory)
• Experience with Looker, Tableau, or comparable BI tool
• Strong attention to detail; clear communication with Finance stakeholders

Responsibilities

• Brand-Dimensioned Reporting — Build and maintain P&L views by brand and ensure current numbers
• FP&A Support — Provide actuals, variance analysis, and forecast inputs for budgets
• Inventory Accounting Inputs — Produce inventory valuation, COGS, and aged-inventory reports
• Data Quality for Finance — Collaborate to validate and document Finance-critical data
• Self-Serve Enablement — Create Finance dashboards in Looker/Tableau for self-service
• Ad Hoc Analysis — Translate business questions into SQL queries and outputs

Skills

SQL proficiency

P&L reporting

FP&A processes

Data quality mindset

Tools

Looker

Tableau

BigQuery

Job description

HydroJug, Inc. — Systems Team / BI & Data Ogden, UT | On-Site | Reports to Data Lead

About the Role

This is the dedicated data analyst seat for Finance. You will partner daily with CFO Aaron Davis and the Finance team (Russ, Trent) to deliver brand-dimensioned reporting, FP&A support, and inventory accounting data inputs. Finance has historically been under-served by data — this role exists to fix that. You will work within the BI & Data team (reporting to the Data Lead) and be the Finance team's primary analytics resource.

Responsibilities

• Brand-Dimensioned Reporting — Build and maintain P&L views segmented by brand (HydroJug, Acta, Puressentials); keep Finance operating on current numbers
• FP&A Support — Deliver actuals, variance analysis, and forecast inputs on cadence; support budgeting cycles with data extracts and model-ready outputs
• Inventory Accounting Inputs — Produce inventory valuation, COGS, and aged-inventory reports that feed accounting entries
• Data Quality for Finance — Partner with the Data Quality analyst to ensure Finance-critical data is validated, documented, and trustworthy
• Self-Serve Enablement — Build Finance-facing dashboards in Looker/Tableau so the team can pull their own numbers between reporting cycles
• Ad Hoc Analysis — Handle Finance's one-off data requests; translate business questions into SQL queries and structured outputs

Qualifications

• 3–5 years in a data analyst, FP&A analyst, or financial analyst role with a strong analytics component
• Proficiency in SQL (BigQuery preferred); able to write and optimize queries independently
• Experience producing brand- or segment-level P&L reporting, ideally in a multi-channel retail or ecommerce environment
• Familiarity with FP&A workflows: actuals vs. budget, variance analysis, rolling forecasts
• Working knowledge of inventory accounting concepts (COGS, landed cost, aged inventory)
• Experience with Looker, Tableau, or a comparable BI tool
• Strong attention to detail and a habits-of-accuracy mentality — Finance data errors have real consequences
• Clear communication with Finance stakeholders; comfortable presenting findings to the CFO

About HydroJug, Inc.

HydroJug, Inc. is a consumer brand headquartered in Ogden, Utah, designing and selling premium hydration and lifestyle products through direct-to-consumer and major retail channels.