2025-7810 Business Analyst (Mid)

Arch Global Services Philippines; Cádiz; Presencial; EUR 30.000 - 50.000; Jornada completa

Descripción de la vacante

A dynamic insurance company in Andalucía, Spain is looking for a Business and Database Analyst to support actuarial processes. Candidates should have strong SQL knowledge and advanced skills in MS Excel. The role involves collaborating with finance and actuarial teams, improving data quality procedures, and managing SOX controls. A Bachelor's degree in Mathematics or Computer Science is required. This position offers a mid shift schedule and opportunities for growth within the company.

Formación

• Strong knowledge of SQL database functionality.
• Advanced MS Excel skills including formulas and pivot tables.
• Ability to stay organized and manage multiple priorities.

Responsabilidades

• Facilitate timely delivery of premium and claim activity.
• Improve and streamline reconciliation processes.
• Support optimization of Data Quality procedures.

Conocimientos

SQL database functionality

MS Excel (advanced knowledge)

Strong oral and written communication

Problem-solving skills

Knowledge of MS Office products

Educación

Bachelor’s degree in Mathematics, Computer Science, or related field

Herramientas

Snowflake

MS Access

MS Visio

MS Outlook

Descripción del empleo

Company Description

AGSI was incorporated in April 2016. We are committed to supporting the goals of Arch divisions through exceptional service delivery. We pride ourselves on maintaining flexibility and responsiveness to adapt to business unit and industry demands while focusing on sound project management. We are dedicated to growing and developing our employees as we build strong teams with strategic leadership.

Job Description

Schedule: Mid Shift

In this position you will be working within the Corporate Actuarial Department of a dynamic insurance company collaborating with finance, IT and partnering with fellow Business and Database Analyst team members, as well as Actuarial Analysts to carry out the functions necessary to support the actuarial reserving processes and corporate financial reporting. Other functions specific to this team are managing SOX controls and managing statutory data updates.

• Facilitate the timely, complete, and accurate delivery of premium and claim activity from IT/Finance to support the quarterly Actuarial Reserving and Statutory Reporting processes.
• Identify, analyze, and draw conclusions on questions from Actuarial and Finance Teams using available analysis and reporting tools.
• Improve and streamline reconciliation processes to increase accuracy and efficiency.
• Support the optimization of Data Quality procedures.
• Facilitate and enhance SOX and other required audit reporting.
• Facilitate and deliver adhoc projects and reports to support operational needs.

Qualifications

• Strong knowledge of SQL database functionality. Basic knowledge of Snowflake is a plus.
• MS Excel (advanced spreadsheet knowledge, formulas, pivot tables, MS Query, macros, etc.)
• Background in insurance, accounting, or reporting
• Ability to stay organized, manage multiple priorities and respond to critical needs of the Actuarial and Finance departments.
• Strong oral, written and technical communication skills.
• Ability to perform in a fast paced environment, keeping track of details and seeing tasks through to completion
• Knowledge of other MS Office products: Word, Access, Visio, Outlook
• Ability to trouble shoot and problem solve
• Ability to identify opportunities and strategies to improve existing process efficiency (proactive and active)
• Ability to interact with senior management in a professional manner
• Background in finance or actuarial science a plus

Additional Information

Bachelor’s degree in Mathematics, Computer Science, or related field.