Associate Data Analyst (Remote)

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.

Overview

This is a backfill for a team member who moved to another team. 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. This role supports operations and finance managers with weekly reporting, ad hoc analysis and KPI tracking. Remote, open to candidates across the US.

Essential duties and responsibilities

• Present results to managers and answer follow-up questions
• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Track sales, inventory or service levels against targets and flag misses early
• Prepare weekly and monthly KPI reports for department leads
• Build and maintain dashboards in Tableau, Power BI or Looker
• Automate recurring Excel reports with Power Query, Python or scheduled SQL

What you need

• Bachelor's degree in statistics, economics, business, math or a related field
• Experience with at least one BI tool such as Tableau, Power BI or Looker
• Clear written and verbal communication with non-technical stakeholders
• Able to juggle several requests and say when a deadline isn't realistic

Nice to have

• Dbt or Snowflake
• Python (pandas) or R for analysis
• Salesforce or NetSuite reporting

Pay: $68,000 - $83,000 per year

Compensation and benefits

• Health savings account (HSA) with employer contribution
• 401(k) with company match
• Paid parental leave
• 11 paid holidays
• Gym membership reimbursement
• Referral program
• Home office stipend

Wrenfield Mutual is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.

Start: Within 30 days.

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