RevOps BI Architect

Design and maintain semantic layers and reporting models used in BI tools such as Looker,PowerBI, Tableau, or similar platforms

Define and maintain standardized metric definitions used across dashboards and reporting environments

Create reusable measures, calculated fields, and explore structures to support scalable reporting

Manage BI platform permissions, access controls, and governance

Maintain documentation for key reporting metrics, explores, and dashboards

Design and build executive and operational dashboards for revenue teams

Create reporting for pipeline, funnel, marketing performance, and revenue analytics

Develop reusable dashboard templates that can be deployed across multiple client environments

Structure dashboards to ensure clarity, usability, and decision-focused reporting

Maintain and improve existing dashboards to ensure accuracy and usability

Optimize BI queries, explores, and derived tables to improve dashboard performance

Identify and resolve slow queries or inefficient reporting structures

Work closely with Analytics Engineers to improve underlying data models for reporting

Implement best practices to reduce query costs and improve dashboard load times

Ensure reporting environments scale efficiently across multiple client environments

Standardize KPI definitions and reporting logic across dashboards and analytics environments

Establish and maintain dashboard naming conventions and reporting standards

Maintain an organized catalog of dashboards and reporting assets

Identify and consolidate duplicate or redundant reporting assets

Ensure reporting outputs remain consistent across stakeholders and systems

Design dashboards and visualizations that clearly communicate complex revenue insights

Translate analytical models and metrics into intuitive visual reporting experiences

Simplify complex analytics into clear visuals for executive and operational audiences

Ensure dashboards answer meaningful business questions rather than simply displaying data

Experience working with systems and metrics such as:

SaaS revenue metrics (ARR, MRR, ACV, TCV)

Pipeline and funnel analytics

Attribution reporting

Marketing automation platforms

LookML or semantic modeling frameworks

dbt metrics or transformation frameworks

Data UX and dashboard design best practices

Learn more about what it's like to work at Lean Layer here . Visa Sponsorship: Please note that we are not currently able to offer U.S. visa sponsorship or transfer for this position. For Canadian Residents : We also invite you to apply for this position but please note that at this time we can only hire those outside of the United States as full-time contractors. If you have any questions about this set up, please don't hesitate to reach out to.