Data Reporting Analyst

National Interstate Insurance Company; Richfield Township (OH); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health insurance

401(k) match

Paid time off

Job summary

National Interstate Insurance Company is seeking a Data Reporting Analyst to join its Richfield office on a hybrid schedule. You will gather and analyze large data sets, maintain databases, and design reports and dashboards for key stakeholders.

The role requires 3+ years in data analytics and proficiency with Cognos, Excel, SQL, Tableau, and Power BI, with a background in insurance preferred.

Qualifications

• Bachelor’s degree or equivalent in data-related field.
• 3+ years in data analytics/reporting; insurance experience preferred.
• Proficiency with reporting tools (Cognos, Excel, SQL, Tableau, Power BI).

Responsibilities

• Gathers, analyzes, and interprets large data sets from multiple sources.
• Develops, designs, and generates reports and dashboards for stakeholders.
• Maintains data integrity and data dictionaries; documents processes and workflows.

Skills

Data analysis

SQL

Excel

Tableau

Power BI

Cognos

Scripting

Education

Bachelor's degree in Data Science/Statistics/CS

Tools

Cognos

SQL

Tableau

Power BI

Excel

Job description

National Interstate is a member of Great American Insurance Group. As one of the leading commercial transportation insurers in the nation, we offer risk financing solutions in all 50 states tailored to meet the needs of a wide variety of transportation classes. Our offerings include traditional insurance and innovative alternative risk transfer (ART) programs, including more than a dozen group captive programs catering to niche wheels markets. We are proud to be a multiple Northcoast 99 winner and Cleveland Plain Dealer Top Workplace in Northeast Ohio. It is because of our talented and dedicated team that we are able to live out our company values of integrity, transparency, fairness, accountability, empowerment and collaboration with each transaction we make. If you are ready to join an engaging and driven team such as ours, we would love to hear from you!

At Great American, we value and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best.

This position is not eligible for employment visa sponsorship. Applicants must be authorized to work in the United States without the need for current or future sponsorship.

Since 1989, National Interstate has specialized in serving the insurance needs of the wheels-based transportation industry. Our steadfast focus on developing niche expertise in product design, loss control and claim services has made National Interstate one of the most respected names in commercial transportation insurance today. (https://natl.com/)

National Interstate is looking for a Data Reporting Analyst to join their team. This individual will work a hybrid schedule out of the Richfield office.

National Interstate’s culture is built on connection, shared learning, and strong relationships. To support this, employees in this role are expected to be on-site four days a week, with the flexibility to work one day remotely. Core in‑office days are Tuesday–Thursday, with the fourth day determined by business needs.

Essential Job Functions And Responsibilities

• Gathers, analyzes, and interprets large volumes of data from multiple sources to support business objectives.
• Ensures data integrity and accuracy by performing regular data audits and validation checks.
• Maintains and updates databases, ensuring data is organized and accessible for reporting purposes.
• Develops, designs, and generates reports, dashboards, and visualizations to provide actionable insights to stakeholders.
• Analyzes trends and patterns in data to identify opportunities for improvement and inform strategic decisions.
• Collaborates with various departments to understand their data reporting needs and deliver customized solutions.
• Presents findings and recommendations to management and other stakeholders in a clear and concise manner.
• Identifies and implements process improvements to enhance data collection, analysis, and reporting efficiency.
• Maintains updated knowledge of industry best practices and emerging trends in data analytics and reporting.
• Develops and maintains documentation for data processes, workflows, reporting standards, and data dictionaries. Additionally performs tracking and documenting state documents, tracking and processing adjuster renewal licenses and completing internal claim audits as needed.
• Performs other duties as assigned.

Job Requirements

Education: Bachelor’s Degree in Data Science, Statistics, Computer Science, Information Systems, or a related field or equivalent experience.

Experience: Generally, a minimum of 3 years of experience in data analytics, reporting or a related field. Previous experience in the insurance industry preferred.

Completion of or continuing progress toward a certification in area of expertise preferred; appropriate certifications could include an Associate Insurance Data Manager (AIDM), or Certificate in General Insurance (INS).

Scope of Job/Qualifications: Performs work under moderate supervision. Relies on limited experience and judgment to plan and accomplish goals. Proficiency in analyzing data sets and identifying patterns, trends, and insights. Proficiency in reporting and data analysis tools (Cognos, Excel, SQL, Tableau, Power BI, etc.) and familiarity with scripting languages. Develops and maintains knowledge of data sources content and structure to assess the quality of data. General knowledge of data extraction, transformation, and loading (ETL) processes. Develops understanding of industry products/coverages and applies that knowledge to support business activity. Strong analytical skills and attention to detail. Strong communication skills with the ability to explain data insights to non-technical stakeholders.

Company

NIIC National Interstate Insurance Company

Benefits

We offer competitive benefits packages for full-time and part-time employees*. Full-time employees have access to medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement. Full-time and eligible part-time employees also enjoy Paid Time Off and paid holidays, a 401(k) plan with company match, an employee stock purchase plan, and commuter benefits.

Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers.

• Excludes seasonal employees and interns.