Company Details

Intrepid Direct Insurance (IDI) is a rapidly growing innovative property and casualty company and a member of the W. R. Berkley Corporation, a fortune 500 company, rated A (Superior) by A.M. Best. Our vision is to create the most efficient insurance experience for our customers leveraging technology and our deep knowledge of our customer’s needs. Our team is comprised of “A” level talent and innovative thinkers. You will be part of a highly collaborative team of talented and focused professionals. Join a group that enjoys working together, trusts each other, and takes pride in our hard-earned success.

The company is an equal opportunity employer.

Responsibilities

The Data Analyst will be responsible for developing and delivering accurate and timely information to stakeholders across the organization. This role will have the opportunity to work across levels and disciplines to identify and execute opportunities for data-driven improvements by rapidly evolving our data and reporting infrastructure.

Key functions include but are not limited to:

• Independently or in collaboration with others, gather requirements for reports and data extracts.
• Comfortable working with a variety of data sources and structures.
• Map and conform data between multiple data sources as required to respond to data requests.
• Responsible for meeting deadlines for outstanding data requests, including recurring data needs for internal and external audiences.
• Descriptive Analysis
  • Applies business logic to raw data to create business information for reporting and decision making.
  • Execute ad-hoc reporting on behalf of the business community
  • Respond to urgent data/reporting needs effectively.
  • Assist in defining measurements, metrics and KPIs to use data to drive the business forward.
  • Create and maintain SQL queries for reporting.
  • Create and maintain SSRS reports
  • Visualize data and KPIs using Power BI
• Diagnostic Analysis o Creates ad-hoc SQL for analysis and investigation.
• Identify, document and collaborate with other teams to resolve issues pertaining to data quality in source systems.
• Interacts and effectively collaborates with all levels of employees across various departments.
• Must exhibit professional behavior at all times while representing the company.

Qualifications

• Bachelor’s degree
• Minimum 2 years’ experience in information management / reporting related function.
• Property casualty insurance experience highly desirable.
• Familiarity with Data Vault methodology highly desirable.
• Proven track record of delivery.
• Comfortable working in agile environment and familiar with source control tools.
• Must be able to communicate effectively across disciplines.
• Excellent knowledge of SQL; Transact-SQL, SQL Server Reporting Services (SSRS); Excel; Power BI.
• Self-starter, resilient with a strong desire to learn.

Additional Company Details

We do not accept any unsolicited resumes from external recruiting agencies or firms. 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.