Business & Analytic Insights Data Analyst

Overview 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. Come join a #1 team and do some good! Responsibilities We are not just offering a job but a meaningful career! Come join our passionate team! As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of all associates, and creates a Good Neighbor culture. We offer competitive benefits and pay with the potential for an annual financial award based on both individual and enterprise performance. Our employees have an opportunity to participate in volunteer events within the community and engage in a learning culture. We offer programs to assist with tuition reimbursement, professional designations, employee development, wellness initiatives, and more! Responsibilities The Data Analyst role within the Business Analytics and Insights team supporting Financial Operations, offers an excellent opportunity to leverage technical and analytical expertise to create impactful reporting solutions that drive key business decisions. If you are passionate about data, collaboration, and continuous improvement, we encourage you to apply. Key responsibilities include: • Extract, transform, and load data to build and maintain automated reports and analytics solutions. • Utilize coding skills (e.g., SQL, Python, Qlik, DAX) following structured, well-documented practices for data management, transformation, and analysis. • Build, automate, troubleshoot, and maintain recurring reporting tasks and technical data analytic solutions, including design, coding, testing, and implementation. • Collaborate with business clients and leadership at various levels to analyze data, ensure report accuracy, and maintain report viability. • Support migration and modernization of data assets and BI reporting tools from traditional sources to cloud-based architectures. • Support reporting and insights for procurement and expense operations related to Software-as-a-Service (SaaS) platforms. Including two key applications: Source to Pay and Contract Lifecycle Management. • Be adaptable and available outside standard work hours when required to meet critical business needs. Required Skills • A proactive self-starter with a natural curiosity to explore data, ask insightful questions, and stay updated on the latest tools, techniques, and trends in data analysis and coding. • Demonstrated learning agility to quickly acquire new technical skills and adapt to evolving business requirements. • Ability to manage multiple priorities and deliverables within tight deadlines in a fast-paced environment. • Proven ability to engage and collaborate effectively with upstream data owners, downstream business users, and cross-functional teams such as Engineering and Enterprise Technology. • Strong communication skills to translate complex technical concepts into clear business language and vice versa. • Proficiency in SQL and Python for data extraction, transformation, and analysis. • Experience with cloud and big data technologies such as AWS Console, Starburst, DBeaver, Athena, S3, Redshift, and Iceberg table formats. • Skilled in developing relational and conformed data assets, managing large data volumes, and optimizing performance. • Strong knowledge of data transformation, cleansing, error handling, data modeling, validation techniques, and impact analysis related to schema changes and data pipelines. • Power BI power user with expertise in report/dashboard development, Power Query, and DAX expressions. Familiarity or willingness to learn advanced features including CoPilot integration. • Advanced skills in Excel and SharePoint, with experience in configuration management. • Experience with low-code development and support using Power Apps. • Strong ability to analyze complex datasets and derive actionable business insights. • Experience working with key business metrics and KPIs across multiple stakeholders. • Critical thinking skills to develop innovative solutions that improve reporting and data processes. • Meticulous attention to detail to ensure data accuracy and reliability. • Experience contributing to and/or leading data modernization and migration initiatives. Hybrid Work Locations:Bloomington, IL - Dunwoody, GA - Richardson, TX or Tempe, AZ locations. • Hybrid Work arrangement:A "Hybrid" position means selected candidates will be assigned to a facility and will spend some time working both in the office and from their home. Work arrangements could change over time based on business need. Qualifications • Bachelor's degree in relevant field. • Nice to have - Master's degree (completed or in progress) in relevant field. • Nice to have - Technical certifications in relevant skill sets desired. • Nice to have – Purchasing / Procurement experience. Additional information: ***Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g., H-1B visa) for this opportunity*** Our Benefits Because work-life balance is a priority at State Farm, compensation is based on our standard 38:45-hour work week! • Potential starting salary range: $63,976.25 - $99,540.63 • Starting salary will be based on skills, background, and experience • High end of the range limited to applicants with significant relevant experience • Potential yearly incentive pay up to 9% of base salary At State Farm, we offer more than just a paycheck. Check out our suite of benefits designed to give you the flexibility you need to take care of you and your family! • Get Paid!On top of our competitive pay, you are eligible for an annual raise and bonus. • Stay Well!Focus on you and your family’s health with our robust health and wellbeing programs. State Farm pays most of your healthcare premium, and we offer multiple healthcare plan options, including a high deductible plan. All medical plans provide 100% coverage for in-network preventative care, AND you and your family have access to vision, dental, telemedicine, 24/7 mental health professionals, and much more! • Develop and Grow!Take advantage of educational benefits like industry leading training programs, top-notch tuition assistance programs, employee resource groups, and mentoring. • Plan Ahead!Plan for those big moments in life with benefits like fertility/IVF/adoption assistance, college coaching, national discount programs, interactive monthly financial workshops, free financial coaching, and more. You can also start a savings account or consider financing through our State Farm Federal Credit Union! • Take a Little “You” Time!You will have access to our generous time off policies designed so you can plan around holidays, family events, volunteering, or just to take a relaxing day off. With the opportunity to initially earn 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, there will be plenty of time for you! • Give Back!We offer several ways to give back through our Matching Gift Program, Good Neighbor Grant Program, and the Employee Assistance Fund. • Finish Strong!Plan for retirement using free financial advisors and a 401(k) plan with company contributions of up to 7% of your salary. Visit ourState Farm Careerspage for more information on ourbenefits,locations, and thehiring processof joining the State Farm team!