Location: Seville,OH, USA
The Pricing Analyst, working under moderate supervision, completes work on projects such extracting, transforming, and preparing data; performing rating, reserving, or other financial analyses; developing ad hoc reports and other assigned projects of a quantitative / technical nature. #LI-DNI Combine, aggregate, join, reformat, and manipulate raw data from multiple sources to support pricing and actuarial analyses. Validate rating algorithms and associated factors by identifying discrepancies, troubleshooting issues, and conceptualizing necessary fixes to ensure accurate pricing models. Communicate identified issues and proposed solutions related to rating algorithms and factors with external partners and stakeholders to facilitate effective resolution. Execute, monitor, and debug statistical rerating software to ensure consistent and reliable output for pricing analyses. Implement, validate, and test rate and rule changes within rating systems, ensuring alignment with business objectives and regulatory requirements. Utilize comprehensive knowledge of insurance products to inform and apply necessary adjustments and fixes within pricing models and analyses. Develop and maintain management reports and analyses that monitor performance, behavior, and the achievement of company goals and objectives. Work collaboratively with actuarial team members and cross-functional business units on assigned projects, ensuring accuracy, timely completion, and adherence to project specifications. Assist in the development and maintenance of automated data processing scripts and dashboards to enhance efficiency in monitoring and reporting rating performance. Expand and apply knowledge of relevant tools, technologies, and analytical techniques (e.g., SQL, SAS, Python) to perform comprehensive pricing analyses and support actuarial methodologies. 2+ years of professional analytical work experience including ability to document and explain basic to moderately complex work products. Bachelor's degree in mathematics, statistics, computer science or related field or commensurate experience. Proficient in SQL for data extraction, joining, aggregating, and reformatting. Experience with statistical and data manipulation software such as SAS, Python, R, or Visual Basic. Proficient in MS Excel, including pivot tables and VLOOKUPs, and experience with MS Word for data organization and documentation tasks. Location Hybrid defined as three or more days per week in the office. Behavioral Competencies Optimizes Work Processes Nimble Learning Communicates Effectively Collaborates Manages Complexity Founded in 1848, Westfield is a global leader in property and casualty insurance, delivering superior risk insights and innovative solutions to customers through a diverse portfolio of insurance products. Westfield underwrites commercial, personal, surety, and specialty lines of coverage through a network of leading independent agents and brokers in the United States and specialty products through Lloyd's of London Syndicate 1200. As a mutual insurance company with more than 3,000 employees, Westfield has revenues in excess of $4 billion and more than $10 billion in assets. Westfield celebrates diversity and is committed to inclusion. All qualified applicants receive consideration for employment without regard to race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, or status as a protected veteran.