Data Analyst - Advance Analytics

State Farm is seeking a Data Analyst for Claims-Advanced Analytics to drive strategic P and C Claims data visualization and dashboard initiatives. The role translates complex analytics into actionable insights for claims leadership, leveraging Power BI and Python and SQL to deliver decision-ready outputs.

Key Responsibilities

• Spearhead high-impact, strategic projects centered on P and C Claims data visualization and dashboard creation.
• Serve as a primary advisor to senior management by translating complex data and analytics into business insights.
• Design, develop, and optimize dashboards using advanced analytical techniques to support critical claims strategies and operational decisions.
• Define and communicate technical direction for software development, data integration, and ongoing support of visualization initiatives.
• Own end-to-end project management, from planning through execution, to ensure delivery and strong relationships across cross-functional teams.
• Work with a high degree of autonomy and influence, providing proactive guidance and advancing analytics and dashboard solutions.
• Partner with business stakeholders to provide P and C Claims data that supports claim handling decisions, process improvements, and shifts in claim handling practices.
• Collaborate with Data Scientists and analytics professionals to consult on or contribute to machine learning initiatives and to support creation of large datasets for data and technology-driven process improvements.
• Use SQL and Python to extract and manipulate data from complex systems and produce consumable outputs aligned with business requirements.
• Refine ambiguous business requirements using judgment, business understanding, research, and peer collaboration to deliver optimal results.
• Manage multiple priorities and deadlines across agile and traditional environments with minimal oversight.

Required Qualifications

• Demonstrated leadership delivering complex data visualization and dashboard projects, preferably in the P and C insurance or claims domain.
• Prior experience in the Insurance industry.
• Experience extracting and manipulating large datasets (1M+ records) and working with complex data systems.
• Expertise with Power BI, Qlik, or similar visualization platforms.
• Proficiency in SQL and Python for data extraction and manipulation.
• Strong understanding of data architecture, integration, and analytics best practices.
• Experience with cloud data environments, particularly AWS, and familiarity with on-prem data systems.
• Excellent communication skills, including the ability to explain technical concepts to non-technical stakeholders.
• Ability to navigate ambiguous requirements with a strategic mindset to identify transformative opportunities.
• Exceptional project management skills and a client-focused approach.
• Ability to work autonomously and manage multiple projects in both agile and non-agile settings.

Tools and Technologies

• Power BI
• Qlik
• SQL
• Python
• AWS

Location and Salary

Location: Bloomington, IL (onsite)

Salary: USD 80,600 - 123,000 per year

Benefits

• Potential starting salary range: $80,600.00 - $123,000.00
• Potential yearly incentive pay up to 15% of base salary
• Eligible for an annual raise and bonus
• Robust health and wellbeing programs, with State Farm paying most of your healthcare premium, multiple healthcare plan options including a high deductible plan, 100% coverage for in-network preventative care, access to vision and dental, telemedicine, 24/7 mental health professionals, and more
• Educational benefits including industry-leading training, tuition assistance, employee resource groups, and mentoring
• Fertility/IVF/adoption assistance, college coaching, national discount programs, interactive monthly financial workshops, free financial coaching, and savings account or financing through State Farm Federal Credit Union
• Generous time off including initially up to 20 days annually plus parental leave, paid holidays, celebration day, life leave (40 hours/year), bereavement leave, and community service or education support days
• Matching Gift Program, Good Neighbor Grant Program, and the Employee Assistance Fund
• Retirement support using free financial advisors and a 401(k) plan with company contributions up to 7% of your salary