Senior Data Analyst, Finance

Clients drop by to pay premiums, ask about a claim or just say hello. This is a new role. The team has doubled in size over the past year. The Operations team needs someone who can write SQL, build dashboards and explain what changed and why. We work hybrid out of Iowa City, usually three days in, two days remote.

The job includes: define metric logic with stakeholders and document it; present results to managers and answer follow-up questions; automate recurring Excel reports with Power Query, Python or scheduled SQL; investigate data quality issues and work with data engineering to fix them at the source.

Skills and experience:

• Strong SQL (joins, CTEs, aggregations, window functions)
• Able to juggle several requests and say when a deadline isn't realistic.
• Basic statistics: averages vs. medians, distributions, significance.

$101,000 - $121,000 annually

We offer health, dental and vision coverage starting on day one, 401(k) with 4% match, three weeks of pto to start and cell phone reimbursement.

We are unable to sponsor visas for this position.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Willamette Assurance, LLC.