Summary Collaborate with IT, business stakeholders, external vendors and third-party data providers to design, develop, deliver and ensure the accuracy/integrity of data analytics and business intelligence reporting capabilities, to multiple audiences, supporting a broad range of business functions. Support ad-hoc data/reporting requests, and help drive our self-service reporting initiative by providing education, training and support for data related platforms.
Essential Job Functions
Design and develop SQL Server and other data extracts to provide new/enhanced information to our end users
Develop extract/transform/load scripts to validate and load new data sources to our warehouse, data marts, dashboards and other end-user applications
Analyze database implementation methods to make sure they are in line with company policies and any external regulations that may apply
Partners with internal business and compliance resources to understand and assist in the delivery of solutions for regulatory and statutory reporting requirements
Collaborates with cross-functional teams of users, project managers, developers, analysts and vendors to ensure successful delivery of data-related business and technical requirements
Provides guidance to IT development and testing resources that results in solutions that meet or exceed requirements
Self-Starter who can work with minimal direction
Flexes schedule as necessary to meet delivery demands
Meets or exceeds goals as outlined in performance and development plan
Bachelor’s degree in Computer Science, Information Systems, Applied Math, Data Science and/or equivalent industry work experience
5+ years of insurance industry experience
5+ years applicable technology related experience
5+ years business analysis experience
Comprehensive knowledge of property & casualty insurance data models/schemas
Advanced proficiency with SQL Server and/or MySql
Business intelligence dashboard/report development experience in an insurance environment with tools such as Pyramid, Tableau, Qlikview, Cognos, etc.
Proficiency with Informatica or equivalent ETL tool
Experience with a data warehouse implementation, migration and consolidation of historical data in a property & casualty insurance environment
Experience with Guidewire InsuranceNow, and/or Elastic Search
About Topa Insurance Company:
Topa Insurance Company is a growing boutique specialty insurance carrier in Calabasas, California, with more than 30 years of service in the industry. Our highly engaged employees enjoy a modern, collaborative work environment with on-site fitness. Our top notch management team encourages professional development and achievement, with a commitment to make Topa Insurance an employer of choice. We embrace diversity, believe in, recognize and celebrate our people. Our values of respect, integrity, community, accountability and innovation drive our team. We offer a variety of flexible work schedules and shared incentives built around corporate goals and objectives. Our comprehensive benefits plan includes up to 20 PTO days a year for first year team members, as well as annual time off for charitable activity. We want innovative team members who are eager to excel to join our team.