Lead Data Analyst

Investor Solutions

The creation of Asset Owner Solutions stems from many years of servicing multi-asset, fund-of-fund clients. Clients have been requesting solutions that provide full transparency on their portfolios which include fundamentally private equity funds as well as equities & bonds, investors need to know the finer details of their total portfolios and they are required to “drill down” into their underlying assets and sub-portfolios. Technology and data solutions are becoming more important to deliver these services.

Job Summary

• 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
• Provision of initial observations to clients
• Data report provision and review to third parties as per client requirements
• Provision of ad-hoc analysis or reports
• Handle resolution of queries and communication with clients and third parties
• Assist in the implementation of change requests including project work in new client onboardings
• Design and review reporting output and deliverables to meet client requirements and new business objectives
• Participate in workshops and requirements gathering sessions with clients and take action with the wider team on achieving targets
• Continuous review of the processes and procedures within AOS, take initiatives to improve the control environment of reporting output and deliverables to clients and identify ways to improve the efficiency of AOS
• Play an integral role in the development and implementation of new data-focused solutions
• Document project tasks and group work, assign these to relevant parties and track progress
• Liaise with AOS colleagues, attending conference calls and advising on any additional project work or improvement activities
• Drive projects focused on automation/improvement of manual data extraction activities
• Conduct a first-pass review of work done by Data Analyst colleagues
• Assist the Data Manager in workload management, resource planning, and induction of new joiners

Personal Specifications

• Mathematical/statistical background
• Strong attention to detail
• Excellent organisational, prioritisation, and interpersonal skills
• A strong ‘Can Do’ attitude and ability to lead by example
• Strong ownership of tasks and sense of teamwork
• Ability to work independently
• Excellent written and verbal communication skills

Requirements

Qualifications

• University degree in a numerical discipline Maths/Economics/Statistics (or similar)

Experience

• 2+ years of financial services or data analysis experience
• Proven record of reporting under strict deadlines
• Frequent interaction with clients and senior management
• Good understanding of Microsoft Office tools, particularly strong proficiency in Excel
• Exposure to data visualization software (i.e. Tableau, Power BI), ETL processes (via SQL or Snowflake), and Macro/VBA would be advantageous
• Project management exposure would be advantageous

Additional information

At IQ-EQ we want you to reach your full potential. We offer an inclusive and diverse environment to support your career aspirations. With a strong emphasis on continuous learning and a holistic approach to your professional and personal development. We also offer opportunities across our service lines and our international network of offices.