Officer 3, Data Analyst

IQ-EQ; Pasig; On-site; PHP 1,000,000 - 1,500,000; Full time

Benefits offered by this job

Competitive salary

Pension scheme

Wellbeing benefits

Flexible working

Training & development

Job summary

IQ-EQ Philippines is seeking an experienced ETL and data processing preparer to handle a broad range of routine ETL tasks, pre-validation checks, and draft inputs for senior review. You will work with established procedures to deliver accurate outputs while growing familiarity with client-specific requirements.

You will apply data extraction, transformation, and analysis techniques, demonstrate strong Excel and visualization skills, and collaborate with internal teams to ensure timely, quality

Qualifications

• Bachelor’s degree in a quantitative or related field with at least 3 years of data analysis and ETL experience.
• Experience with data visualization tools (Tableau, Power BI) and advanced Excel skills.
• Proficient in MS SQL/Data Warehouse concepts and data troubleshooting.

Responsibilities

• Perform ETL activities across routine data sources, preparing, extracting, transforming, and validating data.
• Prepare recurring report inputs, draft components, and conduct pre-validation to identify discrepancies.
• Maintain understanding of client-specific requirements and coordinate with internal teams for timely deliverables.
• Document exceptions, follow control procedures, and escalate risks or non-standard cases.
• Support onboarding, learning, and process improvements with accurate timesheets and knowledge sharing.

Skills

ETL data processing

Data analysis

Tableau

Power BI

MS Excel advanced

SQL / Data Warehouse

Education

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

Tools

Tableau

Power BI

MS SQL

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

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 via sports 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.