Insight Analyst

Founded as a farmers' mutual in 1997, the company is now one of the larger mutual insurers in the UK. Founded in 1997, we now have 560 employees.

The position:

Severn Insurance Agency is hiring for the Insight Analyst role to answer business questions with data and turn the answers into reports people actually use. The Business Intelligence team needs someone who can write SQL, build dashboards and explain what changed and why. The company is based in London, the UK. The team is distributed across several countries. Employment is through our payroll partner in Pakistan. Salary is paid monthly in Pakistani rupees. Core hours are 10:00 AM to 4:00 PM UK time.

Responsibilities:

• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Analyse trends, cohorts and funnel drop-off and summarise findings in plain language
• Support A/B test readouts with basic statistical checks
• Investigate data quality issues and work with data engineering to fix them at the source
• Create forecasts and simple models in Excel or Google Sheets

Minimum qualifications:

• 2-4 years of experience in a data or reporting analyst role
• Able to juggle several requests and say when a deadline isn't realistic
• Habit of checking your own numbers before anyone else sees them
• Strong SQL (joins, CTEs, aggregations, window functions)
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Bachelor's degree in statistics, economics, business, math or a related field
• Basic statistics: averages vs. medians, distributions, significance

Preferred qualifications:

• Tableau Desktop Specialist or Microsoft PL-300 certification
• Google Analytics 4 or Adobe Analytics
• Dbt or Snowflake
• Python (pandas) or R for analysis

Compensation: PKR 250,000 - PKR 320,000 pcm

Why work with us:

• Wellness allowance
• Annual salary review
• 20 days paid time off
• Annual learning budget
• Annual team retreat
• Flexible hours

Shortlisted candidates will hear from us within two weeks.

The posting will close once we have a strong shortlist.

Start: Immediately.

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