MI Analyst

Commercial lines, personal lines and specialty programs are run as separate business units. Our claims organisation handles more than 400,000 claims a year, including catastrophe response after hurricanes and hail.

Position summary

Wrenhill Mutual is hiring an MI Analyst to work remotely from India. 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 Ahmedabad, but nobody is required to come in. Please make sure you have dependable internet and backup power.

What you'll be doing

Automate recurring Excel reports with Power Query, Python or scheduled SQL. Create forecasts and simple models in Excel or Google Sheets. Field ad hoc requests through a ticket queue and prioritise them with your manager. Clean and reconcile data from CRM, ERP and spreadsheet sources. Prepare weekly and monthly KPI reports for department leads. Support A/B test readouts with basic statistical checks. Track sales, inventory or service levels against targets and flag misses early. Present results to managers and answer follow-up questions.

Qualifications

3+ years of experience in a data or reporting analyst role. Strong SQL (joins, CTEs, aggregations, window functions). Clear written and verbal communication with non-technical stakeholders. Bachelor's degree in statistics, economics, business, math or a related field. Habit of checking your own numbers before anyone else sees them.

Preferred qualifications

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

Compensation: ₹10,50,000-₹12,50,000 per year

Compensation and benefits

Health insurance for you and your family. Provident fund. Paid leave.

We may close this posting early once we have enough applications.

Please submit your CV in English.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Wrenhill Mutual Pvt Ltd.