Zillow
Reimagining real estate to make it easier than ever to move from one home to the next.
Business Intelligence Manager
Location
California + 7 moreAll locations: California, Connecticut, District of Columbia, New Jersey, New York, Maryland, Massachusetts, Washington
Posted
2 days ago
Salary
$98.9K - $158.1K / year
Bachelor Degree8 yrs expEnglishETLSQLTableau
Job Description
• Design, build, and own complex business intelligence datasets, semantic layers, and Tableau dashboards that model CXO performance across volume, efficiency, quality, and customer outcomes.
• Partner closely with data engineering to define data contracts, source system integrations, and transformation logic, ensuring reliable, scalable pipelines from operational systems (e.g., CRM, contact center platforms).
• Write, optimize, and maintain advanced SQL transformations (CTEs, window functions, performance-tuned queries) used in production reporting and analytics.
• Establish and steward a clear metric taxonomy and metadata framework, including definitions, documentation, and ownership used consistently across operational and executive reporting.
• Perform data validation, reconciliation, and root-cause analysis to ensure accuracy, consistency, and trust in CXO reporting.
• Design BI assets that support downstream use cases, including experimentation, automation, and AI-enabled customer experience initiatives.
• Create executive-ready dashboards and narratives that translate complex operational data into clear insights, risks, and opportunities.
Job Requirements
- 8+ years of experience in Business Intelligence, Analytics Engineering, or related analytical roles with hands-on ownership of data models and reporting assets.
- 4+ years of experience writing and optimizing complex SQL, including multi-CTE transformations, window functions, and large-scale joins.
- 4+ years experience with Tableau or related visualization tools
- Strong experience building Tableau dashboards backed by well-structured semantic layers, not just ad hoc queries.
- Solid understanding of ETL / ELT workflows, data pipelines, and how data moves from source systems to analytics layers.
- Experience working with APIs or operational system data, and the ability to reason about source data structure, refresh patterns, and data quality risks.
- Proven ability to define, document, and govern business metrics and metadata used by senior leadership.
- Comfortable navigating ambiguity in data and systems, and driving clarity through structured analysis and cross-functional collaboration.
Benefits
- Equity awards based on experience, performance and location