Upload your resume - Get hired fast

Junior Cyber Analyst Jobs

ETL Analyst - Life / health

State Farm
Bloomington,United States

  • 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! ResponsibilitiesThe State Farm Life, Health, and IPS (LHIPS) department is transforming its data and analytics function. As a result, our data is moving to the AWS Cloud, and we need your help modernizing and transforming our data processes.Within LHIPS, the Data/Analytics team is hiring for a data engineering role (L/H Systems Analyst) that will provide data to and maintain extract, transform, and load (ETL) processes for actuarial and advanced analytics functions in LHIPS.In Data/Analytics, we are the foundation on which actuarial analytics and studies are built, and in this role, you’ll have an opportunity to help rebuild this foundation from the ground up! Day in the Life of Systems Analyst:In this role, day-to-day activities will vary based on the needs of your actuarial customers and our transformational efforts. Broadly, your responsibilities will include the following: Maintain life insurance actuarial dataDevelop, enhance, and own ETL processes for life insurance actuarial dataMigrate (develop) ETL processes to (in) AWSMaintain legacy ETL functions, primarily in SAS, until they migrate to AWSWrite ad-hoc queries and perform reporting/analytics supporting life insurance actuarial teamsConsult, support, and work directly with business partners upstream (g., Enterprise Technology) and downstream (e.g., Life Actuary, Life Actuarial Studies, Life Advanced Analytics) QualificationsRequired Skills:Demonstrated business outcomes using a data programming language (g., Python, SQL, SAS)Experience performing ETL data processesEffectively build relationships and collaborate with multiple business partnersUnderstand and translate business partner needs into technical data solutionsAbility to communicate and translate technical data solutions to multiple business partnersAbility to resolve data issues and/or inconsistenciesDemonstrated continuous self-improvement Preferred Skills:Track record of improving/innovating business processesExperience working in AWS environment and using AWS enabled tools (Glue, Athena, Sagemaker, Quicksight)Experience programming in PythonKnowledge of life insurance products, underwriting, pricing, valuation, claims, operations, and technology systemsUnderstanding of legacy data systems such as mainframe/DB2, ideally related to life insurance businesses Office Location: Corporate HQ in Bloomington, IL, Hybrid Work Model What You Can ExpectNext 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 U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g. H-1B visa) for this opportunityWhat’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 you...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!SFARM#LI-SB1