Principal BI Engineer

Prodege, LLC is a marketing and consumer insights platform that helps brands answer their business questions and grow revenue. They are seeking a Principal BI Engineer to architect and build a scalable BI and analytics platform, enabling trusted, self-serve analytics and driving alignment across various teams through standardized models and reporting frameworks.

Responsibilities:

• Architect and scale the 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: reusable metrics, governed KPI definitions, and trusted reporting foundations
• Architect BI capabilities for executive and 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 with performance, accuracy, maintainability, and business usability in mind
• Write, optimize, and tune complex SQL for large-scale datasets
• Design scalable models supporting product, commercial, experimentation, and executive reporting
• Ensure standardized business logic and durable modeling patterns across reporting domains
• Enable trusted, self-serve analytics
• Build and maintain dashboards, semantic layers, and reporting assets in Sigma (or similar BI tools)
• Enable self-serve analytics while enforcing metric consistency, report usability, and governance
• Reduce dependency on engineering for routine reporting through reusable, well-governed data and metrics foundations
• Improve how the organization accesses, interprets, and uses data for decisions
• Partner across teams to build durable solutions
• Work with Product, Data Engineering, Data Science, Finance, Analytics, and business teams to define metrics, KPIs, reporting requirements, and semantic structures
• Translate business questions into scalable BI and analytics designs
• Support experimentation, product analytics, Growth, Yield, and executive decision-making through strong reporting foundations
• Raise the bar on analytics engineering standards
• Implement best practices: testing, version control, documentation, code reviews, and semantic model governance
• Set high standards for metric trust, report quality, maintainability, and consistency
• Mentor BI and analytics engineers and influence engineering standards across the org
• Drive clarity and governance around KPI ownership and business logic changes
• Leverage AI-based development and analytics tooling
• Use AI-powered tools to improve development velocity, validation, query generation, documentation, insight summarization, and metric discovery
• Drive an AI-first mindset in BI, identifying where AI meaningfully improves workflows while keeping strong human validation and business judgment
• Help teams use AI effectively on complex reporting, semantic modeling, and analytics problems

Requirements:

• Bachelor's degree in Computer Science, Engineering, Analytics, a quantitative discipline, or equivalent practical experience
• 8+ years 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), and advanced SQL optimization
• Proven experience designing and scaling modern BI platforms and reporting ecosystems, not just ad hoc dashboards or isolated reporting
• Strong understanding of semantic/metrics layers, KPI standardization and governance, analytics architecture and data modeling, performance tuning and cost in BI environments, and self-service BI design and trusted reporting foundations
• Experience building production-grade analytics solutions that support business-critical decision-making
• Proven ability to collaborate with Product, Data Science, Data Engineering, Finance, Analytics, and business stakeholders
• Experience setting standards for reporting consistency, data quality, and semantic governance
• Strong mentoring and technical leadership experience, with the ability to influence architecture and BI practices across teams
• Experience using AI-based tooling to enhance analytics engineering, reporting workflows, developer productivity, or documentation quality
• Comfort working through ambiguity and helping define BI strategy in a greenfield or evolving environment
• Experience in AdTech, Performance Marketing, MarTech, marketplaces, or consumer internet platforms
• Familiarity with streaming or near-real-time analytics architectures
• Experience enabling analytics governance and metric standardization at scale
• Experience supporting experimentation platforms, product analytics, or Growth/Yield use cases
• Experience automating executive or board reporting
• Familiarity with AI-first or AI-assisted analytics and reporting workflows across BI teams