Business Intelligence Analyst

People Inc. is focused on transforming raw data into strategic insights that drive growth. The Business Intelligence Analyst will support campaign analytics, revenue reporting, and cross-functional data initiatives to enhance performance visibility and operational alignment across the organization.

Responsibilities

• Analyze performance across programmatic, paid social, SEM, curated PMP, and other digital media campaigns
• Pull and synthesize data from SQL queries, Looker dashboards, and other reporting systems
• Collaborate with Measurement and Trading teams to support campaign measurement frameworks and reporting execution
• Contribute to post-campaign reporting and performance analysis framework in partnership with leadership
• Support in-flight optimization discussions by providing data-driven insights to Trading, Client Services, and Sales teams
• Develop performance summaries and forward-looking recommendations for inclusion in post-campaign reports
• Provide reporting support to the Yield team to inform pricing, packaging, and inventory insights
• Proactively identify performance risks or discrepancies and escalate findings as appropriate
• Assist with weekly revenue reporting, sales activity reporting, and pipeline analysis in collaboration with Revenue Strategy
• Support reporting on KPIs and KPOs for Sales Leadership to ensure transparency and accountability
• Contribute to the development and maintenance of recurring and automated reporting processes
• Support sales performance analytics and maintain clean, accurate pipeline data
• Perform ongoing QA to ensure accuracy and consistency across reporting outputs
• Partner cross-functionally to resolve data discrepancies and maintain reporting integrity
• Partner regularly with Client Services, Sales, Trading, Yield, Revenue Strategy, Operations, and Product teams to provide analytical support
• Participate in client calls as needed to address reporting capabilities and performance insights
• Support RFP responses by articulating measurement methodologies and reporting capabilities
• Collaborate with Client Services to reinforce reporting standards and analytical best practices
• Provide performance insights to inform Product roadmap discussions
• Work with Engineering and Data teams to troubleshoot data issues, clean datasets, and backfill reporting gaps
• Conduct ongoing QA of campaign and revenue reporting datasets
• Support consistent KPI definitions and reporting standards across teams
• Assist in documenting reporting processes and methodologies
• Contribute to initiatives aimed at improving reporting efficiency and data reliability within D/Cipher

Skills

• Bachelor's degree in a related field or equivalent professional experience
• 1–3 years of experience in Business Intelligence, AdTech, Campaign Analytics, Revenue Analytics, or a related field
• Experience using BigQuery, Looker, or comparable data platforms
• SQL querying skills
• Advanced proficiency in Microsoft Excel (pivot tables, complex formulas, modeling)
• Experience analyzing multi-channel digital campaign performance and conversion attribution data
• Strong written and verbal communication skills
• Excellent communication and presentation skills, with the ability to translate data into clear, actionable insights and business narratives
• Familiarity with Salesforce Sales Cloud and marketing tools

Benefits

• Medical
• Dental
• Vision
• Prescription drug coverage
• Unlimited paid time off (PTO)
• Adoption or surrogate assistance
• Donation matching
• Tuition reimbursement
• Basic life insurance
• Basic accidental death & dismemberment
• Supplemental life insurance
• Supplemental accident insurance
• Commuter benefits
• Short term and long term disability
• Health savings and flexible spending accounts
• Family care benefits
• A generous 401K savings plan with a company match program
• 10-12 paid holidays annually
• Generous paid parental leave (birthing and non-birthing parents)
• Pet insurance
• Accident
• Critical and hospital indemnity health insurance coverage
• Life and disability insurance

Company Overview