Data Analyst

Company Details

Intrepid Direct Insurance (IDI) is a rapidly growing direct to consumer property and casualty insurance company. A member of the W. R. Berkley Corporation, a fortune 500 company, rated A+ (Superior) by A.M. Best, Intrepid Direct's vision is to make life better for business. The insurance industry has not evolved with innovation like other major industries. We're here to change that. We are making life better for our customers, shareholders, and our team members by leveraging data and technology as insurance experts for our targeted customers. 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.

https://intrepiddirect.com/

The Company is an equal employment opportunity employer.

Responsibilities

The Business Intelligence 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.

• Descriptive Analysis

• Applies business logic to raw data to create business information for reporting and decision making.

• Visualize data and KPIs using Power BI

• Create and maintain SSRS reports

• Create and maintain SQL queries for reporting.

• 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.

• Diagnostic Analysis

• 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.

• Responsible for meeting deadlines for outstanding data requests, including recurring data needs for internal and external audiences.

• 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 in Math, Statistics, Computer Science, Actuarial Science, Data Analytics, or equivalent experience.

• Minimum 2 years' experience in data / business intelligence / reporting related function.

• Experience building interactive reporting dashboards in Power BI, required.

• Proficient with SQL and Excel, required.

• Experience with SQL Server Reporting Services (SSRS) and Transact-SQL, desirable.

• Experience with Property / Casualty Insurance, desirable.

• Familiarity with Data Vault methodology, 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.

• 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. Responsibilities The Business Intelligence 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.

• Descriptive Analysis

• Applies business logic to raw data to create business information for reporting and decision making.

• Visualize data and KPIs using Power BI

• Create and maintain SSRS reports

• Create and maintain SQL queries for reporting.

• 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.

• Diagnostic Analysis

• 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.

• Responsible for meeting deadlines for outstanding data requests, including recurring data needs for internal and external audiences.

• Interacts and effectively collaborates with all levels of employees across various departments.

• Must exhibit professional behavior at all times while representing the company.