Principal BI Engineer

Job Overview

The Principal BI Engineer is critical to ensuring Prodege’s analytics ecosystem scales with the business by delivering a trusted, governed single source of truth that leaders rely on for high-stakes product and commercial decisions. The role architects durable BI and analytics foundations across Snowflake, dbt, Sigma, semantic and metrics layers, and standardized KPI frameworks to improve performance, reliability, and consistency while reducing rework, metric drift, and ad‑hoc reporting demand.

By enabling fast, self‑serve analytics with strong governance and data integrity, this role increases organizational speed without sacrificing trust or control.

• Architect and scale Prodege’s BI and analytics platform for long‑term performance and reliability
• Design high‑quality analytics data models that power consistent and trusted reporting
• Enable fast, self‑serve analytics without compromising governance or data integrity
• Partner with Product, Data Science, and business teams to translate needs into durable solutions
• Raise the bar on analytics engineering standards, tooling, and best practices
• Leverage AI‑based development and analytics tooling to accelerate delivery and quality

• Architect and Scale Prodege’s BI and Analytics Platform
• Design, build, and maintain scalable BI and analytics architectures that support both standardized reporting and self‑service analytics
• Define and guide the semantic / metrics layer strategy, including reusable metrics, governed KPI definitions, and trusted reporting foundations
• Architect BI capabilities that support executive / board reporting, experimentation, Product analytics, Growth, Yield, and business operations
• Guide teams on the right BI tools, semantic layer patterns, reporting structures, and data access models
• Continuously improve the performance, scalability, reliability, and cost efficiency of the BI environment
• Design high‑quality analytics data models
• Develop and manage dbt models on Snowflake, ensuring performance, accuracy, maintainability, and business usability
• Write, optimize, and tune complex SQL queries for large‑scale datasets
• Ensure standardized business logic and durable data modeling patterns across reporting domains
• Build and maintain dashboards, semantic layers, and reporting assets using Sigma (or similar BI tools)
• Enable and support self‑serve analytics while enforcing metric consistency, report usability, and governance
• Reduce dependency on engineering for routine reporting by creating reusable, well‑governed data and metrics foundations
• Improve how the organization accesses, interprets, and uses data for decision‑making
• Translate business questions into scalable BI and analytics designs
• Support experimentation, product analytics, Growth, Yield, and executive decision‑making through strong reporting foundations
• Implement analytics engineering best practices including testing, version control, documentation, code reviews, and semantic model governance
• Establish high standards for metric trust, report quality, maintainability, and consistency
• Mentor BI / analytics engineers and influence engineering standards across the organization
• Drive clarity and governance around KPI ownership and business logic changes
• Use AI‑powered tools to improve development velocity, validation, query generation, documentation, insight summarization, and metric discovery
• Identify where AI can meaningfully improve analytics workflows while maintaining strong human validation and business judgment
• Help teams use AI effectively to solve complex reporting, semantic modeling, and analytics problems

• Bachelor’s degree in Computer Science, Engineering, Analytics, a quantitative discipline, or equivalent practical experience
• Eight or more years of experience in BI, Analytics Engineering, Data Modeling, or Data Engineering
• Strong hands‑on expertise with Snowflake, dbt, Sigma (or comparable BI tools with strong semantic/metrics modeling experience), and advanced SQL optimization
• Proven experience designing and scaling modern BI platforms and reporting ecosystems, not just ad‑hoc dashboards or isolated reporting solutions
• Strong…