Business Intelligence Specialist
San Diego, CA

Job Description

ICW Group is looking for a Business Intelligence Specialist to support the analysis and design of effective reporting solutions for use in decision support systems such as an Enterprise Data Warehouse (EDW), ODS data marts and various vendor solutions. In this role, you will work with business leaders and provide quantitative and qualitative data analysis and reporting of patterns, insights, and business trends. This position will complete analysis of various data sources and structures in support of Business and IT teams in order to complete the structure and financial goals of the Company.

ABOUT YOUR JOB:

Collects and aggregates data from multiple internal and external sources for analyses to drive insights into business performance

* Aggregates large, complex data sets from multiple databases and creates insight reports.
* Transforms unstructured or ambiguous data into structured and usable data sets that can be analyzed to extract insights and improve business processes.
* Collaborates with appropriate parties within the organization to integrate new data sources into our existing data infrastructure.
* Delivers complex and actionable reports that show key performance indicators, identify areas of improvement into current operations, and display root cause analysis of problems.

Provides quantitative and qualitative data analysis of patterns, insights, and trends to decision-makers

* Collaborates in cross-functional teams to implement analytical solutions.
* Ensures data quality, adherence to departmental guidelines, profitability, business impact, and other risk-related metrics for self and members of the team.
* Analyzes current business processes; makes recommendations to management for new, more efficient, workflows, and processes.
* Uses and presents analytics and metrics to improve processes and provide data-driven forecasts of potential costs, risks, and profits of new business initiatives.

Provides reporting solutions and responds to report requests across multiple business areas and for complex enterprise wide projects

* Collaborates with team members and leaders across the organization to identify and understand business problems and processes.
* Enhances and develops analytical and reporting solutions to solve business problems and extract insights.
* Enhances and supports enterprise-wide strategies, processes, and standards for business intelligence and reporting.
* Delivers complex functional specifications and system design specifications for assigned projects.

Performs as a subject matter expert for the department

* Trains staff on project deliverables and acts as a resource for colleagues in the department to answer questions and solve complex problems.
* Conceptualizes and proposes reporting solutions to business leaders throughout the organization.
* Provide training materials, documentation, and suggestions to Enterprise Data Analytics leadership staff concerning data analysis and reporting.
* Ensures data quality, adherence to departmental guidelines, profitability, business impact, and other risk-related metrics for self and members of the team.
* Develops functional specifications and reporting design specifications for assigned projects.
* Uses and presents analytics and metrics to improve processes and provides data-driven forecasts of potential costs, risks, and profits of business initiatives.

SUPERVISORY RESPONSIBILITIES

This role does not have supervisory responsibilities.

EDUCATION AND EXPERIENCE

Bachelor's degree in a quantitative field such as Statistics, Math, Economics, or Computer Science and 5+ years' technical experience in analytics, data science, actuarial or equivalent quantitative field or Master's degree in similar quantitative field required. 5+ years' experience with SQL and SAP Business Objects BI tools (Webi, Crystal, Explorer, Dashboards, etc.) required. 3+ years experience programming in R and/or Python strongly preferred.

CERTIFICATES, LICENSES, REGISTRATIONS

None required.

KNOWLEDGE AND SKILLS

Demonstrated experience with data visualization tools, such as Tableau, is preferred. Strong analytical and problem solving skills. Ability and willingness to continuously acquire new knowledge (business domain knowledge, expertise with software, etc.). Ability to communicate effectively, especially in a cross-functional team setting. Ability to effectively present analysis to ICW staff and external audiences. Knowledge of statistical modeling and machine learning techniques preferred but not required. Familiarity with business operations in the property casualty insurance industry is preferred, but not required.

PHYSICAL REQUIREMENTS

Office environment - no specific or unusual physical or environmental demands and employees are regularly required to sit, walk, stand, talk, and hear.

COMPETENCIES

This position maps to the Individual Contributor level. Additional competencies required: None.

WORK ENVIRONMENT

This position operates in an office environment and requires the frequent use of a computer, telephone, copier, and other standard office equipment.