Reporting and Insights Analyst

Private Advertiser; Philippines; On-site; PHP 800,000 - 1,200,000; Full time

Job summary

Private Advertiser is seeking a highly analytical Business Intelligence & Data Insights Analyst to support executive decision-making through advanced reporting, analytics, and data visualization.

This role will transform complex data into clear insights that support revenue performance, commercial strategy, and operational improvements, collaborating with leadership, the commercial team, and IT to ensure accurate data flows and automated insights.

Qualifications

• Advanced expertise in BI, data modeling, analytics and reporting.
• Strong experience building and maintaining data visualizations using Tableau and Power BI.
• Excel proficiency at an expert level with data analysis capabilities.

Responsibilities

• Produce accurate daily revenue reporting and executive dashboards.
• Deliver weekly insight reports with actionable analytics to the CEO and leadership.
• Maintain a centralized Power BI reporting environment for company-wide decision making.
• Lead the automation of reports into Power BI dashboards and data workflows.
• Develop forecasting tools and visualizations to support rate optimization and commercial decisions.
• Provide insights on fleet, occupancy, and channel performance.

Skills

BI Analytics

Power BI

Tableau

Excel

SQL

BigQuery

Data Modeling

Data Visualization

Tools

Power BI

Tableau

BigQuery

Excel

Job description

Position Overview

We are seeking a highly analytical and data-driven Business Intelligence & Data Insights Analyst to support executive decision-making through advanced reporting, analytics, and data visualization.

This role will be responsible for transforming complex data into clear insights that support revenue performance, commercial strategy, operational improvements, and forecasting. The position will work closely with leadership, the commercial team, and systems integration functions to ensure accurate data flows, actionable reporting, and automated insights across the business.

Key Responsibilities

1. Reporting Line & Collaboration

• Initially report directly to the CEO, with a transition to reporting to the Senior Manager of BI, Reporting & Insights once the role is established.

• Work closely with the Systems Integration Engineer to align system integrations, data flows, and automation initiatives.

• Serve as the primary data partner for the rate-setting and commercial team, providing insights, historical analysis, demand indicators, and forecasting inputs.

2. Core Reporting & Insight Delivery

• Produce accurate and timely daily revenue reporting and executive performance dashboards.

• Deliver weekly insight reports to the CEO and leadership team with actionable analytics.

• Maintain and continuously improve a centralized Power BI reporting environment supporting business-wide decision making.

3. Power BI & Power Platform Ownership

• Lead the automation of existing manual reports into streamlined Power BI dashboards.

• Develop scalable data models and transformation pipelines using Power Query and Power BI Dataflows.

• Utilize Power Automate to create workflows for data refresh, notifications, approvals, and integration processes.

• Work with the Systems Integration Engineer to integrate new data sources and automate data ingestion.

4. Commercial & Rate Setting Insights

• Provide analytical insights to the rate-setting team including:

  • Demand patterns

  • Booking pace

  • Channel performance

  • Competitor benchmarking (where applicable)

  • Fleet utilization impact

  • Revenue performance against forecasts

• Manage the preparation, cleansing, compilation, and modelling of data to support pricing and commercial decisions.

• Develop forecasting tools or Power BI visualizations to support rate optimization strategies.

• Deliver actionable recommendations to improve revenue yield, seasonality management, and rate positioning.

5. Operational, Fleet & Partner Reporting

• Develop dashboards covering fleet utilization, downtime, repairs, readiness, and branch performance.

• Provide performance insights for broker partners, corporate accounts, and sales channels.

• Deliver insights on occupancy trends, demand shifts, and operational performance improvements.

Knowledge, Skills & Experience

• Advanced expertise in business intelligence, data modelling, analytics, and reporting.

• Strong experience building and maintaining data visualizations using Excel and BI tools (Tableau required).

• Advanced proficiency in Microsoft Excel (expert level).

• Programming and data querying experience including SQL and BigQuery.

• Strong analytical ability with the capability to interpret complex data and provide meaningful insights.

• Excellent presentation, communication, and stakeholder management skills.

• Ability to explain complex data insights in clear and simple terms for non-technical stakeholders.

Technical Competencies

• Power BI

• Power Query

• Power Automate

• Tableau

• SQL

• BigQuery

• Advanced Microsoft Excel

• Microsoft PowerPoint

Personal Attributes

The ideal candidate is:

• Highly curious and passionate about data and analytics

• Detail-oriented and numbers-driven

• Comfortable identifying patterns and translating them into insights

• Proactive and solutions-focused

• Able to work independently and adapt quickly to change

• A strong collaborator across sales, marketing, and operational teams

• Committed to continuous learning and business improvement

Work Requirements

• Ability to work under pressure and meet deadlines while maintaining accuracy.

• Excellent computer proficiency in Microsoft Office (Word, Excel, Outlook, Teams).

• Strong written and verbal communication skills.

• Ability to maintain regular and punctual attendance.

Additional Expectations

• Self-motivated with strong attention to detail.

• Actively research competitors and market trends to provide business insights.

• Demonstrate a team-oriented mindset while collaborating with Sales and Marketing teams.

• Committed to contributing to business growth and operational improvement.