Senior Data Analyst, Healthcare

The position:

The person in this role is relocating, so we are hiring a replacement. The Marketing team needs someone who can write SQL, build dashboards and explain what changed and why. This is a hybrid role. Most of the team is in the St. George office Tuesday to Thursday.

Your responsibilities:

• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Present results to managers and answer follow-up questions
• Define metric logic with stakeholders and document it
• Investigate data quality issues and work with data engineering to fix them at the source
• Support A/B test readouts with basic statistical checks
• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language

What we're looking for:

• 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
• Basic statistics: averages vs. medians, distributions, significance
• Strong SQL (joins, CTEs, aggregations, window functions)

Preferred:

• Python (pandas) or R for analysis

Compensation and benefits:

Salary: $103,000 - $124,000/year

• Health insurance
• 401(k) with company match
• Paid holidays

About us:

We have been writing policies for the same farms and small businesses since 2012. Every account manager handles a full book, from quotes to renewals to claims questions.

This position requires a background check.

Interview process: a phone call, a meeting with the hiring manager, and a final conversation with the team.

Start: Immediately.

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