Senior Data Analyst

Agents, brokers and direct customers all buy through our platforms, with policy administration on Guidewire. Founded as a farmers' mutual in 1993, the company is now one of the larger mutual insurers in the US. Continuing education credits are tracked and reimbursed.

Overview

Hartwell Mutual is hiring for the Senior Data Analyst role to answer business questions with data and turn the answers into reports people actually use. The work is on site and cannot be done remotely.

In this role you will

• Present results to managers and answer follow-up questions.
• Support A/B test readouts with basic statistical checks.
• Track sales, inventory or service levels against targets and flag misses early.
• Define metric logic with stakeholders and document it.
• Automate recurring Excel reports with Power Query, Python or scheduled SQL.
• Field ad hoc requests through a ticket queue and prioritise them with your manager.
• Investigate data quality issues and work with data engineering to fix them at the source.

Required qualifications

• 6+ years of experience in a data or reporting analyst role.
• Advanced Excel: pivot tables, XLOOKUP, Power Query.
• Habit of checking your own numbers before anyone else sees them.
• Strong SQL (joins, CTEs, aggregations, window functions)
• Bachelor's degree in statistics, economics, business, math or a related field.

Preferred

• Google Analytics 4 or Adobe Analytics.
• Industry background in retail, healthcare or logistics.
• Python (pandas) or R for analysis.

Salary range: €36,000-€48,000 annually

Pay and benefits

• Private health insurance.
• Meal vouchers.
• Training budget.

Only shortlisted candidates will be contacted.

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

Start: Flexible.

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