MI Analyst (Product)

We employ 56,100 people across underwriting, claims, actuarial, IT and customer service. Commercial lines, personal lines and specialty programs are run as separate business units. Hail season means long days for field adjusters.

About the role:

Wrenfield Mutual is hiring for the MI Analyst (Product) role to answer business questions with data and turn the answers into reports people actually use. We engage team members in India as full-time contractors. Most of our contractors have been with us for more than two years. You will need at least 3 hours of overlap with US Pacific time. We use Slack, Notion and Google Meet. Cameras on for team calls.

Your responsibilities:

Support A/B test readouts with basic statistical checks. Prepare weekly and monthly KPI reports for department leads. Analyse trends, cohorts and funnel drop-off and summarise findings in plain language. Automate recurring Excel reports with Power Query, Python or scheduled SQL. Create forecasts and simple models in Excel or Google Sheets. Clean and reconcile data from CRM, ERP and spreadsheet sources. Track sales, inventory or service levels against targets and flag misses early. Field ad hoc requests through a ticket queue and prioritise them with your manager.

Required qualifications:

3-5 years of experience in a data or reporting analyst role. Advanced Excel: pivot tables, XLOOKUP, Power Query. Able to juggle several requests and say when a deadline isn't realistic. Bachelor's degree in statistics, economics, business, math or a related field. Clear written and verbal communication with non-technical stakeholders.

Preferred:

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

Salary: ₹16.5-21.5 LPA

Pay and benefits:

Long-term engagement. Company laptop.

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

Duration: 3 months. Start: Within 30 days.

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