Product Manager —Data Warehouse

Sumeru Solutions

Not Interested
Bookmark
Report This Job

profile Job Location:

Irvine, CA - USA

profile Monthly Salary: Not Disclosed
Posted on: Yesterday
Vacancies: 1 Vacancy

Job Summary

About the role

Own the roadmap for Data Warehouse -the analytics backbone used by self-storage operators for revenue operations finance and portfolio decisions. Youll translate business questions into trustworthy metrics and BI experiences and youll be hands-on with DAX and SQL to validate logic prototype measures and guide engineering toward scalable models. TDW emphasizes operator control/ownership of data and provides unfettered access to raw operational data with BI tooling and pre-defined dashboards enabling data-driven decision-making across portfolios.

What youll do
  • Own vision & roadmap for TDW Hummingbird Reports across billing payments finance operations and marketing use cases.
  • Translate business questions into data products: define KPIs metric logic semantic models and report templates (exec dashboards property/operator views portfolio rollups).
  • Define metrics & semantics: write business definitions acceptance tests and reference DAX/SQL for core KPIs (e.g. occupancy delinquency AR aging payment failures revenue recognition).
  • Partner with Data Engineering on modeling (star schemas SCD handling) pipeline priorities (ELT/ETL) data quality SLAs and observability.
  • Be hands-on with analytics: prototype DAX measures (CALCULATE/FILTER time intelligence iterators RLS) craft SQL (joins windows partitions) for validation and reconcile report vs. source discrepancies.
  • Model & data quality partnership: collaborate with Data Eng on star design SCD handling incremental refresh/partitioning data contracts and quality SLAs.
  • Ship BI experiences: standardize datasets RLS refresh cadence and a governed report catalog; drive adoption and performance (P95 load time on-time refresh).
  • Governance & compliance: document lineage/ownership enforce access controls/PII handling and support auditability for finance reporting.
  • Stakeholder leadership: run discovery with Operators CS Finance and Product; write crisp PRDs and prioritize trade-offs; track impact with usage analytics.
  • Drive accuracy & trust: establish metric definitions lineage and documentation; resolve discrepancies (e.g. dashboard vs. report vs. snapshot mismatches).
  • Improve performance & freshness: work with eng to optimize query plans partitions aggregations and incremental refresh to hit latency/freshness targets.
  • Measure impact: instrument adoption reliability and time-to-insight; iterate based on usage analytics and feedback.
Minimum qualifications
  • 5 years in Product Management (Data/Analytics/BI-focused) or adjacent Analytics PM roles.
  • Strong DAX proficiency (time intelligence CALCULATE/ALL/ALLEXCEPT USERELATIONSHIP SUMX/iterators row-level security).
  • Advanced SQL across large datasets (CTEs window functions performance tuning data validation).
  • Practical understanding of dimensional modeling (facts/dims grain/keys SCD) semantic layers and metric governance.
  • Proven ability to author PRDs/acceptance criteria drive cross-functional delivery and measure product impact.
  • Experience with Power BI (datasets dataflows gateways incremental refresh deployment pipelines) or equivalent BI tools.
Preferred qualifications
  • Warehouse/pipeline tools (Snowflake/BigQuery/Redshift/Postgres dbt Airflow/Fivetran).
  • Observability/quality frameworks (Great Expectations/Monte Carlo) and basic Python for data checks.
  • Domain familiarity with payments/billing/accounting analytics (settlements chargebacks subscription metrics AR).
  • Observability/quality: Great Expectations Monte Carlo New Relic or similar.
  • Experience building report governance (catalogs metric stores lineage roles).
About the role Own the roadmap for Data Warehouse -the analytics backbone used by self-storage operators for revenue operations finance and portfolio decisions. Youll translate business questions into trustworthy metrics and BI experiences and youll be hands-on with DAX and SQL to validate logic pro...
View more view more

Key Skills

  • Shipping & Receiving
  • Inventory Control
  • Forklift
  • Continuous Improvement
  • Warehouse Management
  • Warehouse Experience
  • Warehouse Distribution Experience
  • Warehouse Management System
  • Leadership Experience
  • Supervising Experience
  • Logistics
  • 3PL