Data Analyst - Advance Analytics

Being good neighbors – helping people, investing in our communities, and making the world a better place – is who we are at State Farm. It is at the core of how we operate and the reason for our success.

Responsibilities

• Lead and Consult: Spearhead high-impact, strategic projects focused on P&C Claims data visualization and dashboard creation. Solve complex technical challenges and influence business outcomes.
• Trusted Advisor: Act as a primary resource and advisor to senior management and leadership, translating complex data and analytics into actionable business insights.
• Analytical Expertise: Leverage advanced analytical tools and techniques to design, develop, and optimize dashboards that inform critical claims strategies and operational decisions.
• Visionary Leadership: Define and communicate the vision and technical direction for software development, data integration, and ongoing support of visualization initiatives. Stay ahead of emerging trends and identify new opportunities to enhance analytics capabilities.
• Project Management: Own all phases of project management — from planning to execution — ensuring seamless delivery and strong client relationships across cross-functional teams.
• Autonomous Influence: Operate with a high degree of autonomy and influence, proactively providing guidance and driving innovation in analytics and dashboard solutions.
• Business Partnership: Work directly with business partners to provide P&C Claims data that supports claim handling decisions, process improvements, and strategic shifts in claim handling practices.
• Cross-Functional Collaboration: Partner with Data Scientists and analytic professionals to consult on or contribute to machine learning initiatives and the creation of large datasets that enable data- and technology-driven process enhancements.
• Data Mining & Programming: Utilize programming languages such as SQL and Python to extract and manipulate data from complex systems, delivering consumable outputs aligned with business requirements.
• Requirement Refinement: Navigate ambiguous business requirements by applying judgment, business understanding, research, and peer collaboration to refine needs and deliver optimal results.
• Time & Task Management: Effectively manage multiple priorities and deadlines in both agile and traditional environments, working independently with minimal oversight.

Requirements

• Proven leadership in delivering complex data visualization and dashboard projects, preferably in the P&C insurance or claims domain.
• Prior experience within the Insurance industry.
• Experience extracting and manipulating large data sets (1M+ records) and navigating complex data systems.
• Expertise in tools such as Power BI, Qlik, or similar 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 with the ability to convey technical concepts to non-technical stakeholders.
• Comfort working with ambiguous requirements and 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 agile and non-agile settings.

Pay

• Potential starting salary range: $80,600.00 - $123,000.00 (based on skills, background, and experience; high end limited to applicants with significant relevant experience).
• Potential yearly incentive pay up to 15% of base salary.

Benefits

• Get Paid! Competitive pay based on a 38:45-hour work week, annual raise, and bonus eligibility.
• Stay Well! Robust health and wellbeing programs with State Farm covering most healthcare premiums. Multiple healthcare plan options, including a high deductible plan with 100% in-network preventative care coverage. Access to vision, dental, telemedicine, 24/7 mental health professionals, and more.
• Develop and Grow! Educational benefits including industry-leading training programs, tuition assistance, employee resource groups, and mentoring.
• Plan Ahead! Benefits like fertility/IVF/adoption assistance, college coaching, national discount programs, financial workshops, free financial coaching, and savings/financing through State Farm Federal Credit Union.
• Take a Little “You” Time! Generous time off policies including up to 20 days annually plus parental leave, paid holidays, celebration day, life leave (40 hours/year), bereavement leave, and community service/education support days.
• Give Back! Matching Gift Program, Good Neighbor Grant Program, and Employee Assistance Fund.
• Finish Strong! Retirement planning with free financial advisors and a 401(k) plan with company contributions of up to 7% of salary.