Data Analyst – Group Medical & Life

GIG Gulf; Dubai; On-site; AED 60,000 - 100,000; Full time

Job summary

Join a leading MENA insurer as a Data Analyst, where you'll leverage your expertise in Python, SQL, and Power BI to optimize the Group Health portfolio. This role involves analyzing healthcare data, creating detailed reports, and collaborating with various departments to enhance business operations. You'll be at the forefront of driving profitable growth while ensuring a positive impact on customer experience. If you're passionate about data and thrive in a dynamic environment, this is the perfect opportunity to make a significant contribution to the company's success.

Qualifications

• Bachelor's degree in Mathematics, Statistics, Actuarial Sciences, or Computer Science.
• Expert level proficiency in Python, SQL, Power BI, and R language.
• Strong technical and analytical skills with high level of numeracy.

Responsibilities

• Extract data using SQL and process it with Python for analysis.
• Create data models using Power BI for visualization.
• Monitor portfolio performance and suggest corrective measures.

Skills

Python

SQL

Power BI

Power Query

R language

VBA

Tableau

Excel

PowerPoint

Word

Education

Bachelor's degree in Mathematics

Bachelor's degree in Statistics

Bachelor's degree in Actuarial Sciences

Bachelor's degree in Computer Science

Tools

Power BI

SQL

Python

Power Query

Excel

Job description

Who we are

GIG is a top 5 MENA Insurer present in 13 countries, with leading positions in Kuwait, Jorden, Bahrain, and Egypt. GIG is backed by 2 strong Shareholders: Fairfax, a financial holding organization owning insurance companies in over 40 countries and headquartered in Toronto, Canada, and KIPCO, one of the biggest diversified holding companies in MENA and backed by the ruling family of Kuwait. As GIG, we are committed to running our operations in a responsible, sustainable way, creating a diverse and inclusive working environment and culture, and having a positive impact on communities and protecting the environment. Our strategic objectives and guiding principles are focused on Regional Growth, Customer Experience and Digital Transformation.

Job purpose:

The ideal candidate must ensure a profitable growth of the Group Health portfolio through analyzing healthcare data to optimize business operations and communicating the findings using data visualization and detailed reports. Collect, refine, and prepare data for basic analytics and visualization, manage issuance of Policy Performance Reports and Loss Ratio.

This role will also include the pricing and issue standard group health proposals for new business/renewals business in line with GIG practices.

Key Responsibilities:

• Extract data from database using SQL and then process the data using Python software and create data models using Power BI for visualization
• Use Power Query in Microsoft Excel to enhance and optimize processes
• Work closely with the Pricing team for data preparation and overall medical portfolio analysis
• Liaise with other departments to build and maintain common medical database
• Interact with data lake teams to insure the timely delivery of the data with accuracy
• Prepare and deliver Health Portfolio analysis based on risk segmentation
• Identify the early warning indicators to adjust the price or indicate deteriorating trends
• Propose alternative options that would help the client design competitive solutions.
• Coordinate with Distribution Channels on marketable proposition to grow the portfolio and maintain profitability.
• Monitor the performance of the assigned portfolio segment. Analyze any abnormal trends and communicate these, along with technical explanations and potential suggestions, to the Sales and Distribution teams for further communication to customers.
• Suggest corrective measures either on whole portfolio or specific accounts to maintain profitability levels.
• Interact with Customers and/or Intermediaries if required.
• Contribute to continuous improvement initiatives aimed at enhancing the customer experience.

Minimum requirements of Role:

Essential:

• Bachelor's degree in mathematics, statistics, Actuarial Sciences, or Computer Science.
• Expert level proficiency in Python, SQL, Power BI, Power Query, and R language
• Expert with dashboards developments and providing automated reporting solution on Power BI.
• Strong technical and analytical skills with high level of numeracy.
• knowledgeable of VBA/Tableau Developer.
• Advanced proficiency in Excel, PowerPoint, and Word.
• Excellent communication skills.

Desirable:

• Recognized certifications in SQL, Python, and Power BI