Data Reporting Business Analyst

Group 1001 is a consumer-centric, technology-driven family of insurance companies on a mission to deliver outstanding value and operational performance by combining financial strength and stability with deep insurance expertise and a can-do culture. Group1001’s culture emphasizes the importance of collaboration, communication, core business focus, risk management, and striving for outcomes. This goal extends to how we hire and onboard our most valuable assets – our employees.

Company Overview:

Clear Spring Property and Casualty Group (CSPCG) is comprised of four insurance carriers (Clear Spring Property and Casualty Company, Clear Spring Casualty Insurance Company, Clear Spring American Insurance Company, and Clear Spring National Insurance Company), each rated A- (Excellent) by A.M. Best. CSPCG assists companies in protecting themselves from today’s challenges through technology and innovation. CSPCG provides worker’s compensation, general liability, and other coverages through strong agency relationships.

JOB SUMMARY

The Data Reporting Specialist will be part of the Data Reporting & Analytics Reporting team supporting a variety of statistical & compliance data reporting, data management, and business intelligence initiatives. This role will support and enhance critical data reporting process flows and play a key technical role in transforming data usage landscape.

MAIN ACCOUNTABILITIES

• Support statistical data reporting workflow ensuring successful automating, collection, preparation, and submission of data
• Assist in understanding data call requirements including: extract, prepare, and provide data required for regulatory reporting to the Compliance department
• Assist in designing, developing, and implementing effective processes, reports, and other tools to report data and improve data quality
• Perform analyses, extract insights, make recommendations and design intuitive dashboards and reports to deliver those insights
• Develops fundamental understanding of core business to effectively collaborate with partners across the organization in identifying opportunities to develop and implement BI reporting solutions
• Support data management and data warehouse initiatives by collaborating with IT, end-users, and external business partners to identify, triage, and resolve data and/or processing issues
• Develop and continuously improve processes, procedures, and best practices across the department
• Review, analyze and summarize data to help identify and communicate issues, including scope and root cause
• Analyzes business issues and deliverables to create requirements and specifications for reports and analysis based on business needs and required or available data elements
• Creates reports, dashboards and extracts for a variety of customers using established tools and data sources. Leverages a wide set of analytical skills to answer ad-hoc and timely data-driven questions for executives, finance operations, and service-line leaders.
• Lead efforts to contextualize and provide easy access to data for different operational business functions within the organization
• Enhance operational efficiency through leveraging tools and technology to automate data capture and improve business intelligence capabilities

QUALIFICATIONS

Required

• Associate degree in business or related field. Equivalent industry experience may be considered
• 3+ years of experience in a data analysis role or related functional business experience
• Proficient in Microsoft Office (Word, PowerPoint) and advanced working knowledge of Excel
• Ability to establish positive relationships, work effectively across the organization, and collaborate with internal and external stakeholders at all levels

Preferred

• Proficient in developing and executing SQL queries for reporting, data extracts, and troubleshooting highly desired
• Experience with Power BI and Microsoft Power Platform, Power Automate and Power Apps, highly desired

Compensation:  

Our compensation reflects the cost of labor across several U.S. geographic markets. The base pay for this position ranges from $80,000/year in our lowest geographic market up to $95,000/year in our highest geographic market.  Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience.

Benefits Highlights:  

Employees who meet benefit eligibility guidelines and work 30 hours or more weekly, have the ability to enroll in Group 1001’s benefits package. Employees (and their families) are eligible to participate in the Company’s comprehensive health, dental, and vision insurance plan options.  Employees are also eligible for Basic and Supplemental Life Insurance, Short and Long-Term Disability. All employees (regardless of hours worked) have immediate access to the Company’s Employee Assistance Program and wellness programs—no enrollment is required.  Employees may also participate in the Company’s 401K plan, with matching contributions by the Company.

Group 1001, and its affiliated companies, is strongly committed to providing a supportive work environment where employee differences are valued. Diversity is an essential ingredient in making Group 1001 a welcoming place to work and is fundamental in building a high-performance team. Diversity embodies all the differences that make us unique individuals.  All employees share the responsibility for maintaining a workplace culture of dignity, respect, understanding and appreciation of individual and group differences.