Data Analyst - Asset Owner Solutions

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 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

In This Role:

This Application Developer poisiton is responsible for developing, documenting, and supporting internal and standard Cosmos dashboard using industry standard tools within company’s system. In this role, you will follow definition of done and process around Azure DevOps.

About You:

• You will develop, maintain, and perform unit testing of internal reports and Cosmos (standard and complex)
• You will execute and interpret SQL/Snowflake queries. If needed, update data source query based on the client’s requirement
• You will transfer of pilot data onto portfolio monitoring platform for prospective client demonstrations, identifying the visuals based on the type of data set
• You will follow Definition of Done and process around Azure DevOps and log time entries in NetSuite for BAU, change request, and other development activities
• You will perform Cosmos internal testing to ensure quality and compliance with the wireframe and mapping file
• You will review and create documentation for the onboarding client dashboard and optimize workbook to ensure that best practices are being followed and maintain the performance speed of Cosmos
• You will communicate project status updates and recommendations to project manager, delivery solutions, and application development manager and support client, internal, and BAU requests
• You will collaborate with Delivery Solutions team to understand requirements and translate then into technical solutions
• You will troubleshoot and debug issues and provide timely resolutions and implement new features to existing client dashboard, as and when needed
• You will perform functional, regression, compatibility, performance, and/or security testing when application upgrades to newer version
• You will document any defects or issues found during testing and communicate them to the wider team and maintain internal automation tool.
• You will develop and maintain solutions using VBA and PowerQuery to perform repetitive tasks at a faster pace and higher accuracy, providing valuable insights for decision making and enhanced customer satisfaction
• You will provide backup to other application developer and attend client meeting to understand detailed project requirements and understand business problems  

What We Offer

• Comprehensive remuneration: Motivating financial packages based upon market rates for your role and is proportionate to your qualifications, level of experiences and skills profile
• Pension Scheme: Generous employer contribution with the ability to allow and increase employee contributions
• Wellbeing:
• Annual leave: All our employees are entitled to 26 days paid leave, plus all PH public holidays.
• Flexible working: We recognize the value of working flexibly and is keen to ensure all employees enjoy an excellent work-life blend. As such, we offer Hybrid (70% WFH – 30% Onsite) **First 60 days candidate will need to render 100% Onsite for Onboarding
• Support and development: We will ensure you have the right training, tools and development plan to grow and improve your skills every day
• HMO on Day 1: Covers the Primary member up to two (2) dependents at 100% of the monthly premium. Any additional dependent will be covered by the employee
• Group Life & Accident Insurance Coverage
• Mental Health Access thru partnership with MindNation

Qualifications

About You:

• You have a degree in mathematics, computer science, information systems, engineering, accounting/finance or related field
• You must have at least 2 years developing VBA and PowerQuery solutions to automate manual processes
• You should be knowledgeable in developing, maintaining, and managing Tableau driven dashboards & analytics
• You have a good analytical skills to analyse business needs and problem-solving skills to resolve the issues that appear during development
• You have the ability to research and troubleshoot technical problems and has excellent verbal and written communication skills
• Preferably: Good knowledge/proficiency in MS SQL

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