Officer 3 (Application Development), Asset Owner Solutions at IQ-EQ

Pasig, Metro Manila, Philippines -

Full Time

Start Date

Immediate

Expiry Date

16 Aug, 26

Salary

0.0

Posted On

18 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Analysis, Tableau, Power BI, ETL, SQL, Snowflake, VBA, Data Visualization, Data Storytelling, Microsoft Excel, Data Extraction, Technical Documentation, Stakeholder Management, Process Improvement, Quality Assurance, Complex Transaction Analysis

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 THIS ROLE A review position responsible for validating extracted/ collected data and ensuring quality standards. The position requires strong technical expertise and the ability to lead preparation of data extraction while maintaining high quality standards. WHAT YOU WILL DO Assists in review of extracted/ collected data using prescribed guidelines Ensures integrity and consistency during the extraction process and maintain accurate and timely processing of data extraction/ collection Liaise with internal stakeholders, addressing queries and issues· Maintain strong knowledge of client-specific requirements· Contribute to and support process improvement initiatives· Provide basic technical guidance to preparers· Ensure compliance with established procedures Responsible for reviewing and maintaining the data accuracy shown in the client reports and/or dashboard Periodic preparation or review, and delivery of reporting for various clients’ portfolios within agreed timeframes ETL – Extract data from PDF documents, web forms, and Excel templates; Transform into applicable format; and Load into relevant data repository Monitors client deliverables as stipulated in the SLAs, as pre-agreed with each client Review the accuracy of client records/ dashboards· Document exceptions and prepare error reports together with review findings, proposing corrective actions and preventive measures· Provide feedback on technical matters to preparers· Support complex transaction analysis· Assists in client onboarding activities and any change request related to the above tasks Improve extraction processes in order to save time or simplify the extraction process and/or improve the quality of extractions. Continuous review of the processes and procedures, SLA, checklists and taking initiatives to improve the control environment of the reports delivered to the clients and identifying ways to improve the efficiency of the department Assist AM to coordinate within AOS team or clients on deadlines and deliverables, planning and assigning workload within the team· Playing an integral role in the development and implementation of new investor reporting solutions, including participation in the testing & design environments Communicate resolution of basic technical issues / concerns to team/ client Cross-functional collaboration within the international organization and with other departments on service delivery Track work progress through timesheet completion · Participate in required training programs Reviews SLA and workflow documentation· Perform other related duties as assigned for role and business needs Qualifications ABOUT YOU Bachelor’s degree in Mathematics, computer science, information systems, engineering, accounting, finance or a related field Minimum of 4 years relevant experience data analysis with exposure to data visualization software (i.e. Tableau, Power BI), ETL processes (via SQL or Snowflake), and Macro/VBA Comprehensive knowledge in data extraction tools e.g. web forms, unstructured data extraction tools. Comprehensive knowledge in MS SQL / Data Warehouse – joins, unions, group by etc. x Comprehensive knowledge in data storytelling and visualization best practices. Intermediate Microsoft Office skills with a particular focus on Excel skills Effective communication and documentation skills to articulate processes and operational risks clearly Strong organizational and multitasking skills to handle a full spectrum of complexity levels Proactive and results-driven mindset, capable of working independently with minimal supervision Collaborative team player, open to knowledge sharing and supporting training initiatives Adaptable and open to learning client-specific requirements and industry best practices High level of professionalism and commitment to maintaining quality standards 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

Responsible for validating extracted data, ensuring quality standards, and managing ETL processes from various sources into data repositories. The role involves reviewing client reports, monitoring SLAs, and collaborating on the development of new investor reporting solutions.