Full-Time
$65k - $110k/yr (Verified by employer)
May sponsor international talent
About the job
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!
Hybrid Work arrangement: Bloomington, IL-Corporate, Dunwoody, GA-ParkCenter Hub, Richardson, TX-CityLine Hub or Tempe, AZ-Marina Heights Hub locations.
A "Hybrid" position means selected candidates will be assigned to a facility and will spend some time working both in office and from their home.
Responsibilities
P&C Analytics in Financial Operations is looking to hire a data analyst to focus on Financial Regulatory Reporting - Recurring Ledger Development technical and data support which includes:
P&C Analytics in Financial Operations is looking to hire a data analyst to support Financial & Regulatory Reporting - Recurring technical and data support critical to the production of regulatory financial statements and internal financial reporting:
Extracting, transforming, and loading data for various reports and analytical solutions.
Effectively utilizing coding skills (e.g., JCL, SAS, SQL) to manage, transform, and/or analyze data using structured and well-documented coding techniques.
Effectively analyzing data and working closely with business areas responsible for regulatory filings, financial statements, and communication of results to various levels of leadership.
Building and/or modifying existing technical solutions to meet project requirements including design, coding, testing, and implementing.
Creating and maintaining automated data solutions for reports and analytic solutions.
Availability outside of standard work hours may be/will be required during month-end and year-end processing.
Qualifications
To be considered a competitive candidate for this position, candidate must possess:
Demonstrated coding skills with multiple languages, including but not limited to intermediate to advanced skills in JCL, SAS, SQL.
Knowledge/experience working off IBM Mainframe.
Demonstrated experience in Excel formulas and VBA coding.
Demonstrated learning agility to quickly adapt both new technical skills and business acumen with immediate application of skills.
Strong problem-solving and resourcefulness competencies.
Demonstrated success with executing data ETL.
Demonstrated success with executing recurring reporting tasks including building, automating, troubleshooting, and maintaining.
Demonstrates familiarity with data retrieval and various storage systems.
Financial data acumen around TDS, Loss Reserves, Fire UER, etc.
Additional desired skills:
Willingness to develop accounting acumen through working with business partners.
Experience with AWS Cloud Platform and associated technologies/query tools/services such as Redshift, S3, Starburst, QuickSight, etc.
Experience working with modernized data sources such as TSMAS.
Experience working with various BI tools including Power BI.
Experience using PeopleSoft, StatementPro, Workiva.
Competencies
Data Management/Design
Attention to Detail
Communication/Timeliness
Teamwork
Problem-Solving/Critical Thinking
Curiosity and Continuous Learning
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: $65,000 - $110,000
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 18% 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 our State Farm Careers page for more information on our benefits, locations, and the hiring process of joining the State Farm team!
