Senior Data Analyst

Our claims organization handles more than 400,000 claims a year, including catastrophe response after hurricanes and hail. Catastrophe teams deploy adjusters within days of a major storm.

We are creating this position because the workload has grown. The operations 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 Phoenix office Tuesday to Thursday.

Duties:

• Define metric logic with stakeholders and document it
• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Investigate data quality issues and work with data engineering to fix them at the source
• Field ad hoc requests through a ticket queue and prioritize them with your manager
• Present results to managers and answer follow-up questions
• Create forecasts and simple models in Excel or Google Sheets
• Build and maintain dashboards in Tableau, Power BI or Looker

Required qualifications:

• 6+ years of experience in a data or reporting analyst role
• Strong SQL (joins, CTEs, aggregations, window functions)
• Clear written and verbal communication with non-technical stakeholders
• Basic statistics: averages vs. medians, distributions, significance

Why work with us:

Salary: $100,000 - $128,000 a year

• Health insurance
• 401(k) with 4% match
• Three weeks of PTO to start

We are an equal opportunity employer. If you need an accommodation during the application process, let us know.

We are not working with agencies on this role.

Start: Flexible.

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