Business Data Analyst

Our claims organization handles more than 400,000 claims a year, including catastrophe response after hurricanes and hail. Willow Creek Insurance is a property and casualty insurer writing policies in 30 states through independent agents. January renewals keep everyone busy for a few weeks.

Job summary:

We are backfilling a position after an internal move. 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. Willow Creek Insurance is hiring for the Business Data Analyst role to answer business questions with data and turn the answers into reports people actually use. Fully remote. You can work from anywhere in the US. Normal working hours, Monday to Friday. Clear written English is a must, as the team works across time zones.

Key responsibilities:

• Support A/B test readouts with basic statistical checks.
• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language.
• Build and maintain dashboards in Tableau, Power BI or Looker.
• Track sales, inventory or service levels against targets and flag misses early.
• 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.

Minimum qualifications:

• Advanced Excel: pivot tables, XLOOKUP, Power Query.
• Bachelor's degree in statistics, economics, business, math or a related field.
• Clear written and verbal communication with non-technical stakeholders.
• Strong SQL (joins, CTEs, aggregations, window functions)
• Basic statistics: averages vs. medians, distributions, significance.

Preferred:

• Tableau Desktop Specialist or Microsoft PL-300 certification.
• Dbt or Snowflake.
• Industry background in retail, healthcare or logistics.
• Google Analytics 4 or Adobe Analytics.

$86,000 - $112,000 per year

Pay and benefits:

• Health insurance.
• 401(k) with a 100% match up to 5%.
• Paid sick leave.
• Annual bonus.
• Referral program.
• Employee assistance program.

Start: Immediately.

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