Data Analyst - Planning & Analysis

State Farm; Bloomington (IL); Hybrid; USD 81,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Tuition assistance

Parental leave

Paid time off

401(k) plan

Job summary

State Farm is hiring two Data Analysts for Planning & Analysis in Bloomington, IL. This hybrid role blends analytics, technology, and collaboration to turn data into actionable guidance for enterprise planning and financial decisions.

Candidates should have 3-7 years of data analytics experience, proficiency in SQL/Python/Power BI, and a solid foundation in data structures, modeling, and data quality. The role requires collaboration across teams to deliver scalable data solutions.

Qualifications

• 3-7 years of Data Analyst experience with strong analytical and critical-thinking skills.
• Experience with SQL, Python, or similar tools for data extraction, transformation, analysis, and automation.
• Experience with data visualization and business intelligence tools such as Power BI, plus the ability to communicate complex information clearly.
• Understanding of data structures, data modeling, transformation, validation, and data quality principles.
• Ability to collaborate across business and technical teams to identify data needs, evaluate data sources, develop analytical solutions, and translate between technical and business concepts.
• Intellectual curiosity and learning agility, with interest in exploring new analytical techniques, technologies, and data sources.
• Ability to balance multiple priorities, take initiative, and independently drive work from problem identification through solution delivery.

Responsibilities

• Analyze complex internal and external datasets using statistical and analytical techniques, model scenarios, surface trends and opportunities, and translate findings into actionable business insights.
• Create analytical approaches that incorporate market opportunity, historical performance, geography, seasonality, and other key factors to strengthen planning, goal-setting, and allocation decisions.
• Examine expense, budget, forecast, operational, and general ledger data to understand cost drivers and trends, evaluate financial trade-offs, and support business choices.
• Use coding, automation, and data transformation to build, enhance, and maintain analytical tools and data solutions that improve accuracy, adaptability, and connectivity across business processes.
• Partner with business teams, data owners, and technology partners to identify data sources, align definitions, validate data, and translate business needs into scalable solutions.

Skills

Data analysis experience

Analytical thinking

Communication

Curiosity

Learning agility

Prioritization

Education

Bachelor's degree (Data Analytics/Business Analytics/Finance/Statistics/Economics/Computer Information Systems)

Tools

SQL

Python

Power BI

Oracle

Job description

State Farm is hiring two Data Analysts for Planning & Analysis to help teams turn complex internal and external data into practical guidance for enterprise planning and financial decisions. This hybrid role blends analytics, technology, and collaboration to improve planning and expense processes, while building durable data solutions for the future.

What you’ll do

• Analyze complex internal and external datasets using statistical and analytical techniques, model scenarios, surface trends and opportunities, and translate findings into actionable business insights.
• Create analytical approaches that incorporate market opportunity, historical performance, geography, seasonality, and other key factors to strengthen planning, goal-setting, and allocation decisions.
• Examine expense, budget, forecast, operational, and general ledger data to understand cost drivers and trends, evaluate financial trade-offs, and support business choices.
• Use coding, automation, and data transformation to build, enhance, and maintain analytical tools and data solutions that improve accuracy, adaptability, and connectivity across business processes.
• Partner with business teams, data owners, and technology partners to identify data sources, align definitions, validate data, and translate business needs into scalable solutions.

What you bring

• 3-7 years of Data Analyst experience with strong analytical and critical-thinking skills, including the ability to work with complex datasets, identify patterns and opportunities, and communicate recommendations.
• Experience with SQL, Python, or similar tools for data extraction, transformation, analysis, and automation.
• Experience with data visualization and business intelligence tools such as Power BI, plus the ability to communicate complex information clearly.
• Understanding of data structures, data modeling, transformation, validation, and data quality principles.
• Ability to collaborate across business and technical teams to identify data needs, evaluate data sources, develop analytical solutions, and translate between technical and business concepts.
• Intellectual curiosity and learning agility, with interest in exploring new analytical techniques, technologies, and data sources.
• Ability to balance multiple priorities, take initiative, and independently drive work from problem identification through solution delivery.

Tools you’ll use

• SQL, Python, Power BI, Oracle

Required education

• Bachelor’s Degree in Data Analytics, Business Analytics, Finance, Statistics, Economics, or Computer Information Systems

Compensation & incentives

• Potential starting salary range: USD 80,600 - 120,000 per year (based on skills, background, and experience; high end limited to applicants with significant relevant experience)
• Potential yearly incentive pay: up to 10% of base salary
• Annual raise and bonus eligibility

Benefits that support your health and life

• Robust health and wellbeing programs (State Farm pays most of the healthcare premium; multiple healthcare plan options including a high deductible plan; 100% coverage for in-network preventative care; plus vision, dental, telemedicine, and 24/7 mental health professionals)
• Educational benefits including industry training programs, tuition assistance, employee resource groups, and mentoring
• Fertility/IVF/adoption assistance and other plan-ahead benefits
• Time off policies include up to 20 days annually (initially), parental leave, paid holidays, celebration day, life leave (40 hours/year), bereavement leave, and community service/education support days
• Matching Gift Program, Good Neighbor Grant Program, and the Employee Assistance Fund
• 401(k) plan with company contributions of up to 7% of your salary, plus access to free financial advisors

Work arrangement

• Hybrid in Bloomington, IL
• Currently 35% in-office, moving to 50% in-office (10 days/month) in 2027
• Must live within a reasonable daily commuting distance to one of the Hub locations: Bloomington IL, Dunwoody GA, Richardson TX, or Tempe AZ
• In-office collaboration days: Tuesdays and Thursdays (flexible)
• Daily flexible start time, Monday through Friday

Preferred background

• Experience with financial or business data, such as expense, budget, forecast, cost‑benefit, or general ledger data, and the financial acumen to translate insights for business use.
• Experience working with production, market opportunity, or related data to support annual planning and target setting.
• Experience with Oracle or similar enterprise planning, budgeting, or ERP solutions, plus experience supporting planning or financial‑system transformation (a plus).
• Experience with cloud‑based data platforms, modern data environments, or developing analytical solutions within large, complex data environments.

What success looks like

Use technical data expertise, analytical thinking, and business acumen to explain what happened, why it happened, what may happen next, and what actions to take, while strengthening State Farm’s data and analytical capabilities for the future.