Associate Data Analyst

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.

The position:

Wrenfield Mutual is hiring an Associate Data Analyst to work remotely from the US. You'll own a set of dashboards and the data behind them, and be the go-to person when someone asks why a number looks off. The Analytics team needs someone who can write SQL, build dashboards and explain what changed and why. Fully remote. You can work from anywhere in the US. We do not have many meetings. Most updates happen in writing. You will write a lot of updates, so clear written English is important.

Duties:

• Build and maintain dashboards in Tableau, Power BI or Looker
• Investigate data quality issues and work with data engineering to fix them at the source
• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Present results to managers and answer follow-up questions
• Create forecasts and simple models in Excel or Google Sheets
• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language
• Support A/B test readouts with basic statistical checks
• Define metric logic with stakeholders and document it

What you need:

• 1+ years of experience in a data or reporting analyst role
• Basic statistics: averages vs. medians, distributions, significance
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Able to juggle several requests and say when a deadline isn't realistic
• Clear written and verbal communication with non-technical stakeholders

Preferred:

• Salesforce or NetSuite reporting
• Google Analytics 4 or Adobe Analytics
• Industry background in retail, healthcare or logistics

The base pay range for this position is $85,000 - $113,000/year. Actual pay depends on experience, skills and location.

What we offer:

• Health insurance
• 401(k) with company match
• Three weeks of PTO to start
• Vision insurance
• Professional development budget
• Cell phone reimbursement

Wrenfield Mutual is an Equal Opportunity Employer, including disability and protected veteran status.

New hires usually start two to three weeks after accepting an offer.

Start: Immediately.

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