Data (Business Intelligence) Analyst I

Overview of Job

Comprised of exceptionally bright, observant, innovative, analytical and “outside the box” thinkers who are always asking “Why…Why…Why?”, our Data Analysts are tasked with ensuring that quality data and information is obtained and then integrated, utilized, maintained, analyzed, organized and provided in a usable, timely and relevant manner to all internal and external stakeholders.

Job Responsibilities

In the spirit of our Company’s mission, values and culture, the duties listed below serve as illustrations of the various types of work that may be performed by our Data Analysts. We may also expect our Data Analysts to carry out other responsibilities that are similar, related or a logical assignment to this job class.

Explores, researches, locates and utilizes various sources of public record or vendor data, particularly for application in product development and sales; selects and obtains most appropriate, relevant and quality data/data sets; effectively integrates multiple data sets, as required; meticulously and exhaustively tests and verifies quality of data; performs detailed and timely analyses of a wide variety of simple to highly intricate data and develops accurate, insightful and reasonable interpretations and findings; troubleshoots and resolves data set/database source, quality, integration, and/or interpretation issues.

Builds, maintains, organizes, reviews, analyzes, enhances and disseminates a wide-range of accurate, useful, relevant, usable and complete recurring reports for actionable use by applicable internal team members, senior management, carriers, agents, reinsurers and others; analyzes and optimizes reporting workflows; identifies and makes recommendations to management as to additional and/or new data reports that would be beneficial to the Company, its partners and its customers.

Accurately, thoroughly, thoughtfully and clearly establishes, documents, maintains and updates data management best practices, ensuring compliance with Company, carrier and/or re-insurer quality standards and/or with relevant governmental regulation requirements.

Actively contributes as a member of the Cabrillo Coastal Team by providing assistance and support to assigned team members; collaborates with information systems and product development teams to build infrastructure needed to support upcoming projects; anticipates, identifies, makes recommendations to senior management on and follows-through to address Company’s current and future data needs.

Dynamically enhances Company’s success by taking advantage of learning and development opportunities and personally integrating positive actions to improve individual performance.

Coordinates, oversees, participates in and/or carries out “special” independent and/or group projects, as requested.

Requirements

Skills and Expertise

Qualities: Inquisitive and Innovative Problem Solver; Quality-Oriented; Detail-Oriented; Self-Starter; Team Player; Multi-Tasker; Adaptability; Strong Work Ethic; Positive “Can Do” Attitude; Collaborator; Service-Oriented; Goal-Oriented.

Skill Sets: High level of competency in data manipulation and analysis; demonstrated application of advanced problem analyses/solving skills to unique and interesting challenges; excellent analytical and quantitative skills; project management skills, including the ability to work independently, as required, and meet or exceed project quality and time frame goals; ability to handle multiple, competing priorities simultaneously; organization; time management/working under tight deadlines; active listening skills; highly effective oral and written communication skills, including the ability to effectively, cohesively, accurately and patiently communicate and interpret routine to complex data findings, both in writing and/or when speaking, to a variety of different audiences with a wide range of knowledge bases and experience backgrounds.

Strong knowledge of: SQL; Microsoft Excel; VBA; GIS software; Data Visualization; and other database tools (see “experience” below for further details).

Licenses/Certification: None required.

Education: Bachelor’s Degree in Computer Sciences, Engineering, Management Information Systems, Mathematics, Statistics, or other related field.

Experience: Strong SQL background, including, but not limited to: building tables, inserting data, multiple joins, subqueries, operators, math and string functions, and building procedures; proficiency in Microsoft Excel; VBA experience preferred; columnar database structures beneficial; data visualization experience desired; GIS software experience a plus; professional environment experience preferred; references and work sample/s required.