Power BI & Data Insights Analyst

Smartsourcing; Philippines; On-site; PHP 900,000 - 1,200,000; Full time

Job summary

Smartsourcing is hiring a full-time, onsite Business Analyst (Data & Reporting) to turn rich business data into insight and decision-ready reporting. You will design, build, and maintain Power BI dashboards, data models, and DAX measures across finance, rental book, broker origination, and asset performance.

Responsibilities include data extraction via SQL, data quality governance, and automation of repetitive tasks.

Qualifications

• Proven experience building Power BI dashboards from scratch and delivering self-directed reporting.
• Experience turning stakeholder requirements into reliable, auditable reports.
• Exposure to financial services or asset finance is a plus.
• Able to transform messy data into clear, decision-ready outputs.

Responsibilities

• Design, build, and maintain Power BI dashboards and reports from scratch for management view.
• Develop data models, Power Query transformations, and DAX measures for accuracy and performance.
• Support monthly reporting cycles and consolidate group reporting with source reconciliation.
• Run ad-hoc analyses to answer executive questions and identify trends.

Skills

Power BI

Data analysis

Requirements gathering

Self-directed

Education

Bachelor's degree in IT/CS/Data Analytics/Finance

Tools

SQL

Excel

Monday.com

ClickUp

ETL tools

ERP/Database exposure

Job description

Hi! We're Smartsourcing, and we're hiring a full-time, onsite Business Analyst (Data & Reporting) to turn a rich, growing set of business data into clear insight and decision-ready reporting — building and running the group's Power BI reporting capability.

About the Role

As a Business Analyst (Data & Reporting), you'll design, build, and maintain Power BI dashboards from the ground up — data model and Power Query through to DAX measures — spanning finance, the rental book, broker origination, and asset performance. You'll build out and independently run the group's management reporting and deal intelligence, safeguard data quality before figures reach decision-makers, and document the logic so reporting stays repeatable and auditable. It's a proactive, self-directed role: you'll take a commercial question and run with it, surfacing new reporting on your own initiative rather than waiting for a brief.

Key Responsibilities

• Design, build, and maintain interactive Power BI dashboards and reports from scratch, giving management a live, drill-down view of KPIs and group performance.
• Develop and maintain data models, Power Query transformations, and DAX measures for accurate, performant reporting.
• Build out designs and wireframes into group consolidation reporting, the monthly board pack, and deal-performance analytics, with every figure reconciling back to source.
• Streamline the monthly reporting cycle, reducing manual touchpoints and turnaround time.

Data Analysis & Commercial Insight

• Interrogate company metrics — rental book value, LVR, repossession and arrears rates, payment friction, and broker/BDM performance — and translate them into clear commercial narrative for non-finance stakeholders.
• Proactively identify trends, patterns, and insights, proposing new reporting rather than waiting for a brief.
• Run ad-hoc analysis to answer specific commercial questions from the executive team (e.g. pricing, disposal channels, cohort performance, unit economics).

Data Extraction, SQL & Requirements Gathering

• Use SQL to query and manipulate data from source systems to support comprehensive reporting.
• Extract, transform, and load data from external sources into the reporting environment.
• Gather reporting requirements from stakeholders, clarifying what's needed and how outputs should look before build.

Data Quality, Integrity & Governance

• Monitor data quality and integrity, catching gaps and errors before numbers reach decision-makers.
• Troubleshoot data issues with system owners and drive them to resolution.
• Apply consistent, approved data definitions and treatment across reporting datasets.

Process Mapping, Documentation & Automation

• Document data definitions, sources, and logic so reporting is repeatable and auditable.
• Create process maps, flowcharts, and supporting documentation for reporting and data workflows.
• Identify and automate manual, repetitive reporting tasks.

Stakeholder Collaboration & Delivery

• Work hand-in-hand with the Power BI Analyst on report and dashboard projects, and collaborate with the Sales team and other functions on data initiatives.
• Communicate directly and professionally with senior stakeholders, translating technical concepts for a non-technical leadership audience.
• Prioritise and deliver across concurrent requests in a fast-paced environment, flagging blockers early.

Artificial Intelligence (AI) Readiness and Digital Enablement

• Maintain baseline AI literacy and use approved AI tools responsibly, in line with company policies, data privacy, information security, and client confidentiality obligations.
• Apply sound judgment by validating outputs and avoiding overreliance, ensuring accuracy and accountability in all work delivered.
• Participate in AI readiness trainings and proactively identify opportunities for process improvement through automation and responsible AI integration.

What You'll Need to Succeed

Experience

• Proven experience in a data, reporting, or business analyst role, including building Power BI dashboards from scratch and running reporting independently
• Experience gathering reporting requirements from stakeholders and turning messy source data into reliable reporting
• Exposure to financial services, asset finance, leasing, or book-based lending advantageous
• Exposure to multi-entity group reporting/consolidation or credit-risk/portfolio-performance metrics advantageous

Skills & Behaviours

• Proactive and self-directed — able to take a commercial question and run with it
• Sharp analytical instincts, with an eye for trends and data-quality issues before figures reach decision-makers
• Able to translate technical concepts for a non-technical leadership audience
• Clear written and verbal communication for requirements gathering, presenting insight, and escalating issues
• Sound awareness of data quality, integrity, confidentiality, and responsible handling of financial and commercial information

Education & Certifications

• Bachelor's degree in IT, Computer Science, Information Systems, Data Analytics, Finance, Accounting, Statistics, or a related field preferred
• Training or certification in Power BI, SQL, data analytics, or Microsoft Excel preferred but not required

Tools

• Power BI (intermediate or better) — required, including building dashboards from scratch, creating DAX measures, and using Power Query
• SQL for querying and manipulating data — required
• Advanced Microsoft Excel advantageous
• Project-management tools (e.g. Monday.com, ClickUp), ERP/database exposure, and knowledge of ETL processes and tools advantageous

Step Into the Smartsourcing Experience

Smartsourcing was created with one mission: to change lives. We're here to ensure that businesses flourish and, just as importantly, that every member of the crew is inspired, supported, and set up to thrive. For the fifth year running, we've been recognized as one of HR Asia's Best Companies to Work For. This award isn't just a title--it's a testament to our commitment to making Smartsourcing an incredible place to build a career.

Why You'll Love Working Here

At Smartsourcing, we believe the best work comes from people who feel seen, heard, and valued. That's why we're all about fostering an environment where you can be your true self. We take pride in being certified as a Great Place to Work, because we know that when you love where you work, extraordinary things happen. Here's just a glimpse of what we offer:

• 5-day Christmas Leave (unwrap real time off)
• Healthcare from Day 1 for you and your family (because healthcare matters)
• Free lunch and barista-crafted coffee daily (we take our caffeine seriously)
• Subsidized gym membership and sports wellness clubs
• Smartsourcing Exclusives (deals made just for you)
• Themed BFFs, monthly knockoffs, summer parties
• Community give-back programs and personal development workshops

We're not just another outsourcing company. We're building something that actually matters here a place where good work meets good culture.