MI Analyst

Commercial lines, personal lines and specialty programs are run as separate business units. Agents, brokers and direct customers all buy through our platforms, with policy administration on Guidewire. Most of the office has been here more than ten years.

Overview:

This is a new role. The team has doubled in size over the past year. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. Remote position. Most of the team is in Lahore, but nobody is required to come in. We do not have many meetings. Most updates happen in writing.

In this role you will:

Clean and reconcile data from CRM, ERP and spreadsheet sources. Field ad hoc requests through a ticket queue and prioritise them with your manager. Analyse trends, cohorts and funnel drop-off and summarise findings in plain language. Support A/B test readouts with basic statistical checks. Prepare weekly and monthly KPI reports for department leads. Present results to managers and answer follow-up questions.

Qualifications:

2+ years of experience in a data or reporting analyst role. Advanced Excel: pivot tables, XLOOKUP, Power Query. Basic statistics: averages vs. medians, distributions, significance. Experience with at least one BI tool such as Tableau, Power BI or Looker.

Compensation: PKR 130,000 - PKR 150,000 per month

Compensation and benefits:

Medical insurance. Provident fund. Paid leave. Life insurance. Fuel allowance.

We may close the role early, so do not wait too long to apply.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Chestnutford Insurance.