Job description
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 writing liability, physical damage, cargo and other insurance solutions for fleet trucking, public transportation and other commercial markets.
Responsibilities:
Key Functions include but not limited to:
Qualifications:
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 writing liability, physical damage, cargo and other insurance solutions for fleet trucking, public transportation and other commercial markets.
Our culture emphasizes inclusion, collaboration, innovation, and team. Our culture is one where your work is recognized and appreciated.
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 include but not limited to:
- 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
- Design complex databases, database synonyms, views, cube queries, & reports
- Apply data design standards and guidelines
- Create and maintain documentation and provide in-house education for end-user systems, as needed.
- Provide support and point of contact for department clients requesting routine information, data summaries and or reports
- Perform production and daily operations support for the systems
- Develop and facilitate the resolution of data-related project issues
- Manage data redundancy, identify performance issues and optimize solutions as needed
- Analyze existing workflow for efficiency; recommend and implement needed changes.
Qualifications:
- Bachelors 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.
gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.