Principal BI Engineer

Job Description: Strategic Imperative: 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. This role architects durable BI and analytics foundations across Snowflake, dbt, Sigma, semantic / 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. Partnering closely with Product, Data Engineering, Data Science, Finance, Analytics, and business stakeholders , this leader translates evolving business needs into standardized models, semantic layers, reporting frameworks, and KPI definitions that drive aligned execution across Performance Marketing, Insights Yield, Consumer Experience, and executive reporting. As a principal-level technical influencer, this role elevates analytics engineering standards — testing, documentation, semantic modeling, code quality, report design, and tooling — while mentoring others to scale best practices across the organization. This role also helps move BI toward a more AI-first, self-service, and insight-driven operating model . Prodege: A cutting-edge marketing and consumer insights platform, Prodege has charted a course of innovation in the evolving technology landscape by helping leading brands, marketers, and agencies uncover the answers to their business questions, acquire new customers, increase revenue, and drive brand loyalty & product adoption. Bolstered by a major investment by Blackstone in Q1 2026, Prodege looks forward to more growth and innovation to empower our partners to gather meaningful, rich insights and better market to their target audiences. As an organization, we go the extra mile to “Create Rewarding Moments” every day for our partners, consumers, and team. Come join us today! Primary Objectives: 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 Qualifications - To perform this job successfully, an individual must be able to perform each job duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Detailed Job Duties: (typical monthly, weekly, daily tasks which support the primary objectives) 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 Design scalable analytics data models that support product, commercial, experimentation, and executive reporting use cases Ensure standardized business logic and durable data modeling patterns across reporting domains Enable Trusted, Self-Serve Analytics 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 Partner Across Teams to Translate Needs into Durable Solutions Work closely 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 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 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 within BI by identifying 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 The MUST Haves: ( ex: job cannot be done without these skills, education, experience, certifications, licenses ) Bachelor’s degree in Computer Science, Engineering, Analytics, a quantitative discipline, or equivalent practical experience Eight or more (8+) 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 understanding of: Semantic / metrics layers KPI standardization and governance A nalytics architecture and data modeling Performance tuning and cost considerations in BI environments Self-service BI design and trusted reporting foundations Experience building production-grade analytics solutions that support business-critical decision-making Proven ability to collaborate effectively 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 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 The Nice to Haves: (ex: preferred additional skills, education, experience, certifications, licenses ) 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 / board reporting Familiarity with AI-first / AI-assisted analytics and reporting workflows across BI teams Pay Transparency: The anticipated base salary range for this position is $240,000 TO $275,000. The final salary offered to a successful candidate will be dependent on several factors that may include, but are not limited to; the type and length of experience within the job, type and length of experience within the industry, the type and length of knowledge and skills for the position, education, training, etc. Prodege is a multi-state employer and final compensation within this range could be impacted by work location. Please note that the compensation details listed in US role postings reflect the base salary only, and do not include bonus, equity, or benefits. Prodege Benefits: Prodege offers a comprehensive benefits package to US Full-time employees including medical, dental, vision, STD, LTD and basic life insurance. Employees receive flexible PTO, as well as paid sick leave prorated based on hire date. US Employees have eight paid holidays throughout the calendar year. Equal Employment Opportunity Statement At Prodege, we are committed to creating a diverse and inclusive environment. We are proud to be an Equal Opportunity Employer and do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, or any other characteristic protected by law. We encourage individuals of all backgrounds to apply. FCIHO Employers will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of FCIHO.