12 Months Data Analyst - Operations, Raffles Place

HUDSON RPO (SINGAPORE) PTE. LTD.; Town of Islip (NY); On-site; USD 75,000 - 95,000; Full time

Job summary

A leading company in workflow management and compensation support is seeking a skilled individual to manage data workflows and conduct analysis. The ideal candidate will have a strong background in the insurance industry, be adept in SQL and Python, and exhibit excellent communication skills. Join our team to help improve operational efficiencies through innovative data solutions.

Qualifications

• Minimum 3-5 years of experience in the insurance industry.
• Proficient in Microsoft Office Suite with advanced VBA skills.
• Experienced in SQL and Python for data extraction and automation.

Responsibilities

• Develop workflows using Alteryx, SQL, Python or VBA.
• Conduct User Acceptance Testing on developed workflows.
• Perform data analysis to drive business decisions.

Skills

Analytical skills

Problem-solving skills

Communication

Collaboration

Education

Business, IT or Science degree

Tools

SQL

Python

Alteryx

Microsoft Excel

Job description

Responsibilities:

Compensation and Workflow Management

Workflow Automation Support

• Understand both existing and new mechanisms related to compensation, campaigns, clubs, schemes, and develop workflows using Alteryx, SQL, Python or VBA.
• Collaborate with department members to review current workflows and provide coaching to enhance them using consistent, agreed-upon standards.
• Conduct User Acceptance Testing (UAT) on developed workflows to ensure functionality and accuracy.
• Facilitate briefings and/or workshops to familiarise process owners with newly developed workflows and processes.
• Support capability-building efforts by conducting skills training (e.g., SQL, Alteryx, workflow development, data analysis) for department or division members
• Perform data analysis to uncover trends, patterns and correlations that can inform and drive business decisions.
• Work closely with stakeholders, process owners, developers, and vendors on process improvement initiatives, while actively challenging the status quo.

Compensation Support

• Generation monthly and ad-hoc compensation reports for distribution to relevant stakeholders.
• Respond to compensation-related enquiries from various internal and external stakeholders.
• Support the testing and deployment of system / data pipeline changes, including preparing test cases, executing UAT, and documenting results.
• Monitor scheduled data jobs and troubleshoot failures or inconsistencies in data flow.

Requirements:

• Education – Minimum Business, IT or Science degree
• Minimum 3-5 years of working experience in the insurance industry.
• Familiar with regulatory guidelines from MAS and LIA.
• Proficient in Microsoft Office Suite, particularly Microsoft Excel, with advanced skills in Macro (VBA) programming.
• Experienced in SQL and Python for data extraction. transformation and automation.
• Working knowledge of Alteryx for data preparation and workflow automation (not a primary focus).
• Good understanding of data analytics techniques and data visualization best practices.
• Strong analytical and problem-solving skills, with a good grasp of business process and systems.
• Self motivated, with a strong sense of ownership and accountability.
• Excellent communication, interpersonal, and presentation skills.
• Comfortable interacting with stakeholders at all levels of management.
• Highly organized and meticulous, with strong attention to detail.