Data Analyst

Job Overview

Overview

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!

Visit our Careers page for more information on our benefits, locations and the process of joining the State Farm team!

Responsibilities

State Farm is looking to hire a Junior Level Data analyst who will be part of the Metrics, Data Aggregation and Analytics (MDAA) team focused on building reports, dashboards and analytical solutions for IT Risk and Compliance function as well as at the enterprise level. In addition to providing scheduled reports, the MDAA team is the point-of-contact for ad hoc and on-demand report service requests from consumers throughout the enterprise.

A Day in the life of Data Analyst:

The data analyst will work with team in agile manner completing work in 2 weeks sprints.

Participating in agile ceremonies including PI planning, backlog grooming, sprint planning meeting, retrospective and daily stand up.

Developing solutions and collaborating with product owner and other team members. Other responsibilities include unit testing, system testing, user-acceptance testing and production migration.

Influencing and providing direction on data practices and the data infrastructure needed to support data services and automation.

Leading and collaborating with developers in daily code review meeting to discuss recent code changes.

Collaborating with State Farm internal customers and data source teams (ITADA, HPAM, Service Now, Archer, etc.) for his/her assignments.

Developing visualization to meet business needs – Dynamic slice and dice of data; advanced modular design with multi-tier architecture, leveraging code reusability.

Following team templates on solution development, testing and customer communication.

Qualifications

Required Skills:

Technical background must include but not be limited to:

Qlik tools, SQL, Python, JavaScript, JSON etc.

Technical knowledge of data discipline including data design, data transformation, data manipulation, data visualization, and data analytics.

Deep understanding of data and analytics tools, practices, applications, programming languages and environments.

Translates functional and technical requirements into detailed designs based on architectural direction that has been set.

Data design, data cleansing, data manipulation and aggregation of data from multiple sources to develop solutions that improve overall quality of data. Provide quality assurance of imported data, working with source data providers if necessary.

White boarding/brain storming ideas for the following: designing extract scripts, designing data models and creating front end mock ups for building new dashboards and analytical solutions to meet State Farm internal customer(s) needs.

Enables solution modernization activities through design and development-related work and architectural engagement that can be understood, tested, or modified by any other data analyst.

Provides highest level of support for problem and issue resolution and provides technical consultation and direction to business and product team members.

Strong SQL experience especially data manipulation/transformation for data visualization and analytical solutions to create compelling visuals.

Experience in API connection techniques to SF internal/external data sources.

Ability to test peer’s code to ensure product quality and drives UAT with customers for the implemented changes.

Mentoring team members in developing reports and dashboards.

Preferred skills:

Experience in Analytical/statistical tools and predictive analytics.

Conducts research to integrate industry best practices and data trends into improving team processes and solutions.

Experience with Key Performance Indicators (KPI), Key Risk Indicators or other metric development.

Additional info needed:

AWS certification is a plus

Education in statistics is a plus

Governance, Risk and compliance knowledge is a plus

Software/Programming knowledge is a plus

Office Location: Corporate HQ in Bloomington, IL, OR State Farm Hubs: Richardson, TX; Dunwoody, GA; Phoenix AZ.

What You Can Expect

Next Steps: Competitive candidates  may  be invited to participate in the interview process. This is where the excitement begins!

Applicants are required to be eligible to lawfully work in the ; employer will not sponsor applicants for () for this opportunity

What’s in It for You:

Competitive Benefits, Pay and Bonus Potential: Who doesn’t want money, right?

Volunteer opportunities: Get involved and give back to the community!

Tuition Reimbursement: We support opportunities for you to learn and grow!

A Learning Culture: Mentoring, Professional Designations, Employee Development, and more!

Exceptional 401k Plan 

Dress Code: We trust our employees to dress for their day. That’s right, we trust

We embrace Diversity and Inclusion: We are one team and it is simply the right thing to do!

Learn more about our benefits at State Farm Careers!

#LI-SB1

SFARM

View More