Remote Jobs RockRemote Jobs Rock

Business Intelligence Associate

🕒 6 days ago
Business IntelligenceRevenue ForecastingData AnalysisExcel
Apply Now

📜 Description

  • Monitor hourly and daily revenue trends, investigate declines, identify root causes, and coordinate responses with relevant teams.
  • Own weekly revenue forecasting, define variance thresholds, investigate metric deviations, and provide executive updates.
  • Lead monthly reviews of spend drivers with Marketplace, Product, and Engineering stakeholders; contribute to quarterly and annual planning.
  • Manage cross-functional investigation workstreams and provide updates to steering committees.
  • Improve monitoring frameworks, reduce data blind spots, and work with Product Management and vendors to enhance anomaly detection.
  • Track and quantify the impact of monetization product releases and recovery efforts.

🛠️ Requirements

  • 4 to 6 years of experience in data analysis or a similar role preferred.
  • Bachelor's or master's degree in computer science, data science, statistics, mathematics, engineering, or a related field.
  • Strong analytical thinking, problem-solving skills, attention to detail, and ability to work with ambiguous data.
  • Ability to communicate complex findings clearly and actionably to technical and non-technical stakeholders.
  • Proficiency with Excel, Looker, MySQL, forecasting, impact measurement, and A/B testing.
  • Strong knowledge of data manipulation and analysis; familiarity with anomaly detection, supervised and unsupervised learning, time-series analysis, and outlier detection.
  • Excel macros/VBA, Python, ad tech experience, and GenAI tools such as Cursor or Claude are advantageous.

✨ Benefits

  • Paternity and maternity leave
  • Healthcare insurance
  • Broadband reimbursement
  • Healthy snacks and drinks in the office
  • Catered lunches
Full job description

About the Role

Your role as a Business Intelligence Associate is to work with the product and machine learning team to automate the process of manual forecasting and identify the root causes. You are expected to detect anomalies/issues early, identify root causes, track revenue and spend trends on an hourly/daily/weekly/monthly basis against the forecast. Coordination with multiple teams to fix problems with rollouts/ releases and ensure leadership always has an accurate view of performance.

What You'll Do

  • Executive Communication: Share insights and learnings on long-term and short-term trends with a broader set of stakeholders to inform strategic planning and GTM execution.
  • Monitor the health of the business via tools such as our anomaly detection software and other dashboards, and keep cross-functional stakeholders aligned on the health of key input metrics.
  • Hourly and daily (Real-time monitoring): Monitor the hourly trend continuously.
  • Revenue declines must be assessed to find the root cause and verify if the decline is associated with any product release.
  • Allocate the identified cause to the corresponding teams and assess the next actions.
  • Inform the Network Operations Center team to trigger P1/P2 alerts based on the severity of the revenue decline.
  • Weekly (Medium Term Monitoring): Own the revenue forecasting process and provide executive updates
  • Define variance thresholds that trigger deeper analysis to understand reasons behind movements of key dimensions.
  • Investigate any metrics that show signs of decay or are deviating from the norm and find the root cause.
  • Monthly (Long Term Monitoring): Lead the monthly review process with Marketplace, Product, and Engineering stakeholders to track the key drivers of our spend on an ongoing basis.
  • Be intimately involved in the quarterly and annual planning process and be aware of what assumptions went into the plan.
  • Act as the project manager of investigations. Cross-functionally manage workstreams with account stakeholders to complete analyses and troubleshooting
  • Provide regular updates on Steering Committees. Revenue Monitoring Process Improvement.
  • Reduce “blind spots” by developing new monitoring frameworks and incorporating new data sources into existing monitoring processes.
  • Collaborate with Product Management and external vendors to improve existing anomaly detection solutions, based on KPI performance.
  • Rollout and Recovery Tracking: Work closely with the monetization product team to track and quantify the impact of product releases.

We'd Love for You to Have

  • Shift Timings - 2.00 PM to 11 PM
  • Proven 4 to 6 years of experience in data analysis, or a similar role, is preferred.
  • Communication Skills - Ability to present complex findings in a clear, concise, and actionable way to technical and non-technical stakeholders.
  • Problem Solving - Strong analytical thinking, problem-solving skills, and the ability to work with ambiguous data.
    • Attention to Detail - High level of accuracy and attention to detail in all work.
  • Technical skills such as Excel, Looker, MYSQL, forecasting, impact measurement, AB Testing, are a must.
  • Knowledge of Excel macro/VBA, Python, and Ad Tech experience is good to have.
  • Experience with GenAI-based tools like Cursor and Claude will be an added advantage.
  • Strong knowledge of data manipulation and analysis.
  • Familiarity with anomaly detection techniques, including supervised and unsupervised learning methods, time-series analysis, and outlier detection algorithms.

Qualifications:

  • Should have a bachelor’s or master’s degree in computer science, Data Science, Statistics, Mathematics, Engineering, or a related field.

Additional Information:

Return to Office: PubMatic employees throughout the global have returned to our offices via a hybrid work schedule (3 days “in office” and 2 days “working remotely”) that is intended to maximize collaboration, innovation, and productivity among teams and across functions.

Benefits: Our benefits package includes the best of what leading organizations provide, such as paternity/maternity leave, healthcare insurance, broadband reimbursement. As well, when we’re back in the office, we all benefit from a kitchen loaded with healthy snacks and drinks and catered lunches and much more!

Diversity and Inclusion: PubMatic is proud to be an equal opportunity employer; we don’t just value diversity, we promote and celebrate it. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

About PubMatic

PubMatic is one of the world’s leading scaled digital advertising platforms, offering more transparent advertising solutions to publishers, media buyers, commerce companies and data owners, allowing them to harness the power and potential of the open internet to drive better business outcomes.

Founded in 2006 with the vision that data-driven decisioning would be the future of digital advertising, we enable content creators to run a more profitable advertising business, which in turn allows them to invest back into the multi-screen and multi-format content that consumers demand.

Alares Internet

Analista de Planejamento Comercial Pl (São Paulo/SP)

🕒 5 days ago
Alares Internet👥 1001 - 5000 employees🏢 Telecommunications

Cria dashboards comerciais em Power BI e Excel, prepara apresentações de resultados para lideranças, mantém bancos de dados e colabora com diferentes áreas de negócio para apoiar o planejamento comercial.

Planejamento ComercialPower BIExcelPacote Office

Measure marketing and advertising campaign performance, manage data quality, and turn complex analytics into actionable recommendations and presentations for cross-functional teams and clients.

Marketing AnalyticsCampaign MeasurementBrand Campaign MeasurementDirect Response Campaign Measurement
Eurofins

Business Intelligence and Business Systems Analyst (Remote)

🕒 13 days ago
Eurofins👥 5001 - 10,000 employees🏢 Biotechnology

Develops Power BI reporting and data models while administering CRM and related systems, improving data quality, operational visibility, and reporting processes for Medical Device Services.

Power BIData ModelingData AnalyticsBusiness Intelligence
Shyftlabs

Forward - Data Visualization & Analytics Specialist

🕒 6 days ago
Shyftlabs👥 51 - 200 employees🏢 Management Consulting

Develop and maintain dashboards, automated campaign reporting, and analytical solutions, turning complex datasets into actionable insights that support performance measurement and business decisions.

TableauLookerGoogle BigquerySQL

Trusted by Remote Workers