Officer 3 (Data Analytics), Asset Owner Solutions

IQ-EQ; Metro Manila; On-site; PHP 550,000 - 900,000; Full time

Benefits offered by this job

Comprehensive remuneration

Pension Scheme

Wellbeing benefits

Job summary

IQ-EQ is seeking an experienced data preparer to handle ETL and data processing tasks using established procedures. The role involves pre-validation checks, documenting exceptions, and drafting inputs for senior review, with increasing exposure to client-specific requirements.

You will perform ETL across routine data sources, prepare report inputs, and ensure accuracy through consistency checks and timely escalation.

Qualifications

• Bachelor’s degree in a related field with 3+ years in data analysis and ETL.
• Experience with Tableau/Power BI and VBA.
• Strong SQL and Data Warehouse concepts.

Responsibilities

• Perform ETL activities across routine data sources and validate data per procedures.
• Prepare recurring report inputs and draft report components.
• Conduct pre-validation and consistency checks, escalating issues as needed.
• Support client-specific requirements and coordinate with internal teams to ensure timely deliverables.
• Document exceptions, maintain reference files, follow control procedures and escalate risks.

Skills

data analysis

ETL processes

data visualization

Education

Bachelor's degree in Mathematics, Computer Science, Information Systems, Engineering, Accounting, Finance

Tools

Tableau

Power BI

MS SQL

Data Warehouse

Excel

VBA

Job description

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 ENVIRONMENTS

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 our6,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.

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 of6,500+ people across 24 jurisdictionsand have assets under administration (AUA) exceedingUS$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.