Founded in 1925, CopperPoint Insurance Companies is a leading provider of workers' compensation and commercial insurance solutions. With an expanded line of insurance products and a growing six-state footprint in the southwestern United States, CopperPoint embodies stability for policyholders in Arizona, California, Colorado, Nevada, New Mexico and Utah. CopperPoint Mutual Insurance Holding Company is the corporate parent of Arizona-based CopperPoint Insurance Companies, California-based Pacific Compensation Insurance Company and other CopperPoint Insurance Entities.
This newly defined role will be part of a core team that is focused on building out an enterprise data warehouse for our rapidly growing commercial insurance company. The person in this role will have the opportunity to engage with colleagues in numerous other departments in the company to understand sources of data as well as the wide variety of uses of data, including financial reporting and data-driven analytics.
Perform data profiling and analysis on internal and external data sets in order to inform requirements, perform testing, and support production processing.
Create business requirements to define capabilities for data selection, transformation, collection and distribution.
Develop test scenarios for validating the quality of data capabilities.
Perform testing necessary to validate that developed solutions align with defined business requirements.
Contribute toward root cause analysis of data related defects.
Collaborate with colleagues in areas sourcing data and consuming data to align expectations as part of developing requirements, creating and executing test plans and to effectively support production processing.
Collaborate with IT partners on solution design within assigned tasks.
Develop a deep understanding of data required for operational, analytic and reporting functions of a property & casualty insurance company.
Complete special projects as assigned by manager and perform other duties as requested.
Strong analytical, problem solving and strategic thinking skills
Insurance industry experience, especially P&C or workers' compensation, preferred but not required
Some actuarial experience, exposure or understanding preferred but not required
Ability to operate in fast paced environment
Excellent communication skills both verbally and in written form.
Bachelor's Degree in Information Systems, Mathematics, Finance or another quantitative subject.
Proficient in Microsoft Office including Outlook, Word, Excel and Access.
Familiarity and experience with querying tools (e.g. Cognos, SAS, SQL)
CopperPoint's culture of compassion extends to the community through employee volunteerism, corporate matching, Board service, program sponsorships and in-kind contributions. We empower employees by providing 12-hours of paid volunteer time annually and matching their personal contribution to the charities of their choice up to $500 per year. In 2018, CopperPoint employees reported 3,500 volunteer hours.
CopperPoint offers a competitive compensation package and comprehensive benefits package including major medical, dental, vision and a wide ran