What are the responsibilities and job description for the Data Analyst position at Berkley?
Company Details
Carolina Casualty is a member company of W. R. Berkley Corporation, an insurance holding company that is among the largest commercial lines insurance writers in the United States. We specialize in liability, physical damage, cargo and other insurance solutions for the commercial auto markets including trucking, public transportation and others.
We maintain some of the lowest claim adjuster pending claim counts in the industry. Our adjusters are part of a culture that emphasizes inclusion, collaboration, innovation, and team. Our culture is one where your work is recognized and appreciated. If you want to contribute to an organization where you matter and where you can make a difference, then search no further.
www.carolinacas.com
The company is an equal employment opportunity employer.
Responsibilities
The Data Analyst will develop and implement database, data warehouse and business intelligence solutions including the requisite ETL procedures and functions leveraging the Microsoft analytics and business intelligence framework and toolsets; design and develop reports; implement multi-department business solutions within the property and casualty insurance environment; Ensure stability, integrity, and efficient collection of data within on-line systems as well as the data warehouse; ensure on-time data availability for business processing.
Key functions will include but not be limited to the following:
- Understand business requirements, and perform data analysis, estimation, database programming, testing and implementation.
- Ensure smooth and reliable operation of data systems for fulfilling business objectives and processes
- Create and maintain reports using multiple Microsoft technologies
- Develop and implement databases required for business intelligence applications
- Gather and document business data requirements into data models and database designs
- Work with project leads in analyzing system requirements and specifications and translating those requirements into database designs
- Understand business requirements, and perform data analysis, estimation, database programming, testing and implementation.
- Ensure smooth and reliable operation of data systems for fulfilling business objectives and processes
- Create and maintain reports using multiple Microsoft technologies
- Develop and implement databases required for business intelligence applications
- Gather and document business data requirements into data models and database designs
- Work with project leads in analyzing system requirements and specifications and translating those requirements into database designs
This role will be based in Jacksonville FL.
Qualifications
- Bachelor’s Degree in Computer Science (or related field)
- 1 years of Insurance and/or Commercial Auto (Trucking and Public Transportation) Insurance experience preferred
- 2 years of experience in Microsoft SQL Server development, Microsoft SSAS, SSRS, and SSIS development; Data warehouse development, implementation and operation of Star schema, Relational and Dimensional model, Cube development and Analytics; Experience building and maintaining reports - SSRS, Excel-based, Power BI (preferred); Ability to understand and create complex SQL queries, stored procedures; import, export, data transformation; Experience with batch data processing from upstream systems, troubleshooting issues; using multidimensional SSAS Analysis cubes and understanding of MDX; ability to design and implement reporting dashboards; using development practices and processes including but not limited to the Microsoft Products and development tools
Additional Company Details
We do not accept any unsolicited resumes from external recruiting agencies or firms. The company offers a competitive compensation plan and robust benefits package for full time regular employees. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment.Sponsorship Details
Sponsorship not Offered for this Role
