BI Lead — Ads & Ecommerce

Publishers Clearing House (PCH) operates across advertising, ecommerce, and membership revenue streams. Clear, reliable analytics are foundational to informed decision-making and sustainable growth.

We are hiring a BI Lead to own analytics infrastructure and reporting across advertising and ecommerce. This role is accountable for building a single source of truth for performance, supporting financial reconciliation, and enabling data-driven decisions across teams.

What You’ll Own

Reporting & Dashboards

• Build and maintain dashboards in Looker

• Standardize KPI definitions across teams

• Provide executive level performance reporting

Ads & Revenue Reconciliation

• Ensure partner revenue reporting matches finance data

• Identify discrepancies and resolve inconsistencies

• Monitor revenue volatility and performance shifts

Ecommerce & LTV Modeling

• Develop CAC/LTV visibility

• Cohort retention tracking

• Support forecasting and budgeting

Data Governance

• Improve metric clarity and documentation

• Maintain reporting reliability

• Support cross functional analytical needs

What Success Looks Like (First 90 Days)

• Clean, standardized KPI framework

• Companywide dashboards

• Reliable revenue reconciliation processes

• Clear CAC:LTV visibility

• Improved reporting transparency

Required Experience

• 5–8+ years in BI or analytics roles

• Strong SQL proficiency

• Experience with ecommerce and advertising metrics

• Experience with Looker, BigQuery, or similar tools

This Role Is Not

• A purely technical data engineering role

• A passive reporting function

• A marketing analytics only position

Compensation & Benefits

• Competitive salary based on experience

• Medical, dental, and vision insurance, plus a range of additional voluntary benefits

• 401(k) with company match

• Flexible PTO and 15 paid holidays to rest and reset

• Remote-first culture with home office stipend

• Professional development budget

• 12 weeks of paid family leave to celebrate life’s biggest moments

PCH Digital LCC is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.