What are the responsibilities and job description for the Principal Business Intelligence Engineer position at Prodege, LLC?
Strategic Imperative:
This Principal Business Intelligence Engineer role is integral to Prodege’s ability to make fast, confident, and data-driven decisions at scale. The Principal BI Engineer will architect and evolve our analytics and reporting foundation—ensuring business leaders, Product, and Data Science teams have trusted, performant, and scalable access to insights. This role bridges business strategy and engineering execution, enabling long-term growth across Performance Marketing, Insights Yield, and Consumer Experience.
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 Great Hill Partners in Q4 2021 and strategic acquisitions of Pollfish, BitBurst & AdGate Media in 2022, 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)
- Design, build, and maintain scalable BI and analytics architectures
- Develop and manage dbt models on Snowflake, ensuring performance, accuracy, and maintainability
- Write, optimize, and tune complex SQL queries for large-scale datasets
- Build and maintain dashboards, metrics, and semantic layers using Sigma
- Work closely with Product and Data Science to define metrics, KPIs, and reporting requirements
- Implement analytics engineering best practices (testing, version control, documentation, code reviews)
- Enable and support self-serve analytics while enforcing metric consistency and governance
- Leverage AI-powered tools to improve development velocity, validation, and documentation
- Mentor BI and analytics engineers and influence engineering standards across the organization
What does SUCCESS look like?
Success means that business and product leaders trust analytics as their single source of truth, supported by fast, reliable, and widely adopted dashboards that drive confident decision‑making. Analytics models scale seamlessly with the business, eliminating constant rework, while BI delivery speed improves without sacrificing quality or consistency. There is strong alignment across Product, Data Science, and Tech on analytics priorities, ensuring unified execution. As a result, self‑serve analytics adoption increases and ad‑hoc reporting meaningfully declines as teams become more empowered and data‑driven.
The MUST Haves: (ex: job cannot be done without these skills, education, experience, certifications, licenses)
- 8 years of experience in BI, Analytics Engineering, or Data Engineering
- Strong hands-on expertise with Snowflake, dbt, Sigma (or comparable BI tools with semantic modeling experience), and Advanced SQL optimization
- Experience building production-grade analytics solutions, not just ad-hoc reports
- Strong understanding of analytics architecture, data modeling, and performance tuning
- Proven ability to collaborate with Product, Data Science, and business stakeholders
- Experience using AI-based tooling to enhance analytics or developer productivity
The Nice to Haves: (ex: preferred additional skills, education, experience, certifications, licenses)
- Experience in ad tech, performance marketing, marketplaces, or consumer platforms
- Familiarity with streaming or near-real-time analytics architectures
- Experience enabling analytics governance and metric standardization at scale
- Mentorship or technical leadership experience
- Exposure to ML-driven analytics or experimentation platforms
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. Employees receive an option to purchase shares of Company stock commensurate with their position, which vests over four years.
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.