Officer 3 Data Analyst, Asset Owner Solutions at IQ-EQ

Pasig, Metro Manila, Philippines -

Full Time

Start Date

Immediate

Expiry Date

04 Jun, 26

Salary

0.0

Posted On

06 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

ETL, Data Extraction, Data Collection, Quality Control, Risk Mitigation, Data Reporting, AdHoc Analysis, Client Onboarding, Operational Checklists, Timesheet Completion, Workflow Adherence, Escalation Procedures, Self-Reviews, Cross-functional Collaboration, MS SQL, Excel

Industry

Financial Services

Description

Company Description 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 5,800+ people across 25 jurisdictions and have assets under administration (AUA) exceeding US$750 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 Job Summary: A mid-level preparer position responsible for delivering comprehensive ETL (Extraction, Transform and Load) according to the set requirements. The position requires independent execution of established procedures while maintaining quality and timeliness standards. In this role you will enjoy the flexibility of a hybrid work environment, where you can balance remote work convenience with engaging in-office collaboration Core Responsibilities: Assists in data extraction and collection using prescribed guidelines Maintain accurate and timely processing of data extraction/ collection Follow quality control process and risk mitigation efforts Develop knowledge of client specific requirements and deliverables Responsible for entering and maintaining the accurate data shown in the client reports and/or dashboard Tasks: Periodic preparation and delivery of pre-agreed reporting for various clients’ portfolios ETL – Extract data from PDF documents, web forms, and Excel templates; Transform into applicable format; and Load into relevant data repository Data report provision and review to third parties as per client requirements Assist in the provision of ad-hoc analysis or reports Assists in client onboarding activities and any change request related to the above tasks Complete and maintain detailed operational checklists Track work progress through timesheet completion Follow prescribed workflows and escalation procedures Participate in workshops and required training programs Conduct self-reviews to maintain quality standards Assist senior team members with routine assignments Support in overseeing and managing incoming communication from the other AOS team members/Client/Investor’s Cross-functional collaboration within the international organization and with other departments on service delivery Perform other related duties as assigned for role and business needs THIS ROLE As a Client Accountant, you’re a detail-oriented team player with great organisational skills. Your responsibilities include day-to-day management of private equity or real estate clients, reviewing financial statements, ensuring accurate communication of cash movements, and overseeing the preparation and completion of client deliverables. This is a 100% remote position available for UK-based candidates. WHAT YOU WILL DO You’ll work closely with your line manager to ensure financial statements meet the funds’ reporting requirements, e.g., UK GAAP or IFRS You’ll review investor drawdown calculations to ensure accuracy of figures as funds seek access to their commitments from investors You’ll review investor distribution calculations to ensure the flow of funds from the sale of an investment are accurately recorded so that proceeds are appropriately allocated and paid to investors You’ll ensure the accurate communication of all cash movements between the fund and its investors through the issuance of relevant notices to investors You’ll oversee the preparation and completion process of client deliverables including agreeing timetables with clients, and thereafter and monitoring progress against these to ensure deliverables are on track. ABOUT YOU You are ACCA/ACA/CIMA part or fully qualified or qualified by experience You have previously worked in financial services or accounting practices working on multiple client relationships You have experience reviewing working paper files and financial statements, including disclosures or alternatively can demonstrate strong accounting background through previous experience and CPD You manage client relationships and experience with resolving issues directly with clients You have experience in supporting and mentoring junior team members. Qualifications Educational Background: Bachelor’s degree in Mathematics, computer science, information systems, engineering, accounting, finance or a related field Professional Experience: 3 years of experience in data analysis with exposure to data visualization software (ie Tableau, Power BI), ETL processes (via SQL or Snowflake), and Macro/VBA Skills and Key Behaviours: In addition to upholding our Group Values (Authentic, Bold, and Collaborative), the role holder will be expected to demonstrate the following: Knowledge in data extraction tools eg web forms, unstructured data extraction tools Basic knowledge in MS SQL / Data Warehouse – joins, unions, group by etc Basic knowledge in data storytelling and visualization best practices Intermediate Microsoft Office skills with a particular focus on Excel skills Ability to collaborate effectively with senior team members and work well in a team-oriented environment Enthusiasm for learning and commitment to completing required training programs Good time management and organizational skills to meet deadlines in a structured work environment Willingness to follow standardized workflows and adapt to client-specific requirements Proactive and adaptable with a mindset focused on quality control and risk mitigation Open to feedback and capable of applying it to improve performance Additional Information 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 5,800+ employees - from 94 nationalities, across 25 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 leads to our sustainability and success. We’re emotionally invested in our clients right from the beginning. Department: Client Services Type of Hire: Permanent

Responsibilities

This mid-level preparer position is responsible for delivering comprehensive ETL processes according to set requirements, involving independent execution of established procedures while maintaining quality and timeliness standards. Core duties include assisting with data extraction and collection, maintaining accuracy, following quality control, and developing knowledge of client-specific deliverables.