Officer 3, Business Intelligence (BI) Analyst - Finance

IQ-EQ; Pasig; Hybrid; PHP 600,000 - 900,000; Full time

Benefits offered by this job

Competitive salary

Pension scheme

Medical & life insurance

Flexible working

Training & development

Job summary

IQ-EQ is seeking an experienced ETL/Data Analyst to manage routine data processing, validation, and reporting. You will handle ETL across diverse sources, ensure data quality, and draft inputs for senior review while aligning with client-specific requirements.

The role emphasizes data visualization, advanced Excel, and collaboration with internal teams to deliver accurate, timely outputs and continuous improvements.

Qualifications

• Bachelor’s degree in Mathematics, Computer Science, Information Systems, Engineering, Accounting, Finance, or a related field.
• 3+ years of experience in data analysis, ETL processes, data visualization tools (Tableau, Power BI), and Macro/VBA.
• Strong expertise in data extraction, transformation, and analysis, including complex data handling and troubleshooting.
• Proficient in data visualization and storytelling with advanced Excel, supporting dashboard integrity and reporting accuracy.

Responsibilities

• Perform ETL activities across a range of routine data sources with validation.
• Prepare recurring report inputs and draft components; perform pre-validation checks and escalate issues.
• Maintain understanding of client requirements and coordinate with internal teams for timely deliverables.
• Document exceptions, follow control procedures, and escalate risks per protocols.
• Support process improvement through onboarding, knowledge sharing, and continuous learning.

Skills

ETL processes

Data analysis

Tableau

Power BI

Macro/VBA

MS SQL

Data visualization

Advanced Excel

Communication skills

Education

Bachelor’s degree in a related field

Tools

MS SQL

Data Warehouse

Excel

Job description

ABOUT IQ-EQ

We’re a leading Investor Services group offering end-to-end services in administration, accounting, reporting, regulatory and compliance needs of the investment sector worldwide. We employ a global workforce of 6,500+ people across 24 jurisdictions and have assets under administration (AUA) exceeding US$857 billion. We work with 13 of the world’s top-15 private equity firms.

Company Description

ABOUT IQ-EQ

We’re a leading Investor Services group offering end-to-end services in administration, accounting, reporting, regulatory and compliance needs of the investment sector worldwide. We employ a global workforce of 6,500+ people across 24 jurisdictions and have assets under administration (AUA) exceeding US$857 billion. We work with 13 of the world’s top-15 private equity firms.
Our services are underpinned by a Group-wide commitment to ESG and best-in-class technology including a global data platform and innovative proprietary tools supported by in-house experts.
Above all, what makes us different is our people.Operating as trusted partners to our clients,we deliver intelligent solutions through a combination of technical expertise and strong relationships based on deep client understanding.
We’re driven by our Group purpose, to power people and possibilities.

Job Description

THIS ROLE

An experienced preparer role responsible for handling a broader range of routine ETL and data processing activities using established procedures and prescribed guidelines. The role performs pre‑validation checks, documents exceptions for escalation, and prepares draft inputs for senior review. It requires working knowledge of data processes, growing familiarity with client-specific requirements, and the ability to deliver accurate outputs with moderate guidance while supporting continuous improvements through observations.

What You Will Do

• You’ll perform ETL activities across a range of routine data sources, preparing, extracting, transforming, and validating data in accordance with established procedures, templates, and quality standards.
• You’ll prepare recurring report inputs, draft report components, and conduct pre-validation and consistency checks to identify discrepancies, ensuring timely escalation of issues when required.
• You’ll maintain a strong understanding of client‑specific requirements, support routine data‑related inquiries, and coordinate effectively with internal teams to ensure accurate and timely deliverables.
• You’ll contribute to quality assurance by documenting exceptions, maintaining reference files, following control procedures, completing required checklists, and escalating risks or non‑standard cases in line with established protocols.
• You’ll support operational efficiency through onboarding activities, knowledge sharing, continuous learning, accurate timesheet completion, and participation in process improvement discussions by identifying recurring issues and opportunities for refinement.
  

What We Offer

• Comprehensive remuneration: Competitive financial packages based upon market rates for your role, proportionate to your qualifications, level of experiences and skills profile
• Pension Scheme: Generous employer contribution with the ability to increase employee contributions
• Wellbeing: Additional social benefits such as medical insurance & life assurance, discounted gym memberships and the opportunity to engage with our local community viasports activities, charity programmes & environmental initiatives
• Flexible working: We recognise the value of working flexibly and enable our employees to enjoy an excellent work-life blend
• Support and development: We will ensure you have the right training, tools and development plan to grow and improve your skills every day.

Qualifications

ABOUT YOU

• You hold a bachelor’s degree in Mathematics, Computer Science, Information Systems, Engineering, Accounting, Finance, or a related field, with at least 3 years of experience in data analysis, ETL processes, data visualization tools (e.g., Tableau, Power BI), and Macro/VBA.
• You have strong expertise in data extraction, transformation, and analysis, including handling complex or unstructured data, troubleshooting technical issues, and applying MS SQL/Data Warehouse concepts in moderately complex scenarios.
• You are proficient in data visualization and storytelling best practices, with advanced Microsoft Excel skills and the ability to support dashboard integrity, reporting accuracy, and continuous enhancements.
• You possess strong communication, organizational, and prioritization skills, enabling you to explain technical concepts, provide guidance to preparers, manage multiple responsibilities, and work effectively with minimal supervision.
• You are a proactive, detail‑oriented, and collaborative professional who contributes to process improvements, identifies and mitigates risks, mentors junior team members, and remains committed to continuous learning, quality standards, and industry best practices.

Additional Information

OUR COMMITMENT TO YOU AND THE ENVIRONMENT

Sustainability is integral to our strategy and operations. Our sustainability depends on us building and maintaining long‑term relationships with all our stakeholders – including our employees, clients, and local communities – while also reducing our impact on our natural environment.
There is always more we can, and should do, to improve – whether in relation to our people, our clients, our planet, or our governance. Our ongoing success as a business depends on our sustainability and agility in a changing and challenging global landscape. We’re committed to fostering an inclusive, equitable and diverse culture for our people, led by our Diversity, Equity, and Inclusion steering committee.
Our learning and development programmes and systems (including PowerU and MyCampus) enable us to invest in growing our employees’ careers, while our hybrid working approach supports our employees in achieving balance and flexibility while remaining connected to their colleagues. We want to empower our 6,500+ employees - from 94 nationalities, across 24 countries - to each achieve their potential. Through IQ‑EQ Launchpad we support women managers launching their first fund, in an environment where only 15% of all private equity and venture capital firms are gender balanced.
We’re committed to growing relationships with our clients and supporting them in achieving their objectives. We understand that our clients’ sustainability and success lead to our sustainability and success. We’re emotionally invested in our clients right from the beginning.