Officer 2, Data Analytics, Asset Owner Solutions

About the role

This review position ensures the accuracy and integrity of extracted and collected data. The role requires strong technical expertise to lead data preparation while upholding strict quality standards. You will validate information, guide technical teams, and solve complex data challenges to protect client solutions. You will act as a technical guardian of data quality, identifying discrepancies and implementing controls that safeguard the reliability of analytical outputs. This position demands a meticulous approach to detail, ensuring that every dataset meets the rigorous benchmarks required by our clients in the fund services sector. You will be instrumental in translating raw data into trustworthy information that drives confident decision-making. Your work will directly influence the quality of insights delivered to stakeholders, reinforcing the credibility of our analytics practice.

Key facts

What you'll do

• Conduct comprehensive reviews of extracted and collected data to verify completeness, correctness, and adherence to defined specifications.
• Perform in-depth validation of datasets, identifying anomalies, outliers, and inconsistencies while implementing corrective actions where necessary.
• Design, execute, and supervise ETL procedures to ensure seamless data flow and reliability across multiple source systems.
• Prepare and deliver client reporting on schedule, ensuring all dashboard and report outputs align with agreed service level agreements.
• Execute complex data and transaction analysis, scrutinizing results to confirm they meet precise business and technical requirements.
• Collaborate with internal technical teams and external clients to clarify requirements, resolve data-related queries, and align on solutions.
• Support full onboarding cycles for new client engagements, communicating technical processes and resolving issues through clear documentation.
• Document exceptional data issues thoroughly and prepare detailed error reports to facilitate tracking and resolution.
• Drive process enhancements by analyzing current extraction methods and workflows to identify opportunities for increased efficiency.
• Review and refine data controls to strengthen the integrity of reporting pipelines and reduce future error rates.
• Provide hands-on technical guidance to less experienced preparers, promoting consistent standards and high-quality output.
• Maintain accurate timesheets and detailed documentation of processes to support audit trails and internal compliance needs.

Requirements

• Hold a bachelor's degree in Mathematics, Computer Science, Information Systems, Engineering, Accounting, Finance, or a related field.
• Bring a minimum of 4 years of professional experience in data analysis roles within financial or service-oriented environments.
• Demonstrate deep expertise in data extraction techniques, including structured web forms and unstructured data sources.
• Show advanced knowledge of MS SQL and Data Warehouse concepts such as joins, unions, and group by operations.
• Apply data visualization best practices to ensure that analytical results are presented clearly and effectively.
• Exhibit exceptional proficiency in Microsoft Office, especially Excel, when managing complex datasets and maintaining strict data accuracy.
• Support the delivery of high-quality reporting and dashboard solutions that meet stringent client expectations.
• Possess excellent communication skills, enabling clear articulation of technical concepts to both technical and non-technical audiences.
• Maintain strong organizational abilities and the capacity to manage multiple priorities simultaneously without compromising quality.
• Act independently with minimal supervision, demonstrating sound judgment in resolving data integrity issues.
• Show a proactive and adaptable mindset when facing changing requirements or ambiguous business needs.
• Demonstrate a firm commitment to quality, continuous improvement, and the sharing of knowledge across the team.
• Develop a deep understanding of client-specific requirements and relevant industry best practices to add tangible value.

Nice to have

No specific additional qualifications are outlined; the focus remains on the stated requirements.

Skills and tools

• Utilize Tableau to create interactive visualizations that help stakeholders understand complex data trends.
• Leverage Power BI to build dynamic dashboards that provide real-time insights into fund performance.
• Write efficient SQL queries to extract, transform, and aggregate data from relational databases.
• Work with Snowflake to manage large-scale data warehousing tasks and ensure scalable performance.
• Apply VBA to automate repetitive tasks within Excel environments, improving processing efficiency.
• Develop and maintain macros to streamline data manipulation and reduce manual intervention.

Practical notes

• Please ensure you meet the stated requirements before proceeding with your application.
• About the company

Iq Eq applies integrated compliance, administration, asset services, and advisory capabilities across funds and related entities. The team combines operational infrastructure with close client collaboration to manage requirements and support strategic decisions. Work focuses on fund governance, reporting, and regulatory obligations. The approach emphasizes durable client relationships and consistent delivery across complex structures and jurisdictions.