Sr Assoc Business Solutions Analyst

Workplace: Hybrid. At least 3 days in office, up to 2 days virtual for employees within 50 miles of a Farmers corporate office. Applicants beyond 50 miles may still be considered. Job Summary Partners with business teams to design and implement basic data and analytics‑centric and value‑added systems and solutions that enable business outcomes. Projects are of limited complexity. Performs work independently or with coaching and guidance, depending on task complexity. This role provides operational and analytical support for IA Incentives and Promotions & IA Distribution leadership regarding the IAD Budget. Essential Job Functions Maintain and develop data reporting to support Field Enablement, Territory/Market leadership. Collaborate with various IAD teams, as well as cross‑functional teams, such as Distribution Finance. Support ad‑hoc projects when needed. Develop basic value‑based analytics solutions for quality, business process functionality, or other strategic/data/analytic initiatives of limited complexity. Collaborate with cross‑functional teams to identify and establish analytics requirements. Create detailed documentation and business plans that address stakeholder needs. Liaise between IA Distribution and Finance for analytics models and data solutions. Act as trusted business partner working with business leaders and cross‑functional teams to identify key challenges and work on resolutions to improve organizational performance. Develop and implement basic enterprise‑wide data integration strategies that utilize various data marts and data warehouse applications to enhance reporting. Continuously work to improve data platforms, dashboards, and reports to meet emerging and changing business demands and guidelines. Manage data from single sources and use project‑management skills to complete simple projects with coaching and guidance. Transmit data and proactively work to ensure data quality. Troubleshoot data issues and devise creative and effective ways to avoid or mitigate issues. Use a basic understanding of data elements, structures, and standards typically involved in financial services transactions, reporting, and cloud‑based data storage/sharing to adopt and apply standards that satisfy and balance regulatory and compliance requirements with business needs. Education Requirements High School Diploma or equivalent required. Bachelor’s degree preferred. Experience Requirements 1‑2 years of related work experience required. Experience in insurance industry preferred. Special Skill Requirement Demonstrate strong Excel skills, Power BI, Python, SQL experience (preferred). Additional Qualification Demonstrated analytical skills. Demonstrated problem‑solving skills. Proficient in English written and verbal communication skills. Possesses strong technical aptitude. Basic experience with SQL or similar, dimensional modeling, pipeline orchestration, building data pipelines to transform data, and BI visualizations. Effective interpersonal skills. Ability to influence internal and/or external constituents. Seeks to acquire knowledge in area of specialty. Physical Actions Job is performed in‑person at a Farmers office or virtually at an approved alternative work location. The physical work environment is indoors and climate‑controlled with adequate lighting and ventilation. Normal and customary distractions include background noise produced by office equipment and chatter among people, as well as interruptions. Frequently sits for prolonged periods of time, up to a full shift. Occasionally moves around the workplace, including navigating stairs, ramps, and level or uneven surfaces. Occasionally moves, pushes, pulls, lifts, carries, and/or places objects or materials weighing up to 25 pounds without assistance. Frequently uses shoulders, arms, hands, and fingers to manipulate equipment, tools, and objects necessary to perform job duties. Frequently performs fine‑motor tasks such as typing, mousing, or writing, up to a full shift. Rarely performs movements such as bending, stooping, crouching, kneeling, twisting, and reaching overhead or below the knees. Possesses clear vision, with or without correction, to visually read and verify information. Relies on depth perception and peripheral vision to navigate the work environment visually by identifying barriers, changes in terrain, and locating objects. Possesses adequate hearing, with or without correction, to communicate with co‑workers, respond promptly to auditory signals or alarms, and discern sounds essential for maintaining safety and productivity in the workplace. Jobs in this category require rare, if any, travel. Benefits Farmers offers a competitive salary commensurate with experience, qualifications and location. CA Only: $91,350 - $154,990 CO Only: $85,800 - $133,980 HI/IL/MN/VT Only: $85,800 - $143,550 MA Only: $85,800 - $143,550 MD Only: $85,800 - $143,550 DC/NJ/NY/OH Only: $85,800 - $154,990 Albany County, NY/Cleveland, OH: $91,350 - $133,980 WA Only: $85,800 - $163,125 Bonus Opportunity (based on Company and Individual Performance) 401(k) Medical Dental Vision Health Savings and Flexible Spending Accounts Life Insurance Paid Time Off Paid Parental Leave Tuition Assistance Job Location(s): US - AZ - Phoenix, US - MI - Caledonia, US - OH - Dayton, US - RI - Warwick Farmers will consider for employment all qualified applicants, including those with criminal histories, in accordance with the Los Angeles Fair Chance Initiative for Hiring Ordinance or other applicable law. Pursuant to 18 U.S.C. Section 1033, Farmers is prohibited from employing any individual who has been convicted of any criminal felony involving dishonesty or a breach of trust without prior written consent from the state Department of Insurance. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. Farmers is an Equal Opportunity Employer and does not discriminate in any employer/employee relations based on race, color, religion, gender, sexual orientation, gender expression, genetic information, national origin, age, disability, marital status, military and veteran's status, or any other basis protected by applicable discrimination laws. #J-18808-Ljbffr